Return
-
Title
How to switch the JDBC driver for SQL Server -
Description
How to switch from Microsoft JDBC driver to DD driver for SQL Server -
Cause
Starting from Cartridge for SQL Server 5.9.7.23, we ship both Progress DataDirect for JDBC for SQL Server driver (DD driver) version 6.0.0.000401 and Microsoft JDBC Driver 9.2 for SQL Server. The default is the Microsoft driver.
Under certain circumstances, switching from the Microsoft driver to DD driver can be a valid test for troubleshooting connection issues and/or high workload issues.
-
Resolution
To enable the DataDirect driver:
- Connect to the FglAM (Agent Manager)
- Edit [FGLAM_HOME]\state\default\config\baseline.jvmargs.config
- Add "-Dsqlserver.driver.class.name=com.dell.dsgi.jdbc.sqlserver.SQLServerDriver" to the next available vmparameter.X
e.g.
vmparameter.2 = "-Dsqlserver.driver.class.name=com.dell.dsgi.jdbc.sqlserver.SQLServerDriver"
Changes will be applied after restarting the FglAM
Note: This is not intended as a long term-solution if this addresses a particular problem. Please report whenever this has been used as a troubleshooting step.