Creating an Oracle JDBC connection pool

Ambience 2020+
1

To create an Oracle connection pool on the Ambience 202x Server:

  1. Deploy the ojdbc driver in the \lib or \ext directory of the Ambience 202x installation

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

  3. Edit the oracle.properties file as follows:

  • dataSourceClassName=oracle.jdbc.pool.OracleDataSource
  • dataSource.url=jdbc:oracle:thin:@<servername>:<port>:<database>
  • dataSource.user=
  • dataSource.password=

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

  2. You can encrypt the connection pool password by running bin\ambience-cli.bat at the command line, e.g.

    \Ambience2020\bin>ambience-cli.bat encrypt password

    The command will return the following:
    password = {enc}67uXBxd5Ecxp1BvBgQWGew==

    Go to the properties file and substitute the password, e.g.
    dataSource.password= {enc}67uXBxd5Ecxp1BvBgQWGew==

2

A post was split to a new topic: Creating an Oracle JDBC Connection Pool with Additional Parameters