Steps to switch the database driver for MSSQL from JTDS to JDBC from ConnectALL UI.

Products

• ConnectALL

Issue/Introduction

This is only applicable if you are using MSSQL database with ConnectALL.

Please note that ConnectALL does not support JTDS driver from 3.5.0 version onwards and it is mandatory to switch the driver if you are willing to upgrade to 3.5.0 version or higher.

This article covers the steps to switch the MSSQL driver from JTDS to JDBC.

Environment

2.11.x - 3.4.x

Resolution

Follow below steps-

In case the current driver being used in JTDS with SQL Server Authentication

• Copy the mssql-jdbc jar in ..\UI\tomcat\lib directory
• Copy the mssql-jdbc jar in ..\Core\lib directory
• Copy the mssql-jdbc jar in ..\Scheduler\lib directory
• Open the following in any text editor ..\.install4j\.response.varfile 
• Make required changes in below properties for JDBC driver to avoid failure while upgrading next application version

DRIVER_JAR=C\:\\tmp\\mssql-jdbc-7.4.1.jre8.jar
DRIVER_JAR_NAME=mssql-jdbc-7.4.1.jre8.jar
INSIGHTS_DRIVER_JAR_NAME=mssql-jdbc-7.4.1.jre8.jar

• Restart connectall-ui service, connectall-broker service, connectall-core service, connectall-scheduler service,
• Login to ConnectALL UI and Database Settings screen,
• Change the driver from JTDS to SQL Server, update the connection URL and validate the connection to save the changes.
• Restart the connectall-ui service once the changes are saved.
• Login to ConnectALL UI to verify the driver is switched.

 

In case the current driver being used in JTDS with Windows Server Authentication

• All above steps to be followed, in addition required changes need to be done in ..\Core\conf\db.properties file. Refer below TechDocs link for more details.