CODEWITHSUNDEEP
mongodbjdbcmuledatabase-connection
user3165854
user3165854

Reputation: 1655

Error trying to load driver for generic database configuration in Mule

I am using Mule 3.6 and would like to use the bulk insert option on the Generic Database Configuration to load data into mongodb 3.0.8.

I have entered the URL as: jdbc:mongo://localhost:27017/test

and have tried a number of different Mongo and JDBC drivers but keep receiving the message "Test connection failed. Error trying to load driver..."

How can I configure the Generic Database Connector in Mule to connect to Mongo?

Upvotes: 1

Views: 877

Answers (2)

CountD
CountD

Reputation: 669

As already stated in this post, there is no official JDBC driver for MongoDB but one the suggested alternatives is using UnityJDBC.

If you decide to follow the UnityJDBC approach, then:

  1. Download and install the driver by executing the following command:

    java -jar UnityJDBC_Trial_Install.jar

  2. Go to the installation folder and copy mongodb_unityjdbc_full.jar to the classpath of your Mule app.

enter image description here

  1. Configure the URL and Driver in the Global Element of your Generic Database component (the values you provided are OK):

    URL: jdbc:mongo://<host>:<port>/<database>

    Driver Class Name: mongodb.jdbc.MongoDriver

If not, use the MongoDB Connector as suggested by @JoostD.

Upvotes: 1

JoostD
JoostD

Reputation: 744

You need to use the MongoDB connector, it should be included in studio.

Otherwise install it from the Anypoint Exchange:

https://www.mulesoft.com/exchange/#!/mongodb-integration-connector

Also see some example on it:

https://www.mulesoft.com/exchange/#!/importing-csv-into-mongodb

Upvotes: 0

Related Questions