Why and when to perform this task
WebSphere Application Server Version 5.0.1 introduces support for Structured Query Language in Java (SQLJ ) with the DB2 universal Java Database Connectivity (JDBC) driver provider and the DB2 Legacy CLI-based Type 2 JDBC driver for DB2 Version 8 FixPak1 (FP1).
Only the WebSphere Application Server Version 5.0.1 data source supports the DB2 universal JDBC driver provider. The WebSphere Application Server Version 4.0.x data source does not support this driver provider. In addition, the universal JDBC driver currently only supports a single phase data source.
Perform the following steps to convert existing JDBC applications to SQLJ in WebSphere Application Server:
Steps for this task
You must have the db2java.zip and db2jcc.jar files in your classpath. Define these files in the classpath of the Websphere Application Server Version 5.0.1 DB2 Legacy CLI-based JDBC Driver Provider.
You only need the db2jcc.jar file.
WebSphere Application Server must be at the Version 5.0.1 level.