I am trying to connect
java and mysql using MySQL Connector/J. And I have problem, I don't know where I making mistake.
I am using:
XP OS,
jdk1.6.0_23,
MySQL Community Server 5.5.8
Jar file of the jconnetor is on the location:
C:\Program Files\mysql-connector-java-5.1.14\mysql-connector-java-5.1.14-bin.jar
In command prompt I've set a classpath:
set CLASSPATH="C:\Program Files\mysql-connector-java-5.1.14\mysql-connector-java-5.1.14-bin.jar;"
Code I was using to
test is it working is:
Code compiles without problem.
Error, I get when try to execute: java Connect is:
Exception in
thread "main" java.lang.NoClassDefFoundError: Connect
Caused by: java.lang.ClassNotFoundException: Connect
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: Connect. Program will exit.
I hope someone will help me. I've lost a lot of time, trying to solve problem. Thanks in advance.