Working with a Connection Pool
Prev Chapter 3. JDBC DataSource Next

Working with a Connection Pool

This section presents an example of setting up a Connection Pool with custom properties.

Configuring JDBC Properties

You can set up a PostgreSQL Connection Pool by completing the following steps:

  1. Configure the PostgreSQL Database to accept SSL connection only.
  2. Make sure the PostgreSQL driver (JAR file) is loaded into the Elixir Repertoire ext folder.
  3. On the Repository panel, create a Connection Pool. The Connection Pool Wizard will display.
  4. On the first page, click Driver Suggestions... and select Postgres. Modify the host and database name in the URL that automatically appears: 
    jdbc:postgresql://host:5432/database
    Enter the username and password.
  5. Click Next. The Connection Pool JDBC Properties page opens.
  6. Click the Add button, a new row of properties will be added. For the Key column, enter ssl. For the Value column, enter true.
  7. Add another row of properties, with the Key column equals to sslfactory and the Value column equals to org.postgresql.ssl.NonValidatingFactory.
  8. Click Finish. Open the Connection Pool properties and test the connection.
Prev Up Next
Working with a JDBC DataSource Home Chapter 4. Composite DataSource