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

Working with a Connection Pool

In this section we will review an example of setting up a Connection Pool with custom properties.

Configuring JDBC Properties

For example, you can set up a PostgreSQL Connection Pool by completing the steps below:

  1. Configure the PostgreSQL Database to accept SSL connection only.
  2. Make sure the PostgreSQL driver (JAR file) is loaded into 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 the Finish button. Open the Connection Pool properties and test connection.
Prev Up Next
Working with a JDBC DataSource Home Chapter 4. Composite DataSource