A SQL Server datasource may fail to connect after upgrading from TIBCO Data Virtualization version 8.0 to a higher version
book
Article ID: KB0074510
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
8.0.x and lower
Description
A SQL Server datasource may fail to connect after upgrading from TIBCO Data Virtualization version 8.0 to a higher version
Resolution
The data source uses a driver jar file to connect to SQL Server. The driver jar needs to be compatible with the JRE version shipped with TDV.
TDV 8.0 is shipped with JRE 8.
TDV 8.2 is shipped with JRE 11.
The driver jar file that you are using with TDV 8.0 is likely to be built for JRE 8 (and not for JRE 11) and so it cannot be used to connect to the SQL Server.
For example, the screenshot below shows that the 8.4 and 8.1 drivers will work with JRE 11:
Based on this, we could choose to download Driver Version 8.4
2. Replace the driver jar in the TDV installation with the new driver jar. For instance, if this is a SQL Server 2016 data source, replace the jar under the folder: <TDV_INSTALL>\conf\adapters\system\microsoft_sql_server_2016 with the new jar.
IMPORTANT: Make sure to extract the right driver jar. For instance, the above screenshot shows that the zip file contains three driver jars:
mssql-jdbc-8.4.1.jre8.jar
mssql-jdbc-8.4.1.jre11.jar
mssql-jdbc-8.4.14.jre8.jar
Of these, the correct jar is mssql-jdbc-8.4.1.jre11.jar (the number ' 11' in the filename indicates that it is intended for JRE 11).
3. If the driver jar is accompanied by a sqljdbc_auth<...>.dll file, copy the DLL to: <TDV_INSTALL>\apps\common\lib\win64
4. Restart the TDV server.
5. Test the data source to verify that it connects to the SQL Server database server.
Issue/Introduction
A SQL Server datasource may fail to connect after upgrading from TIBCO Data Virtualization version 8.0 to a higher version