This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes mysql-jdbc connection problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "mysql-jdbc connection problem" Watch "mysql-jdbc connection problem" New topic
Author

mysql-jdbc connection problem

jered veld
Greenhorn

Joined: Sep 26, 2002
Posts: 6
i have installed mysql i am running win2000pro.
i am trying to make a small applet to connect to a database named people; so far i havent gotten much success.
the problem is with the driver.
i downloaded the .jar file mm.mysql-2.0.14
i placed this file in the following directory:
c:\mysql\mm.mysql-2.0.14.jar
i then set my classpath to this in a DOS prompt:
set classpath=.;c:\mysql\mm.mysql-2.0.14.jar;%classpath%
here is the code so far:
///////////////////////////////////////////////
import java.sql.*;
public class Lookup{
public static void main(String[] args) throws SQLException, ClassNotFoundException{
String url = "jdbc:mysql://localhost/people";
String user = "";
String password = "";

Class.forName("org.gjt.mm.mysql.Driver");
Connection c = DriverManager.getConnection(url,user,password);
}
it will compile with no errors. when i run
java Lookup it gives me the error:
exeption in thread "main" java.lang.ClassNotFoundException rg.gjt.mm.mysql.Driver
thanks in advance for any help.


java newbie
Hartmut Ludwig
Ranch Hand

Joined: Aug 31, 2002
Posts: 51
I guess your problem is that you did not put the binary jarfile of your MM MySQL Driver to the classpath. You used the the source-jar instead. The binary must be named something like:
mm.mysql-2.0.14-bin.jar.
If you only have this source jarfile you could compile it and add the resulting jar to your classpath.
You can also download the latest Driver-package from here.
The zipfile contains the binary jar called:
mysql-connector-java-2.0.14-bin.jar.
sl
Hartmut
 
 
subject: mysql-jdbc connection problem