Creating a Postgresql JDBC connection pool

Ambience 2020+
1

This entry guides you through the steps to create a Postgresql connection pool on the Ambience/Repertoire 202x server.

  1. Deploy the Postgresql driver in the \lib directory of the Ambience/Repertoire 202x installation.
    Do refer to the following link to get a copy of the JDBC driver if required.

  2. Go to \etc directory, make a copy and rename hikari-sample.properties, e.g. postgresql.properties

  3. Edit the mssql.properties file as follows:
    **Do edit the values as required.

dataSourceClassName=org.postgresql.ds.PGSimpleDataSource
dataSource.user=<username>
dataSource.password=<encrypted-password>
dataSource.databaseName=<dbname>
dataSource.portNumber=<port>
dataSource.serverName=<servername>
dataSource.url=jdbc:postgresql://<hostname>:<port>/<dbname>

  • If you wish to declare the schema name, revise the parameter value for dataSource.url as follows:

dataSource.url=jdbc:postgresql://<hostname>:<port>/<dbname>?currentSchema=<schemaName>

  1. Edit the application.conf file to point to the Postgresql connection properties. Substitute “sample” with the actual database name e.g.
elixir.data.jdbc {
connection-pool {
implementation = “hikari”
definition {
sample = “./etc/postgresql.properties”
  }
 }
}

  1. Restart the Ambience/Repertoire server.

  2. If successful, the following message would be logged in your ambience/repertoire logs:

    1200×123 5.86 KB