Required JDBC Driver JAR Files

[#1]

The following table contains required information about the supported driver JAR files for the related databases:

NOTE: This list is not comprehensive. If you use a database that is not listed, contact SailPoint support for assistance.

• Oracle
• Oracle 11g
• Oracle 12c
• SQL Server
• Microsoft
• jTDS Project
• Sybase
• AS400/DB2
• MySQL
• Teradata

NOTE: Any .jar file uploaded for the JDBC Source must be compatible with JDK8.

Oracle

Oracle 11g

The Oracle 11g is not applicable because it in end-of-life as declared here https://support.oracle.com/knowledge/Oracle%20Cloud/2068368_1.html  

Oracle 12c

Requirements	Details
Download	Oracle Database 12c Release 1 JDBC Driver Downloads
Class Name	oracle.jdbc.driver.OracleDriver
Driver File Name	Choose the needed version of the ojdbc.jar per your Oracle environment.
Database URL Format	jdbc:oracle:thin:@<hostname>:<port>:<SID> If this is a OID (Oracle Internet Directory) instance  use this string instead jdbc:oracle:thin:@ldap://<host>:<port>/<SID>,cn=xyz,dc=abc,dc=com. Standard port for a regular Oracle instance is 1521, for OID it is generally 389.
Test Query	select 1 from dual

SQL Server

Microsoft

Requirements	Details
Download	https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?vie...
Class Name	com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver File Name	Microsoft SQL Server jar file
Database URL Format	jdbc:sqlserver://<hostname>:<port>;DatabaseName=<dbname>
Test Query	select 1

jTDS Project

Requirements	Details
Download	http://jtds.sourceforge.net/
Class Name	net.sourceforge.jtds.jdbc.Driver
Driver File Name	jtds-1.3.1.jar
Database URL Format	jdbc:jtds:sqlserver://<hostname>:<port>;databaseName=<dbname>;useNTLMv2=true;domain=<domainname>;
Test Query	select 1

Sybase

Requirements	Details
Download	https://help.sap.com/docs/SAP_SQL_Anywhere/98ad9ec940e2465695685d98e308dff5/3bd588c76c5f10149824867a...
Class Name	com.sybase.jdbc4.jdbc.SybDataSource
Driver File Name	jconn4.jar
Database URL Format	jdbc:sybase:Tds:<hostname>:<port>
Test Query	select getdate()

AS400/DB2

Requirements	Details
Download	http://jt400.sourceforge.net/
Class Name	com.ibm.as400.access.AS400JDBCDriver
Driver File Name	jt400.jar
Database URL Format	jdbc:as400://<hostname>/
Test Query	SELECT 1 FROM  SYSIBM.SYSDUMMY1

MySQL

Requirements	Details
Download	https://dev.mysql.com/downloads/connector/j/
Class Name	com.mysql.cj.jdbc.Driver
Driver File Name	mysql-connector-java-5.1.39-bin.jar
Database URL Format	jdbc:mysql://<hostname>/<dbname>
Test Query	select count(*);

Teradata

Requirements	Details
Download	Teradata JDBC Driver | Teradata Downloads
Class Name	com.teradata.jdbc.TeraDriver
Driver File Name	terajdbc4.jar
Database URL Format	JDBC Type 3:   jdbc:teradata://gwhost:port/DatabaseServerName JDBC Type 4:   jdbc:teradata://DatabaseServerName
Test Query	SELECT CURRENT_DATE

[chrisp]

Is anyone using the jTDS driver with a SQL Server 2016 database?

This article(open the last section about 'Why Change drivers') raises some concerns with Hibernate and jTDS with BitBucket Server:

  https://confluence.atlassian.com/bitbucketserver/transitioning-from-jtds-to-microsoft-s-jdbc-driver-...

[miscerridiacono]

Does anyone know where to get ifxjdbc.jar - support had installed but I can not find anywhere.

[Rameez_Shaikh]

I think it should be a part of IBM's Informix installation.

Please check https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_013.htm

[aparker81]

After the JDBC driver for MS SQL has been replaced and updated for IIQ 8.1, how may I verify through the IdentityIQ application it is using the updated JDBC driver?  This information is not listed on the debug/about.jsf page.  Is there a simple rule that can be created to output the driver version or other method to use for confirming successful updating?

[haluchi]

Hi all, does anyone know what might be the issue for the below error?

[ ConnectorException ] [ Error details ] The server encountered an unexpected error while contacting target system. Please check the logs. Failure trying to get a pooled connection to [jdbc:mysql://xxxx:xxxx] com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Currently we are trying to connect to a mysql database on AWS RDS. we are using the default JDBC driver com.mysql.cj.jdbc.Driver.

Please let me know if anyone is aware about this.

Thanks

[JaimeIvanHuertaMontes]

Hi and for postgresql is it https://jdbc.postgresql.org/  

postgresql-42.7.1.jar

class org.postgresql.Driver  ?? 

[edmarks]

Does anyone know where to find these files in the cloud tenant and/or on the VA's related to IDN?  Use case is ensuring the exact same file is copied/deployed from SBX to PRD.

[mdewallnc]

For postgres I had success in March 2024 with the following:

1. Download the latest JAR file from postgres.  I used `42.7.2` which was Java 8.

   * https://jdbc.postgresql.org/download/postgresql-42.7.2.jar

2. Urls for the db are the in the following format: `jdbc:postgresql://{hostname}/{database}

   * ex: mydbcluster.us-west-2.rds.amazonaws.com/mydb

3. The postgres driver should be called out as 'org.postgresql.Driver' without quotes.