Where to add JDBC Mysql Driver for external connection

Camunda 7 Topics Discussion & Questions
1

I want to connect to a external server via Service Task and JDBC Connection

example con in Service Task:

con= DriverManager.getConnection(“jdbc:mysql://127.0.0.1/test”,“root”,“”);

where do I have to add the JDBC Driver so I can build an external connection?
I tried adding it to the maven project path like for a normal java applet
I tried adding it to the tomcat/lib and to the tomcat/server/lib
but the log still throws “no suitable driver found for…”

To clear this out, I don’t want to run camunda in mysql, I want to connect to a external mysql database and store the execution variables as persistent data.

thanks for your help & best regards

2

Hi @bschroet,

you have to add the JDBC Driver jar to “tomcat/server/apache-tomcat-8.0.24/lib”. You need a provided dependency in your maven pom to find the JDBC Driver in your application.
Make sure that you restart the server after adding the JDBC Driver jar.

Cheers
kristin

1 Like
3

DId it solve your problem ? Because im having the same problem and eventhough i follow those instructions i always get an error when i try to connect to the database ( unsuccessful http request).