A SQL Server datasource may fail to connect after upgrading from TIBCO Data Virtualization version 8.0 to a higher version

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.

Please do the following:

1.   Refer to the section titled Java and JDBC specification support on the Microsoft JDBC Driver for SQL Server support matrix page, and download a driver compatible with JRE 11.

For example, the screenshot below shows that the 8.4 and 8.1 drivers will work with JRE 11:
        User-added image

Based on this, we could choose to download Driver Version 8.4

User-added image
     
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.

User-added image

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

User-added image

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