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 19c and Version 21c) Oracle JDBC 4.2 or higher. 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 2022 - Use SQL Server JDBC Driver 12.4.0.jre8.jar
  • Microsoft SQL Server 2019 - Use SQL Server JDBC Driver 12.2.0.jre8.jar
  • Microsoft SQL Server 2019 - Use SQL Server JDBC Driver 8.4.1.jre8
  • Microsoft SQL Server 2016 - 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.