Trouble connecting to MySQL - Driver not found.

Classic Servoy
1

I am trying to set up Servoy to work with MySql on my local windows computer.

I’ve installed the jar file called
“mysql-connector-java-3.1.13-bin” into the Servoy/Drivers directory.

I’ve got MySQL running as a service and can connect to it with my browser. However, when I try and connect to it via Servoy Developer I get the following message

“java.sql.SQLException: JDBC Driver ‘org.gjt.mm.mysql.Driver’ not found in classpath or drivers directory : java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver org.gjt.mm.mysql.Driver”

Can anybody let me know where I’m going wrong?

Many thanks

MerMer

2

Hi MerMer

If you are using Servoy 3.0 you may need to use the latest connector: mysql-connector-java-5.0.3-bin.jar - and not mysql-connector-java-3.1.13-bin_jar. I was unable to save new records with the ‘3.1.13’ jar file but no problems after installing ‘5.0.3’

Graham Greensall
Worxinfo Ltd

3

Thanks Graham,

I managed to get the connection to work by placing a copy of the driver in both my JAVA directory and the SERVOY/DRIVERS directory.

MerMer