Mysql connection

Maria Dolores Moral yoyes at dif.um.es
Tue Aug 12 09:45:46 PDT 2003


Hello.
I am working with java and mysql on FreeBSD 4.7.
I use for compile:
javac -classpath /usr/ports/databases/mysql-jdbc-mm/work/mm.mysql-2.0.14:.
Server.java

java -classpath /usr/ports/databases/mysql-jdbc-mm/work/mm.mysql-2.0.14:.
Server

But I obtain the following exception:

> Unable to load driver.
> java.sql.SQLException: Cannot load connection class because of underlying
> exception: 'java.lang.ClassNotFoundException:
> org.gjt.mm.mysql.jdbc2.Connection'.
>         at org.gjt.mm.mysql.Driver.connect(Driver.java:177)
>         at java.sql.DriverManager.getConnection(DriverManager.java:450)
>         at java.sql.DriverManager.getConnection(DriverManager.java:130)
>         at Server.obtainPK(Server.java:73)
>         at Server.main(Server.java:167)
>

 The code is:
 /**********************/
/* Server.java	*/
 /**********************/
 import java.io.*;
 import java.lang.*;
 import java.net.*;
 import java.util.*;
 import org.gjt.mm.mysql.Driver;
 import java.sql.*;

 public static void main(String[] args) throws IOException{
 ...
 try {
 Class.forName("org.gjt.mm.mysql.Driver").newInstance();
 Connection Conn =
DriverManager.getConnection("jdbc:mysql://192.168.0.1/Server","root","caracola"); 
}
 catch (Exception E) {
	System.err.println("Unable to load driver.");
  	E.printStackTrace();
 }
 ...
 }

 If someone know how I can resolve it,please help me.
 Thanks a lot.



More information about the freebsd-net mailing list