JDBC driver requirements (all databases)
For all databases supported by Sterling B2B Integrator, use the JDBC driver recommended by the database vendor for your database and 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 (v5.2.6.3 or prior versions):
- Microsoft SQL Server 2014 - Use SQL Server JDBC Driver 6.4.0.jre7
- Microsoft SQL Server 2012 - Use SQL Server JDBC Driver 6.4.0.jre7
- Microsoft SQL Server 2008 - Use SQL Server JDBC Driver 6.4.0.jre7
- Regardless of the Microsoft SQL Server version, if you are using the Lightweight JDBC Adapter, use SQL Server JDBC Driver 6.4.0.jre7.
- For Microsoft SQL Server (v5.2.6.4 or later versions):
- 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
- Microsoft SQL Server 2008 - Use SQL Server JDBC Driver 6.4.0.jre8
- Regardless of the Microsoft SQL Server version, 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®, see http://www.ibm.com/support/docview.wss?uid=swg21363866 for information.