JDBC driver requirements (all databases)
For all databases supported by Sterling B2B Integrator, use the JDBC driver that is recommended by the database vendor for your database and version.
- For Oracle:
- (Version 11g) See http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html for information.
- (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.
- For Microsoft SQL Server:
- Microsoft SQL Server 2016 - Use mssql-jdbc-6.4.0.jre7.jar
- Microsoft SQL Server 2014 - Use mssql-jdbc-6.4.0.jre7.jar
- Microsoft SQL Server 2012 - Use SQL Server JDBC Driver 6.4.0.jre7
- Microsoft SQL Server 2005 or 2008 - Use SQL Server JDBC Driver 6.4.0.jre7
- Regardless of Microsoft SQL Server version, if you are using the Lightweight JDBC Adapter, use SQL Server JDBC Driver 6.4.0.jre7.
- For DB2®, see http://www.ibm.com/support/docview.wss?uid=swg21363866 for information.
- For MySQL, see http://dev.mysql.com/downloads/connector/j/ for information.