Certified databases and JDBC driver Jars
The database drivers which have been tested and officially approved for compatibility with a specific database version and environment.
JDBC Driver Jars for Microsoft SQL Server
Download Path https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16
| Driver Version | Driver Jar Name | Java™ Version | Supported DB Versions |
|---|---|---|---|
| 4.1 | sqljdbc41.jar | 7 | Microsoft SQL Server 2008, 2012, 2014, 2016 and Azure SQL Database |
| 4.2 | sqljdbc41.jar | 7 | Microsoft SQL Server 2008, 2012, 2014, 2016 and Azure SQL Database |
| 4.2 | sqljdbc42.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016 and Azure SQL Database |
| 6.0 | sqljdbc41.jar | 7 | Microsoft SQL Server 2008, 2012, 2014, 2016 and Azure SQL Database |
| 6.0 | sqljdbc42.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016 and Azure SQL Database |
| 6.2.2 | mssql-jdbc-6.2.2.jre7.jar | 7 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017, and Azure SQL Database |
| 6.2.2 | mssql-jdbc-6.2.2.jre8.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017 and Azure SQL Database |
| 6.4.0 | mssql-jdbc-6.4.0.jre7.jar | 7 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017 and Azure SQL Database |
| 6.4.0 | mssql-jdbc-6.4.0.jre8.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017 and Azure SQL Database |
| 7.0.0 | mssql-jdbc-7.0.0.jre8.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017 and Azure SQL Database |
| 7.2.2 | mssql-jdbc-7.2.1.jre8.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017 and Azure SQL Database |
| 7.4.1 | mssql-jdbc-7.4.1.jre8.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017 and Azure SQL Database |
| 8.2 | mssql-jdbc-7.2.1.jre8.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017, 2019 and Azure SQL Database |
| 8.4 | mssql-jdbc-7.2.1.jre8.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017, 2019 and Azure SQL Database |
| 9.2 | mssql-jdbc-7.2.1.jre8.jar | 8 | Microsoft SQL Server 2008, 2012, 2014, 2016, 2017, 2019 and Azure SQL Database |
| 12.6 | mssql-jdbc-12.6.0.jre8.jar | 8 | Microsoft SQL Server 2022 |
JDBC Driver Jars for Oracle
Download Path - https://www.oracle.com/in/database/technologies/appdev/jdbc-downloads.html
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 12.1.0.1 | ojdbc6.jar | 6 | Oracle 12.1, 12.2, 18.3, 19.x |
| 12.1.0.1 | ojdbc7.jar | 7, 8 | Oracle 12.1, 12.2, 18.3, 19.x |
| 12.1.0.1 | xdb6.jar | 6, 7 | Oracle 12.1, 12.2, 18.3, 19.x |
| 12.1.0.1 | xmlparserv2-12.1.0.1.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 12.1.0.2 | ojdbc6.jar | 6 | Oracle 12.1, 12.2, 18.3, 19.x |
| 12.1.0.2 | ojdbc7.jar | 7, 8 | Oracle 12.1, 12.2, 18.3, 19.x |
| 12.1.0.2 | xdb6.jar | 6, 7 | Oracle 12.1, 12.2, 18.3, 19.x |
| 12.1.0.2 | xmlparserv2-12.1.0.2.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 12.2.0.1 | ojdbc8.jar | 8 | Oracle 12.1, 12.2, 18.3, 19.x |
| 12.2.0.1 | xdb6.jar | 7, 8 | Oracle 12.1, 12.2, 18.3, 19.x |
| 12.2.0.1 | xmlparserv2-12.2.0.1.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 18.3 | ojdbc8.jar | 8,9,11 | Oracle 12.1, 12.2, 18.3, 19.x |
| 18.3 | xdb6.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 19.3 | ojdbc8.jar | 8,9,11 | Oracle 12.1, 12.2, 18.3, 19.x |
| 19.3 | xdb6.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 19.6 | ojdbc8.jar | 8,9,11 | Oracle 12.1, 12.2, 18.3, 19.x |
| 19.6 | xdb6.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 19.6 | xmlparserv2.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 19.7 | ojdbc8.jar | 8,9,11 | Oracle 12.1, 12.2, 18.3, 19.x |
| 19.7 | xdb6.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 19.7 | xmlparserv2.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 19.8 | ojdbc8.jar | 8,9,11 | Oracle 12.1, 12.2, 18.3, 19.x |
| 19.8 | xdb6.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 19.8 | xmlparserv2.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 19.9 | ojdbc8.jar | 8,9,11 | Oracle 12.1, 12.2, 18.3, 19.x |
| 19.9 | xdb6.jar | Oracle 12.1, 12.2, 18.3, 19.x | |
| 19.9 | xmlparserv2.jar | Oracle 12.1, 12.2, 18.3, 19.x |
JDBC Driver Jars for PostgreSQL
Download Path - https://jdbc.postgresql.org/download/
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 42.2.5 | postgresql-42.2.5.jre6.jar | 6 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.5 | postgresql-42.2.5.jre7.jar | 7 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.5 | postgresql-42.2.5.jar | 8 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.6 | postgresql-42.2.6.jre6.jar | 6 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.6 | postgresql-42.2.6.jre7.jar | 7 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.6 | postgresql-42.2.6.jar | 8 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.7 | postgresql-42.2.7.jre6.jar | 6 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.7 | postgresql-42.2.7.jre7.jar | 7 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.7 | postgresql-42.2.7.jar | 8 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.8 | postgresql-42.2.8.jar | 8 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
| 42.2.17 | postgresql-42.2.17.jar | 8 | Aurora PostgreSQL (Compatible with PostgreSQL 8.2 or newer) |
| 42.2.18 | postgresql-42.2.18.jar | 8 | Aurora PostgreSQL (Compatible with PostgreSQL 8.2 or newer) |
| 42.7.2 | postgresql-42.7.2.jar | 8 | Aurora PostgreSQL (Compatible with PostgreSQL 9.6.8, 9.6.9, 10.4, 10.5, 10.6) |
JDBC Driver Jars for MySQL
Download Path - https://downloads.mysql.com/archives/c-j/
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 8.0.15 | mysql-connector-java-8.0.15.jar | 8 | MySQL 8.0, 5.7, 5.6, and 5.5 |
| 8.0.16 | mysql-connector-java-8.0.16. jar | 8 | MySQL 8.0, 5.7, 5.6, and 5.5 |
| 8.0.17 | mysql-connector-java-8.0.17.jar | 8 | MySQL 8.0, 5.7, 5.6, and 5.5 |
| 8.0.22 | mysql-connector-java-8.0.22.jar | 8 | MySQL 8.0, 5.7, 5.6 |
| 8.0.23 | mysql-connector-java-8.0.23.jar | 8 | MySQL 8.0, 5.7, 5.6| |
Note: For the MySQL driver, help ensure that you download the Platform Independent variant.
JDBC Driver Jars for MariaDB
Download Path - http://downloads.mariadb.com/Connectors/java/
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 2.3.0 | mariadb-java-client-2.3.0.jar | 8 | MariaDB 10.3.8 |
| 2.4.3 | mariadb-java-client-2.4.3.jar | 8 | MariaDB 10.3.8 |
| 2.5.4 | mariadb-java-client-2.5.4.jar | 8 | All MariaDB versions |
| 2.7.1 | mariadb-java-client-2.7.1.jar | 8 | All MariaDB versions |
| 2.7.2 | mariadb-java-client-2.7.2.jar | 8 | All MariaDB versions |
JDBC Driver Jars for Tibero
Download Path - The driver jar is available in the Tibero 6 installation directory ($TB_HOME/client/lib/jar).
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 6.0 | tibero6-jdbc.jar | Tibero 6 |
JDBC Driver Jars for SAP HANA
Download Path - https://repo1.maven.org/maven2/com/sap/cloud/db/jdbc/ngdbc/
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 2.8.11 | ngdbc-2.8.11.jar | 8 | All SAP HANA versions |
| 2.8.12 | ngdbc-2.8.12.jar | 8 | All SAP HANA versions |
| 2.8.14 | ngdbc-2.8.14.jar | 8 | All SAP HANA versions |
JDBC Driver Jars for Amazon Redshift
Download Path - https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-previous-driver-version-20.html
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 1.2.53 | RedshiftJDBC42-no-awssdk-1.2.53.1080.jar | 8 | All Amazon Redshift versions |
| 1.2.54 | RedshiftJDBC42-no-awssdk-1.2.54.1082.jar | 8 | All Amazon Redshift versions |
| 2.0.0.3 | redshift-jdbc42-2.0.0.3.jar | 8 | All Amazon Redshift versions |
| 2.0.0.4 | redshift-jdbc42-2.0.0.4.jar | 8 | All Amazon Redshift versions |
JDBC Driver Jars for Snowflake
Download Path - https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 3.9.2 | snowflake-jdbc-3.9.2.jar | 8 | All Snowflake versions |
| 3.12.15 | snowflake-jdbc-3.12.15.jar | 8 | All Snowflake versions |
| 3.12.16 | snowflake-jdbc-3.12.16.jar | 8 | All Snowflake versions |
| 3.12.17 | snowflake-jdbc-3.12.17.jar | 8 | All Snowflake versions |
| 3.20.0 | snowflake-jdbc-3.20.0.jar | 8 | Snowflake version 9.5.1 |
JDBC Driver Jars for Vertica
Download Path - https://www.vertica.com/download/vertica/client-drivers/
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 9.3.1 | vertica-jdbc-9.3.1-0.jar | 8 | All Vertica versions |
| 10.0.1 | vertica-jdbc-10.0.1-0.jar | 8 | All Vertica versions |
| 10.1.1 | vertica-jdbc-10.1.1-0.jar | 8 | All Vertica versions |
JDBC Driver Jars for Teradata Vantage
Download Path - https://downloads.teradata.com/download/connectivity/jdbc-driver
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 16.2 | terajdbc4.jar | 8 | All Teradata Vantage versions |
| 17.0 | terajdbc4.jar | 8 | All Teradata Vantage versions |
| 17.1 | terajdbc4.jar | 8 | All Teradata Vantage versions |
JDBC Driver Jars for IBM Db2
Download Path - https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads-db2-zos
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 4.26.14 | db2jcc4.jar | 8, 9, 11 | 11.5.9.0 |
JDBC Driver Jars for Databricks
Download Path - All JDBC Driver Versions
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 2.6.40 | DatabricksJDBC42-2.6.40.jar | 8 | 15.4 |
Note:
On the Configure Connection Type form, set the following values in
the Connection Properties section.
- Set Other Properties as
String url = "jdbc:databricks://<your-databricks-host>:443;transportMode=http;ssl=1;httpPath=<http-path>;AuthMech=3;UID=token; - Set the User as
token.
JDBC Driver Jars for Synapse
Download Path - https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16
| Driver Version | Driver Jar Name | Java Version | Supported DB Versions |
|---|---|---|---|
| 12.10.0 | Microsoft JDBC Driver for SQL Server: mssql-jdbc-12.10.0.jre11.jar | 11 | Azure Synapse Analytics (Dedicated SQL Pool) |
Note:
- Transaction Type. Azure Synapse SQL does not support XA transactions. These transactions rely on a two-phase commit protocol for distributed transaction management, which requires full support from both the database and JDBC driver.
- Azure Synapse lacks support for XA-compliant distributed transactions and full two-phase commit protocols.
- Database Name is required, but if it is not provided, the connection defaults to the master database. However, SQL queries cannot be executed in the master database.
- Other properties are optional.