WebSphere Application Server Version supports Structured Query Language in Java (SQLJ ) with the DB2 universal JDBC driver and the DB2 Legacy CLI-based Type 2 JDBC driver. Perform the following steps to convert existing JDBC applications to SQLJ in WebSphere Application Server:

1. Acquire the required drivers to run SQLJ.

   • DB2 Legacy CLI-based JDBC driver

     You must have the db2java.zip and db2jcc.jar files in your class path. Define these files in the class path of the WebSphere Application Server DB2 Legacy CLI-based JDBC Driver Provider.

   • DB2 Universal JDBC driver

     You only need the db2jcc.jar file.

   • WebSphere Application Server driver

2. Review the appropriate task file for instructions on using SQLJ.

   • Enterprise Java Bean (EJB) Container Managed Persistence (CMP) beans, or with

   • EJB Bean Managed Persistence (BMP) entity beans, session beans, and servlets

Related concepts
Embedded Structured Query language