Skip to main content

One post tagged with "PostgreSQL"

PostgreSQL, also Postgres – alongside MySQL and SQLite, one of the most popular open relational database management systems. Initially developed at the University of California, Berkeley and published under the name Ingres.

View All Tags

WebSphere - PostgreSQL data source configuration

· 10 min read
Sławomir Cichy
Sławomir Cichy
Backend Engineer @ Sci Software

To configure a PostgreSQL data source in WebSphere, you need to complete a few steps:

  1. Install the PostgreSQL JDBC driver library in the appropriate WebSphere directory.
  2. Configure JAAS authentication aliases for the data source.
  3. Define a JDBC provider for PostgreSQL.
  4. Create a JDBC data source that will be used by applications running on the WebSphere server.
  5. Set connection parameters, such as the database name, server address, and port number.
  6. Configure additional connection pool parameters, such as the connection age limit.
  7. Apply the changes and start the WebSphere server.
  8. Test the connection to the PostgreSQL database to make sure everything is working properly.