running, or compiling with mysql? NoClassDefFoundError

From:

thufir <hawat.thufir@gmail.com>

Newsgroups:

comp.lang.java.help

Date:

Tue, 22 Jul 2008 23:36:15 GMT

Message-ID:

<P9uhk.127617$gc5.90835@pd7urf2no>

A very simpel TestConnection class, which uses the mysql driver. From
netbeans it works fine. (Add the .jar to the library manager, then add
that library to the project, compile, run). There's a complex build file
which NB creates, which I can't read well. Trying to do this from the
command line.

Does javac or java need to add the driver jar for this situation? I've
tried both, but I think this should work (which it isn't):

thufir@arrakis:~/bcit3621/lab5/src$
thufir@arrakis:~/bcit3621/lab5/src$ javac a00720398/lab05/test/
TestConnection.java
thufir@arrakis:~/bcit3621/lab5/src$
thufir@arrakis:~/bcit3621/lab5/src$ java -cp . /usr/share/java/mysql-
connector-java.jar a00720398.lab05.test.TestConnection
Exception in thread "main" java.lang.NoClassDefFoundError: /usr/share/
java/mysql-connector-java/jar
Caused by: java.lang.ClassNotFoundException: .usr.share.java.mysql-
connector-java.jar
    at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
thufir@arrakis:~/bcit3621/lab5/src$
thufir@arrakis:~/bcit3621/lab5/src$ cat a00720398/lab05/test/
TestConnection.java
package a00720398.lab05.test;

import java.sql.*;

public class TestConnection {

    public static void main(String[] args) {

        //String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        //String url = "jdbc:microsoft:sqlserver://j2ee.ca";


        //String userName = "jspweb";
        //String passWord = "jspweb";


        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost/cars";

        String userName = "java";
        String passWord = "password";

        try {
            Class.forName(driver);
            Connection connection = DriverManager.getConnection(url,
userName,
                    passWord);

            DatabaseMetaData dbMetaData = connection.getMetaData();

            System.out.println("database URL: " + dbMetaData.getURL());
            System.out.println("database username: " +
                    dbMetaData.getUserName());
            System.out.println("database product name: " +
                    dbMetaData.getDatabaseProductName());
            System.out.println("database product version: " +
                    dbMetaData.getDatabaseProductVersion());
            System.out.println("JDBC driver name: " +
                    dbMetaData.getDriverName());
            System.out.println("JDBC driver version: " +
                    dbMetaData.getDriverVersion());
            System.out.println("JDBC driver major version: " +
                    new Integer(dbMetaData.getDriverMajorVersion()));
            System.out.println("JDBC driver minor version: " +
                    new Integer(dbMetaData.getDriverMinorVersion()));
            System.out.println("Max number of connections: " +
                    new Integer(dbMetaData.getMaxConnections()));
            System.out.println("MaxTableNameLentgh: " +
                    new Integer(dbMetaData.getMaxTableNameLength()));
            System.out.println("MaxColumnsInTable: " +
                    new Integer(dbMetaData.getMaxColumnsInTable()));

            ResultSet rs = dbMetaData.getTables(null, null, null,
                    new String[]{"TABLE"});

            while (rs.next()) {
                System.out.println(rs.getString(3));
            }

            Statement statement = connection.createStatement();
            ResultSet results = statement.executeQuery("SELECT * FROM
cars");
            ResultSetMetaData rsmd = results.getMetaData();
            System.out.println("The number of columns is: " +
rsmd.getColumnCount());

            for (int i = 1; i <= rsmd.getColumnCount(); i++) {

                System.out.println(rsmd.getColumnName(i));

            }

            connection.close();

        } catch (ClassNotFoundException cnfe) {
            cnfe.printStackTrace();
        } catch (SQLException sqle) {
            sqle.printStackTrace();
        }

    }
}
thufir@arrakis:~/bcit3621/lab5/src$

thanks,

Thufir