MySql help needs
fengzixuan zheng
Ranch Hand
Posts: 31
posted 15 years ago
I got a problem with my codes when I want to connect to a MySql database.
I have successfullly installed the MySql-4.0.0a-alpha-win, and have the MySql services running.
I copy the the mm.mysql-2.0.4-bin.jar to my JDK root-dir: D:\J2SE; so I set the classpath: "D:\J2SE\src.jar; D:\J2SE\mm.mysql-2.0.4-bin.jar"
My codes :
import java.io.*;
import java.sql.*;
import org.gjt.mm.mysql.*;
public class MySqlTest{
Connection DBConn;
ResultSet rs;
Statement stmt;
String dsn;
String query;
public MySqlTest(){
try{
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(ClassNotFoundException ce) {
ce.printStackTrace();
}
}
public static void main(String args[]) {
MySqlTest mst=new MySqlTest();
}
}
Compiles OK, but when running, it gives :
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
����
����
Plesae help me.
Regards
I have successfullly installed the MySql-4.0.0a-alpha-win, and have the MySql services running.
I copy the the mm.mysql-2.0.4-bin.jar to my JDK root-dir: D:\J2SE; so I set the classpath: "D:\J2SE\src.jar; D:\J2SE\mm.mysql-2.0.4-bin.jar"
My codes :
import java.io.*;
import java.sql.*;
import org.gjt.mm.mysql.*;
public class MySqlTest{
Connection DBConn;
ResultSet rs;
Statement stmt;
String dsn;
String query;
public MySqlTest(){
try{
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(ClassNotFoundException ce) {
ce.printStackTrace();
}
}
public static void main(String args[]) {
MySqlTest mst=new MySqlTest();
}
}
Compiles OK, but when running, it gives :
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
����
����
Plesae help me.
Regards
Adam Hardy
Ranch Hand
Posts: 567
posted 15 years ago
Well your compiler is finding the jar files but the application server isn't. You need to check that it has the jar files in the CLASSPATH. Which server is it?
I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
