Exception in thread "main" java.lang.ClassNotFoundException
Hello,
I just downloaded the application and I try to connect with my MySQL server in localhost.
My database runs correctly otherwise and I have a JVM 1.7 installed in my system windows 7.
I configured my connection with download function for get drivers for MySQL : mysql-connector-java-5.1.29-bin.jar
My JVM is in the path windows.
My url connection string is : jdbc:mysql://localhost:3306/mydatabase
When I want to test my connection I have a java error which tell me : connection to MySQL - mydatabase@localhost failed : Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:190)
at com.intellij.persistence.database.console.RemoteJdbcServer.main(RemoteJdbcServer.java:15)
OS : windows 7
JVM : 1.7
MySQL : 5.6
Driver : mysql-connector-java-5.1.29-bin.jar
Can you help me to connect my database with 0xDBE ?
Thank for your support and for your application ;)
Please sign in to leave a comment.
Did you try using the default driver that comes with 0xDBE? You said you downloaded a driver but there should have been one shipped with it. I would just start from the beggining, create a datasource, plug in your host/port/db/credentials and then test the connection.
In driver files section in DataSources and drivers, I have click on "+" and locate it on C:\Users\Miltone\.0xDBE10\config\jdbc-drivers\mysql-connector-java-5.1.29-bin.jar.
I think this file it downloaded precedently with 0xDBE and function for downloaded driver automatically.
I try connection with driver files section empty or selectionned driver but the error is the same.
When I use the driver supply with MySQL installer (mysql-connector-java-5.1.26-bin.jar) and I locate it in binary installation for testing connection. It search and try and I waiting waiting but nothing reaction....
The connecting to database don't stop.
My problem were a firewall on windows.
The application must communicate to internet (I don't know why) for run correctly and for after can accept JVM connection for drivers in firewall.
Thank for your support