JDBC driver requirements in EGL

The JDBC driver requirements vary by database management system, whether for EGL debug time or run time. The following rules apply to any JDBC driver used with EGL:
Following are requirements for JDBC drivers used with specific databases:
DB2® UDB

The DB2 Universal driver is compatible with EGL, but the related App driver is not compatible; specifically, the App driver cannot process an EGL open or get statement that includes the option forUpdate.

IBM® recommends that you not use the Net driver at all.

If you are running J2EE applications in WebSphere® Application Server v6.x, you need DB2 version 8.1.6 or higher. If you are running those applications inWebSphere Application Server v5.x Test Environment, you need DB2 version 8.1.3 or higher.

Informix®
The minimum acceptable Informix JDBC driver is 2.21.JC6. This driver level does not comply with JDBC 3.0 and therefore does not support the hold option in the EGL open statement.
Oracle
The JDBC driver that is packaged with Oracle 10i is acceptable.
Microsoft® SQL Server
EGL supports the JDBC drivers from WebSphere, Microsoft, and DataDirect for use with Microsoft SQL Server.

For any database management system, JDBC drivers from third- or fourth-party vendors are acceptable.


Feedback