JDBC driver requirements (all databases)
For all databases that are supported by Sterling B2B Integrator, use the JDBC driver recommended by the database vendor for your database version.
For Oracle
- (Version 12c) Oracle 12.1.0.2.0 JDBC 4.1 or higher within 12.x.x.x.x. See http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html for information.
- (Version 11g) See http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html for information.
- Sterling B2B Integrator supports JDBC Type-4 drivers on a single node of a database except with Oracle Real Application Clusters (RAC). You can use the JDBC Type-4 drivers to connect with multiple nodes of an Oracle RAC.
For Microsoft SQL Server
- Microsoft SQL Server 2016 - Use SQL Server JDBC Driver 6.4.0.jre8
- Microsoft SQL Server 2014 - Use SQL Server JDBC Driver 6.4.0.jre8
- Microsoft SQL Server 2012 - Use SQL Server JDBC Driver 6.4.0.jre8
- Regardless of the Microsoft SQL Server version except Microsoft SQL Server 2019, if you are using the Lightweight JDBC Adapter, use SQL Server JDBC Driver 6.4.0.jre8.
To obtain the driver, go to the Microsoft Download Center at http://www.microsoft.com/en-us/download/default.aspx and search for the required SQL Server JDBC driver version.
For DB2
For DB2, see http://www.ibm.com/support/docview.wss?uid=swg21363866 for information.
Note: If you are using the Lightweight JDBC Adapter with the DB2® database, you must use the 4.0 version of the JDBC driver.