From HoerupWiki
Jump to: navigation, search

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


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 In order to enabled JMX Remote console in GFv3 change address to local ip instead of in "admin console"->"admin service"


note that you can install the entire GlassFish v3 documentation straight from your v3 install using the update center. This will place the HTML version of the docs in glassfish/docs/manuals/. You can use bin/updatetool or simply type bin/pkg install glassfish-docs.

To reload an app from console create a .reload file in the application directory - "touch <path to glassfish>/glassfish/domains/<domain>/applications/<application>/.reload" (or press the reload button on the web-console)

Default loglevel for the java.util.logging is set to info ... if you want to change that edit <glassfish-path>/glassfish/domains/<domain>/config/ (you may want to set this or just set your own app packagename to fine on your development installation)