Add the following line in your .login file in your root directory,
create one if it isn't in your root directory.
setenv CLASSPATH /usr/local/pgsql/share/java/postgresql.jar:.
Make sure your put the colon-dot ":." after postgresql.jar
[xxx@cubist~]$ javac Database.java
[xxx@cubist~]$ java Database
Successfully connected to PostgreSQL on cubist!
Beer name is Bud
Beer name is Heineken
Beer name is Rainier
Beer name is Becks
Beer name is Samuel Adams
Beer name is Corona
Beer name is Tecate