This section details the java versions and jdbc drivers needed during install.
-
You must obtain your own Java JDK/SDK software for Unix and Linux operating systems.
- Connect CDC does not support the Listener running on Windows 7, 8, 8.1 or 10.These versions of Windows only support running the Connect CDC clients; Director, MonCon, Console and Jetty Web Server.
- For Windows, the Windows Installation wizard installs the current versions of Java and the current JDBC drivers for the supported databases that are selected and configures JDBC and listener settings.
- For DB2 on z/OS, follow the install instruction in the Connect ETL "Change Data Capture on z/OS Installation Guide".
Java versions
- AIX JDK/SDK:
- HPUX JDK/SDK:
https://h20392.www2.hpe.com/portal/swdepot/displayProductInfo.do?productNumber=HPUXJAVAHOME
- Linux
- OpenJDK 8:
- Oracle Java SE Development Kit 8:
http://www.oracle.com/technetwork/java/javase/downloads/index.html
- Oracle Sparc
- Oracle Java SE Development Kit 8:
http://www.oracle.com/technetwork/java/javase/downloads/index.html
- Oracle Java SE Development Kit 8:
- Windows
Windows Installation wizard installs the current Java version that is used with Connect CDC Director.
JDBC Drivers
For IBM i, the JDBC driver is provided during installation. For Windows, the Windows Installation wizard installs the current JDBC drivers for the supported databases that are selected and configures JDBC and listener settings. For all other platforms, the user must obtain a JDBC driver since drivers are usually supplied with the databases.
DBMS Platform | JDBC Driver |
---|---|
DB2 LUW | db2jcc.jar db2jcc_license_cu.jar |
DB2 z |
db2jcc.jar db2jcc4.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar |
Informix DS 11.x, 12.1 |
ifxjdbc.jar |
MS SQL Server | mssql-jdbc-10.2.1.jre8.jar |
MySQL | MySQL java connector (Connector/J)
|
Oracle 11g | ojdbc6.jar |
Oracle 12c, 18c, and 19c | ojdbc8.jar |
PostgreSQL 9, 10, 11, 12, and 13 | postgresql-42.2.26.jar |
Sybase 15.7 Sybase 16.0 |
jconn4.jar |
Teradata | Teradata validates against the following files:
|
- DB2 LUW:
$DB2_HOME/sqllib/java
- IBM i: JDBC driver is provided during installation.
- Informix:
$INFORMIXDIR/jdbc/lib
- Oracle:
$ORACLE_HOME\jdbc\lib
Note: The Oracle driver version cannot be verified during installation because the Oracle driver class claims all drivers are version 1.0. Make sure that the correct driver version is provided during Connect CDC Installation. The Oracle12c driver requires the minimum JDBC driver version 12.0. - Sybase 15 is in:
$SYBASE/jConnect-7_0/classes
- Sybase 16 is in:
$SYBASE/jConnect-16_0/classes
- Teradata JDBC driver
http://downloads.teradata.com/download/connectivity/jdbc-driver