Required JDBC Driver JAR Files

Required JDBC Driver JAR Files

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.

 

 

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

ojdbc7.jar
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://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?redirectedfro... 
Class Name com.microsoft.sqlserver.jdbc.SQLServerDriver

Driver File Name

sqljdbc4.jar
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

http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect

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

 

 

 

Comments

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-...

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

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

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?

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

Version history
Revision #:
5 of 5
Last update:
‎May 05, 2021 03:24 AM
Updated by:
 
Contributors