CODEWITHSUNDEEP
mule
Jek
Jek

Reputation: 5666

Mule - DataMapper throws "Error while validating DB connection."

...org.jetel.connection.jdbc.DBConnection: Error while validating DB connection.
java.lang.NullPointerException
    at org.jetel.connection.jdbc.DBConnection.isValid(DBConnection.java:531)
    at org.jetel.connection.jdbc.DBConnection.getConnection(DBConnection.java:473)
    at org.jetel.lookup.DBLookupTable.preExecute(DBLookupTable.java:188)
    at org.jetel.graph.TransformationGraph.preExecute(TransformationGraph.java:526)
    at com.mulesoft.mule.module.datamapper...

Above is the error that I'm seeing in my MuleStudio console; however, according to datamapper DB lookup validation function (see image below), the DB connection seems fine.

enter image description here

Question: what is causing this error & how to fix this error?

Upvotes: 5

Views: 189

Answers (2)

Sahal
Sahal

Reputation: 4136

For me it fixed when I add the mysql jar path in the project build path selecting the 'add external jar' option.

Build Path -> Configure Build Path -> Libraries -> Ass External Jars.

Upvotes: 0

Valentin Despa
Valentin Despa

Reputation: 42582

It looks like the new Anypoint Studio does not have this issue.

Upvotes: 1

Related Questions