The JAR file for the PostgreSQL driver is postgresql-version.jdbc3.jar, for example, postgresql-8.2dev-500.jdbc3.jar. For more information, see http://jdbc.postgresql.org. Configure the connection pool using the following settings:
Name: Use this name when you configure the JDBC resource later.
Resource Type: Specify the appropriate value.
Database Vendor: PostgreSQL
DataSource Classname: org.postgresql.ds.PGSimpleDataSource
Properties:
serverName - Specify the host name or IP address of the database server.
portNumber - Specify the port number of the database server.
databaseName - Set as appropriate.
user - Set as appropriate.
password - Set as appropriate.