- Connecting to PostgreSQL

Connecting to PostgreSQL

The connection properties that are unique to PostgreSQL are the URL, Driver, User ID, and Password.

They must be exactly as follows:

• • URL - jdbc:postgresql://hostname:port/databasename

    • (where hostname is your IP address, port is an optional port # (default is 5432), and databasename is the database)

  • JDBC Driver - PostgreSQL (org.postgresql.Driver)

  • User ID - Any valid user ID

  • Password - Password for above User ID

Here is a sample PostgreSQL connection:

Optional Properties include: ssl, sslfactoryarg, compatible , protocolVersion , loglevel ,

charSet , allowEncodingChanges and prepareThreshold.

NOTE: You'll need to download the lastest postgresql jar from http://jdbc.postgresql.org and install it into your web applications WEB-INF/lib folder