PostgreSQL Type 4 JDBC Driver

The JAR file for the PostgreSQL driver is postgresql-8.4-701.jdbc4.jar. 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 Server

• 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.