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"));

}
}