Neil-
The code looks pretty good to me. Try looking here for a couple of ideas
about what can cause this error:
http://www.fankhausers.com/postgresql/jdbc/#classnotfound
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Neil Zanella
> Sent: Thursday, November 01, 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)
>
