How To
Summary
JDBC stages - How to check the drivers shipped within SDC and its versions?
Objective
In this article, we aim to explain the JDBC drivers shipped within Data Collector and how to check their version included.
Steps
There are 5 supported DBs for JDBC stages: MariaDB, PostgreSQL, Microsoft SQL Server, MySQL, and Oracle:
Data Collector shipped drivers for JDBC:
MariaDB
PostgreSQL
Microsoft SQL Server
Data Collector drivers not shipped for JDBC:
MySQL
Oracle
The shipped drivers (MariaDB, PostgreSQL, and Microsoft SQL Server) are updated for every Data Collector release, therefore, their version can change between different Data Collector versions. We can check the driver version included in our data collector in the path:
SDC_FOLDER/streamsets-libs/streamsets-datacollector-jdbc-lib/lib
You can check the versions for the specific version by entering this folder and running:
cd SDC_FOLDER/streamsets-libs/streamsets-datacollector-jdbc-lib/lib ls maria* ls postgres* ls mssql*
Output example: running this in Data Collector 5.9.0 returns the driver versions for MariaDB, PostgreSQL, and Microsoft SQL Server respectively:
mariadb-java-client-3.0.5.jar postgresql-42.7.1.jar mssql-jdbc-12.4.2.jre8.jar
Results
We should not install the drivers for the three drivers shipped within Data Collector: MariaDB, PostgreSQL, and Microsoft SQL Server. If the JDBC connection string is correct, the stage will use the shipped driver automatically.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
16 March 2025
UID
ibm17186344