Integrate PostgreSQL Data Source in Websphere Application Server
A quite unusual configuration but this short guidance might be useful for some persons (like me):
- Open Integrated Solution Console
- Navigate to “Resources -> JDBC -> JDBC Providers”
- Select the right scope for your application
- Click “New”
- Select “User-defined” from “Database Type” dropdown
- Insert “org.postgresql.ds.PGConnectionPoolDataSource” at “Implementation class name” field
- Provide a name and a descriotion of your choice and click “next”
- 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)
- Insert the path and jar file name in the next dialog, click “next” and “finish” afterwards
- Navigate to “Resources -> JDBC -> Data sources”
- Again select the right scope and click “new”
- Provide a Data source and a jndi name (e.g. jdbc/myPGdb)
- On step 2 dialog select your already created JDBC provider
- Just leave step 3 at default values and finish creation, that’s it!
Tested on Websphere Application Server 6.1