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

Elixir Repertoire Repertoire Server
1

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:

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

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

OR

2/MSSQL JDBC with SSL encryption

Driver: com.microsoft.sqlserver.jdbc.SQLServerDataSource

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