This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
Hi, I am having problem with loading JDBC driver, and need your diagnotic help. 1. I have installed MySQL (C:\mysql), created a databse (soup), and created a little table (VIDEOS). I am able to see the table in the console: sql>select * from videos 2. I have downloaded the latest version of Connector/J (mysql-connector-java-3.1.0-alpha.zip), and unzip the zip file into my C:\ directory. 3. I copied the mysql-connector-java-3.1.0-alpha-bin.jar to the C:\j2sdk1.4.1_02\jre\lib\ext folder and it is in my CLASSPATH 4. MySQL server is running C:\> C:\mysql\bin\mysqld-nt --standalone 5. open another DOS window and use the database mysql>USE SOUP 6. succesfully compiled a Java program (javac Test.java):
7. when I run the Java program (java Test), I got the message: could not load JDBC driver: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver What am I missing? [ March 21, 2003: Message edited by: JiaPei Jen ] [ March 21, 2003: Message edited by: JiaPei Jen ] [ March 21, 2003: Message edited by: JiaPei Jen ]
Perhaps something is different or wrong with the alpha JConnector driver you're using. What happens when using the stable version 3.0.6? Also, how are you running the app? From the command line or through an IDE? and which IDE?