What is the reason behind the presence of only one csjdbc.jar file for TIBCO Data Virtualization 8.8?
Article ID: KB0070471
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.8 |
Description
- In TDV 8.8, the TIB_tdv_drivers_8.8.0_all.zip package solely contains the
csjdbc.jar. - In TDV 8.7.0, the TIB_tdv_drivers_8.7.0_all.zip package is equipped with both
csjdbc.jarandcsjdbc8.jarfiles. - In TDV 8.5.0, the TIB_tdv_drivers_8.5.0_all.zip package is equipped with both
csjdbc.jarandcsjdbc7.jarfiles.
Issue/Introduction
This article will address the question of why we only see the csjdbc.jar and not the csjdbc8.jar file in TDV 8.8 directory, whereas both the files are present in other TDV versions.
Environment
All Supported OS
Resolution
Types of JDBC drivers before TDV 8.8:
Earlier there were two types of JDBC drivers provided by TIBCO Data Virtualization:
For eg below is for TDV 8.7.
(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.
The above was the reason why earlier we had different JDBC drivers.
However, from TDV 8.8 we have decided to have only one JDBC driver i.e. csjdbc.jar file which supports all JDBC client tools that use older JDKs i.e. before Java 17(8, 11 & 17) like SPOTFIRE. Hence, you can use the csjdbc.jar file only in SPOTFIRE or any other JDBC client tool.
Earlier there were two types of JDBC drivers provided by TIBCO Data Virtualization:
For eg below is for TDV 8.7.
(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.
The above was the reason why earlier we had different JDBC drivers.
However, from TDV 8.8 we have decided to have only one JDBC driver i.e. csjdbc.jar file which supports all JDBC client tools that use older JDKs i.e. before Java 17(8, 11 & 17) like SPOTFIRE. Hence, you can use the csjdbc.jar file only in SPOTFIRE or any other JDBC client tool.
Additional Information
https://docs.tibco.com/pub/tdv/8.8.0/doc/pdf/TIB_tdv_8.8.0_InstallationGuide.pdf?id=0#page=24
Feedback
Yes
No
Powered by
