Re: jdbc example: java.lang.NoClassDefFoundError - Mailing list pgsql-jdbc

Neil,

Your code looks fine, how are you trying to run this? Is it in a
package?

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Neil Zanella
Sent: November 1, 2001 11:16 PM
To: PostgreSQL JDBC List
Subject: [JDBC] jdbc example: java.lang.NoClassDefFoundError



Hello,

I have been trying to access the postgresql mailing list archives online
but the archives.postgresql.org server as well as a bunch of other
postgresql servers appear to be down and the lists are not (yet)
archived at <http://www.mail-archive.com/lists.html>.

The problem I am experiencing is I have Red Hat 7.1 installed with the
postgresql 7.0 stuff including postgresql-jdbc. I have set my CLASSPATH
to point to /usr/lib/pgsql/jdbc7.0-1.2.jar and have also installed JDK
1.3.1 and updated the PATH variable accordingly. However I am getting
the following error when trying to access a simple postgresql databse.
Any ideas of what might have gone wrong?

Exception in thread "main" java.lang.NoClassDefFoundError:
TestPostgreSQL

Thanks,

Neil

sample code generating the error:

import java.sql.*;

class TestPostgreSQL {
  public static void main(String arg[]) throws SQLException,
ClassNotFoundException {

    String db_driver = "org.postgresql.Driver";
    String db_site = "jdbc:postgresql:joedb";
    String db_user = "joe";
    String db_pass = "doe";

    Class.forName(db_driver);
    Connection connection = DriverManager.getConnection(db_site,
db_user,
db_pass);
    Statement statement = connection.createStatement();
    ResultSet resultset = statement.executeQuery("SELECT * FROM
joetable");
    System.out.println(resultset.getString("joe_column"));

  }
}




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)