java and mysql

linux_ub · 06-23-2004, 10:02 AM

Hi
i am trying to connect to a mysql database using java
am using the following code

Code:

try {
	Class.forName(className).newInstance();
	con = DriverManager.getConnection(driverName);
	Debugger.debugMessage(programName, "Connected");
} catch (InstantiationException e) {
	Debugger.debugMessage(programName, e);
} catch (IllegalAccessException e) {
	Debugger.debugMessage(programName, e);
} catch (ClassNotFoundException e) {
	Debugger.debugMessage(programName, e);
} catch (SQLException e) {
	Debugger.debugMessage(programName, e);
}

and i get the following error

Code:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	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)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at DbConnect.connect(DbConnect.java:83)

wht could be the problem

thanks

jwstric2 · 06-23-2004, 04:03 PM

Either you are not registering the driver correctly, check the name being registered or the class is not actualy in the path being registered. Usally the driver is featured in a jar file which may be included in your path at run time with -da flag if my memory is right. Between me and you, you will probaly get a better response at www.javasoft.com in their forums. I'll make a bet you can a better worded solution than what I told you there.

mrcheeks · 06-23-2004, 04:14 PM

do you have mysql driver and jdbc librairies in your path??(both are jar files).

german · 06-23-2004, 06:24 PM

both responses above are correct. If you're developing database applications in Java, however, you'll notice a dramatic improvement in reliability and performance with jdbcpool... http://www.bitmechanic.com/ (I'm not affiliated)... it kicks ass... you can make good jdbc apps without it but it keeps you writing proper code by telling you when you don't check connections in etc... it will make your life easier.

HTH

B.

csfalcon · 06-23-2004, 08:19 PM

I was just playing around with JDBC and MySQL, here is my notes:

http://www.csfalcon.com/wiki/csfalcon/JDBC

linux_ub · 06-24-2004, 10:59 AM

thanks a lot to all of you ... i had 2 projects running in eclipse and the code was working inone and not in the other .... figured out tht was not pointing out to the jar files ...

am all set now

thanks to all of you