Setting up the Class Path

To use the driver, the JAR archive named postgresql.jar if you built from source, otherwise it will likely be (named with the following convention: postgresql-*[server version]*.*[build number]*.jdbc*[JDBC version]*.jar , for example postgresql-8.0-310.jdbc3.jar ) needs to be included in the class path, either by putting it in the CLASSPATH environment variable, or by using flags on the java command line.

For instance, assume we have an application that uses the JDBC driver to access a database, and that application is installed as /usr/local/lib/myapp.jar . The PostgreSQL JDBC driver installed as /usr/local/pgsql/share/java/postgresql.jar . To run the application, we would use:

export CLASSPATH=/usr/local/lib/myapp.jar:/usr/local/pgsql/share/java/postgresql.jar:.
java MyApp

Loading the driver from within the application is covered in Chapter 3, Initializing the Driver .