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 |
|
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 |
|
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 |
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
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:
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
Does anyone know where to get ifxjdbc.jar - support had installed but I can not find anywhere.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
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
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
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?
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
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
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
Hi and for postgresql is it https://jdbc.postgresql.org/
postgresql-42.7.1.jar
class org.postgresql.Driver ??
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Content to Moderator
1. Download the latest JAR file from postgres. I used `42.7.2` which was Java 8.