wise-coders / mongodb-jdbc-driver Goto Github PK

Does this driver support SSL? If so, then how can we pass it the cert?
for example:

jdbc_connection_string => "jdbc:mongodb://user:password@localhost:27017/testDb?authMechanism=DEFAULT&tls=true&tlsCAFile=/home/ca-bundle.pem"

but this doesn't work. Is there any other way?

Hi, there is a question i want to ask you. I use mogodb driver to connector mongodb,

uri is mongodb://admin:admin@localhost:27017/test1?authSource=admin

but when i execute "db" it returns admin, not test1. and when i execute "use test1; db.a.find();" it will execute in admin, not in test1

i want to execute shell command in test1 but not admin ,what can i do?

when i use "count()" then return null.
sql like this
db.getCollection("book").count()
the result is null

Hi,
when I first use this driver，an error happened like this:

java.lang.IllegalArgumentException: Could not find option with name engine.WarnInterpreterOnly.
	at com.oracle.truffle.polyglot.PolyglotEngineException.illegalArgument(PolyglotEngineException.java:130)
	at com.oracle.truffle.polyglot.OptionValuesImpl.failNotFound(OptionValuesImpl.java:283)
	at com.oracle.truffle.polyglot.OptionValuesImpl.failNotFound(OptionValuesImpl.java:263)
	at com.oracle.truffle.polyglot.OptionValuesImpl.findDescriptor(OptionValuesImpl.java:240)
	at com.oracle.truffle.polyglot.OptionValuesImpl.put(OptionValuesImpl.java:142)
	at com.oracle.truffle.polyglot.OptionValuesImpl.putAll(OptionValuesImpl.java:137)
	at com.oracle.truffle.polyglot.PolyglotImpl.createEngineOptions(PolyglotImpl.java:292)
	at com.oracle.truffle.polyglot.PolyglotImpl.buildEngine(PolyglotImpl.java:234)
	at org.graalvm.polyglot.Engine$Builder.build(Engine.java:546)
	at org.graalvm.polyglot.Context$Builder.build(Context.java:1687)
	at com.wisecoders.dbschema.mongodb.MongoConnection.createContext(MongoConnection.java:413)
	at com.wisecoders.dbschema.mongodb.MongoPreparedStatement.executeQuery(MongoPreparedStatement.java:132)

Can you help me? thanks

I use this driver connect operator mongodb,Connection by JDBC,but i find many functions not supported, just like aggregate、group、findOne etc, Is there any other way to solve it，Thanks！

Download JDBC Driver Binary Distribution
URL is invalid ? (http://www.dbschema.com/jdbc-drivers/MongoDbJdbcDriver.zip)

Hi author, I need dynamic collection query like this:

var cNames=db.getCollectionNames();
cNames.forEach(cName=>{
db.getCollection(cName).aggregate([
{
    $addFields:{
       Amount:{$convert:{input:"$Amount",to:"double"}},
       Tax:{$convert:{input:"$Tax",to:"double"}},
       "StandingBook.发货数量":{$convert:{input:"$StandingBook.发货数量",to:"double"}},
       "StandingBook.重量":{$convert:{input:"$StandingBook.重量",to:"double"}},
       "FormulaAllParValues.Value":{$convert:{input:"$FormulaAllParValues.Value",to:"double"}},
       Id:"$Code"
    }
},
{
    $project:{
        _id:0,
        'StandingBook._id':0,
        'SettlementItem._id': 0,
        'CreatorUserId': 0,
        'StandingBook.SettlementItemDetails': 0
    }
}
])
);

but jdbc give me an error:

[2020-11-07T17:41:01,088][ERROR][logstash.inputs.jdbc     ][main][6a89ac33de18aa569ee620919af323e74f27b74ea0e732c5bfc48ff54f2f21de] Java::JavaSql::SQLException: <eval>:3:2 Expected : but found .
db.getCollection(cName).aggregate([
  ^ in <eval> at line number 3 at column number 2: var cNames=db.getCollectionNames();
cNames.forEach(cName=>{
db.getCollection(cName).aggregate([
{
    $addFields:{
       Amount:{$convert:{input:"$Amount",to:"double"}},
       Tax:{$convert:{input:"$Tax",to:"double"}},
       "StandingBook.发货数量":{$convert:{input:"$StandingBook.发货数量",to:"double"}},
       "StandingBook.重量":{$convert:{input:"$StandingBook.重量",to:"double"}},
       "FormulaAllParValues.Value":{$convert:{input:"$FormulaAllParValues.Value",to:"double"}},
       Id:"$Code"
    }
},
{
    $project:{
        _id:0,
        'StandingBook._id':0,
        'SettlementItem._id': 0,
        'CreatorUserId': 0,
        'StandingBook.SettlementItemDetails': 0
    }
}
])
);

Any chance we can get the jars in a tar distribution as well?

The reason being is that I want to gain access to it in this docker image using a startup script.

Weirdly tar is available as a tool, but unzip isn't. While yum exists, sudo doesn't so I am unable to download them.

I am aware I can create my own Dockerfile where this wouldn't be an issue as I'd use this as a base image, but I'm trying to avoid that.

The license is unclear to me:

• https://github.com/wise-coders/mongodb-jdbc-driver/blob/master/License.txt looks like Apache License (i.e. can be used in commercial software)
• README.md mentions about GPL3 (which in most cases can't be used in commercial software without publishing commercial software source code)

How is that, can mongodb-jdbc-driver be used in commercial software (just as JDBC driver JAR, no driver's source code modifications), or not?

any chance we can get the underlying java mongodb driver upgraded? https://github.com/wise-coders/mongodb-jdbc-driver/blob/master/build.gradle#L22

4.3 or above is required for mongodb serverless. IntelliJ uses this driver to connect to mongodb, so without an upgrade, I am unable to connect to mongodb from IntelliJ.

thanks!

I get the error message: can't find the jdbc driver class : "com.dbschema.MongoDbJdbcDriver" What am I doing wrong?

Hi, I'm going to test sync mongo data to es using logstash-input-jdbc, I found here said The driver is compatible with Java 8, but when I use this Driver in logstash, I saw the following error logs:

Java::JavaLang::UnsupportedClassVersionError: org/graalvm/polyglot/proxy/ProxyObject has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0

does this mean the driver now only compatible with JAVA 11? or is there any other solution?