Use embedded Structured Query Language in Java (SQLJ) support

 

Overview

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:

 

Procedure

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 WAS 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, with either

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

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

 

See also

Using Structured Query Language in Java (SQLJ) for Enterprise Java Bean (EJB) Container Managed Persistence (CMP) beans
Using Structured Query Language in Java for bean-managed persistence entity beans, session beans, and servlets

 

See Also

Embedded Structured Query language in Java (SQLJ) support

 

---