File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes MySql help needs Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MySql help needs" Watch "MySql help needs" New topic

MySql help needs

fengzixuan zheng
Ranch Hand

Joined: Aug 02, 2001
Posts: 31
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.sql.*;
public class MySqlTest{
Connection DBConn;
ResultSet rs;
Statement stmt;
String dsn;
String query;
public MySqlTest(){
catch(ClassNotFoundException ce) {
public static void main(String args[]) {
MySqlTest mst=new MySqlTest();

Compiles OK, but when running, it gives :

Plesae help me.
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 567
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.
david long

Joined: Apr 16, 2001
Posts: 8
Hi, fengzixuan zheng
try putting your drive jar file into D:\J2SE
/jre/lib/ext directory, so and you even don't need use classpath for your driver.
if 'ext' folder no exsit, make one.
jQuery in Action, 3rd edition
subject: MySql help needs
jQuery in Action, 3rd edition