Use embedded Structured Query Language in Java (SQLJ) support
You can use Structured Query Language in Java (SQLJ) to develop data access applications that connect to DB2 databases.
Overview
WAS Vsupports 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 WAS.
Procedure
- 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.
- WAS driver
- 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
Use Structured Query Language in Java (SQLJ) for Enterprise Java Bean (EJB) container-managed persistence (CMP) beans
Use Structured Query Language in Java for bean-managed persistence entity beans, session beans, and servlets
Related concepts
Embedded Structured Query language in Java (SQLJ) support