Supported databases

The Java Gateway for JDBC 2 is supported for use with the databases listed here.

The gateway is supported for use with the databases and JDBC drivers listed in the following table.

Note: The Java Gateway for JDBC 2 will support a database once the vendor supplies a suitable JDBC driver that works with the gateway. Drivers not listed in this table are not supported by IBM Software Support, but if a third party JDBC driver does not function correctly due to a fault with the Java Gateway for JDBC 2, then IBM Software Support will provide support.

Table 1. Supported databases and JDBC drivers
Database	JDBC Driver
DB2® LUW	DB2 Type 4 Universal Driver (`com.ibm.db2.jcc.DB2Driver`)
DB2 z/OS®	DB2 Type 4 Universal Driver (`com.ibm.db2.jcc.DB2Driver`)
Microsoft SQL Server	Microsoft JDBC Driver for SQL Server (`com.microsoft.sqlserver.jdbc.SQLServerDriver`) Note: On OMNIbus installations which are JRE 1.7 based the Microsoft JDBC Driver 4.2 up till 6.4 can be used.. For OMNIbus installations using JRE 1.8, Microsoft JDBC Driver 7.0 and above may be used providing that the driver used is the JRE 1.8 version. For more details on the Microsoft JDBC Driver, please refer to the Microsoft JDBC Driver for SQL Server website. Ensure that multiple versions of the .jar files are not installed in the $CLASSPATH or in the $OMNIHOME/gates/java location simultaneously.
MySQL	MySQL Connector/J (`com.mysql.jdbc.Driver`)
Oracle	Oracle JDBC Thin Driver (`oracle.jdbc.driver.OracleDriver`) Note: When the database connection is enabled with Kerberos authentication, the gateway must be run using Oracle Java. See: Deploying the gateway with non-IBM Java.