AppServer

Integrate PostgreSQL Data Source in Websphere Application Server

Fra http://www.thapole.net/coding/java/2006/10/12/integrate-postgresql-data-source-in-websphere-application-server/

A quite unusual configuration but this short guidance might be useful for some persons (like me):

  1. Open Integrated Solution Console
  2. Navigate to “Resources -> JDBC -> JDBC Providers”
  3. Select the right scope for your application
  4. Click “New”
  5. Select “User-defined” from “Database Type” dropdown
  6. Insert “org.postgresql.ds.PGConnectionPoolDataSource” at “Implementation class name” field
  7. Provide a name and a descriotion of your choice and click “next”
  8. If you haven’t done so before download the JDBC Driver from http://jdbc.postgresql.org/download.html which suits your needs (should be JDBC3 driver for your DB version) and save it at some local library path (e.g. {WAS_HOME}/lib)
  9. Insert the path and jar file name in the next dialog, click “next” and “finish” afterwards
 10. Navigate to “Resources -> JDBC -> Data sources”
 11. Again select the right scope and click “new”
 12. Provide a Data source and a jndi name (e.g. jdbc/myPGdb)
 13. On step 2 dialog select your already created JDBC provider
 14. Just leave step 3 at default values and finish creation, that’s it!

Tested on Websphere Application Server 6.1

Glassfish

Postgresql: If using jdbc3 driver: Add a property to the connection pool: JDBC30DataSource=true

JMX (glassfish2.1): add -Djava.rmi.server.hostname=<hostname> to jvm options link