Creating MSSQL Connection Pool in Ambience 4.x/Repertoire 8.x

You will need to download and place the JDBC Driver in /lib directory of your Elixir Repertoire installation folder.

Below is the default driver class and URL syntax to setup the connection pool, depending on the type of MSSQL JDBC driver you are using, e.g.

1/Default MSSQL JBDC connection:


URL: jdbc:sqlserver://:;DatabaseName=


2/MSSQL JDBC with SSL encryption


URL: jdbc:sqlserver://:;databaseName=;encrypt=true;trustServerCertificate=true;

Your side will need to conduct testing to determine the appropriate driver and JDBC configuration that work best with your specific database setup and environment