TIBCO Data Virtualization offers two JDBC drivers: csjdbc.jar and csjdbc8.jar. Both drivers conform to JDBC API 4.0, providing essential connectivity to your Data Virtualization environment. The key difference between them is their compatibility with Java versions, which is essential to consider when choosing the right driver for your client tool.
NOTE : You don't need to upgrade your Java version to use csjdbc.jar or csjdbc8.jar. This article guides you on how to select the appropriate driver based on your client tool's Java compatibility.

This article provides information on the various types of JDBC drivers provided by TIBCO Data Virtualization.

All Supported Environments.

Types of JDBC drivers:

There are two types of JDBC drivers provided by TIBCO Data Virtualization:

(1) JRE v11 (csjdbc.jar) and conforms to JDBC API 4.0 
---> "csjdbc jar" is compatible with Java versions up to the version that is bundled with or supported by TDV. The exact Java version it supports may vary depending on TDV's release and requirements.

(2) JRE v1.8 (csjdbc8.jar) and conforms to JDBC API 4.0
---> The number '8' in csjdbc8.jar means 'compatible with Java 1.8'. So if the JDBC client is using JRE 1.7, you will need to use csjdbc7.jar. If the JRE is 1.8, you will need csjdbc8.jar. 
 

Choosing the right Driver:

The choice between csjdbc.jar and csjdbc8.jar depends on the Java version supported by your client tool. 

Example 1: DBVisualizer:

• Determine the Java version supported by DBVisualizer. If it supports Java 1.8 or higher, use csjdbc.jar for optimal performance.
• To configure DBVisualizer to use the driver, you can usually provide the path to the JAR file in the database connection settings.

Example 2: Spotfire 12

• Connect to TIBCO Data virtualization published views data via the Spotfire Information link using the TDV JDBC driver (csjdbc8.jar), which should be located in the Spotfire Server directory [Spotfire Installation Directory]\tomcat\spotfire-lib.
• Refer to the Knowledge Base Article for comprehensive instructions: https://support.tibco.com/s/article/000046233

NOTE : Some clients might not be JDBC-4.0 compliant. An older version of the csjdbc.jar is available from Support to support older JDBC interfaces. If you have a previous release of TDV, you can use the csjdbc.jar file provided with that release.

Please reach out to TIBCO support if you need assistance in picking the right JDBC driver for your use case.