How to update the JDBC driver in ConnectALL

Products

• ConnectAll On-Prem
• ConnectALL

Issue/Introduction

At times it may be necessary to update the JDBC driver due to bug fixes, or performance enhancements.

Resolution

Determine the JDBC driver needed, based on database flavor and Java version.  Currently, ConnectALL uses Java 11

It will be necessary to download the driver from the database vendor, as ConnectALL does not provide these drivers.

1. Update <CONNECTALL_HOME>/.install4j/response.varfile so that
   DRIVER_JAR=/path/to/driver/<new_driver_name> (note the path location for later, for example /tmp)
   DRIVER_JAR_NAME=<newdriver_name>
   INSIGHTS_DRIVER_JAR_NAME=<new_driver_name>
2. Replace the old driver with the new driver in the following locations:
   <CONNECTALL_HOME>/UI/tomcat/lib
   <CONNECTALL_HOME>/Core/lib
   <CONNECTALL_HOME>/Scheduler/lib
   <CONNECTALL_HOME>/Orphan/lib
   DRIVER_JAR location noted above
3. If using MS SQL it may be necessary to update<CONNECTALL_HOME>/Core/conf/db.properties to include
   encrypt=true;trustServerCertificate=true
4. Restart UI, Core, Scheduler, and Orphan services