[Connector\J] NoClassDefFoundError

• Previous message: David Harper: "Re: [SOLARIS - MySQL 3.23.58] Fatal error: Can't change to run as user 'mysql' ;"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Sun, 25 Jan 2004 14:57:38 +0100

Hi!

I know it has been asked here and in other groups before but none of the
answers helped me.
I'm trying to connect to MySQL using Connetor/J but when I test the
driver I get the following error:
"Exception in thread "main" java.lang.NoClassDefFoundError:
com/stardeveloper/example/JdbcExample1"
Here is my testing configuration:
WinXP SP1, MySQL 4.0.17, j2sdk-1_4_1_02-windows-i586,
mysql-connector-java-3.0.10-stable-bin.jar.

The j2sdk is in C:\java\ the connector is in:
C:\java\jre\lib\ext\mysql-connector-java-3.0.10-stable-bin.jar
I don't know why the JRE is also in Program Files but i copied the
connector also there:
C:\Program
Files\Java\j2re1.4.1_02\lib\ext\mysql-connector-java-3.0.10-stable-bin.jar
My CLASSPATH is set as system variable:
.;C:\java\jre\lib\ext\mysql-connector-java-3.0.10-stable-bin.jar

I'm a newbie to java so I was trying to run a simple JDBC example from
stardeveloper.com:

package com.stardeveloper.example;

import java.sql.*;

public class JdbcExample1 {

   public static void main(String args[]) {
     Connection con = null;

     try {
       Class.forName("com.mysql.jdbc.Driver").newInstance();
       con = DriverManager.getConnection("jdbc:mysql:///db", "usr",
"passwd");

       if(!con.isClosed())
         System.out.println("Successfully connected to MySQL server...");

     } catch(Exception e) {
       System.err.println("Exception: " + e.getMessage());
     } finally {
       try {
         if(con != null)
           con.close();
       } catch(SQLException e) {}
     }
   }
}

I ran it in many different ways, with and without the CLASSPATH, with
the -cp (or -classpath), and I still got the same error. It compiles OK,
when I run javac -verbose I get this output:

C:\java\bin>javac -verbose JdbcExample1.java
[parsing started JdbcExample1.java]
[parsing completed 78ms]
[loading C:\java\jre\lib\rt.jar(java/sql/Connection.class)]
[loading C:\java\jre\lib\rt.jar(java/sql/DriverManager.class)]
[loading C:\java\jre\lib\rt.jar(java/sql/SQLException.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/Object.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/String.class)]
[checking com.stardeveloper.example.JdbcExample1]
[loading C:\java\jre\lib\rt.jar(java/lang/Class.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/System.class)]
[loading C:\java\jre\lib\rt.jar(java/io/PrintStream.class)]
[loading C:\java\jre\lib\rt.jar(java/io/FilterOutputStream.class)]
[loading C:\java\jre\lib\rt.jar(java/io/OutputStream.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/Exception.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/Throwable.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/Error.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/ClassNotFoundException.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/RuntimeException.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/InstantiationException.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/IllegalAccessException.class)]
[loading C:\java\jre\lib\rt.jar(java/lang/StringBuffer.class)]
[wrote JdbcExample1.class]
[total 1750ms]

I don't know what else could be the problem. Could somebody help me?

G.W.

• Previous message: David Harper: "Re: [SOLARIS - MySQL 3.23.58] Fatal error: Can't change to run as user 'mysql' ;"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]