[Version 5.0.1 and later]Using embedded Structured Query Language in Java (SQLJ) support

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

  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 classpath. Define these files in the classpath of the Websphere Application Server Version 5.0.1 DB2 Legacy CLI-based JDBC Driver Provider.

    • DB2 Universal JDBC driver

      You only need the db2jcc.jar file.

    • WebSphere Application Server driver

      WebSphere Application Server must be at the Version 5.0.1 level.

  2. Review the task file for instructions on using SQLJ with EJB Bean Managed Persistence (BMP) entity beans, session beans, and servlets

Related concepts
Embedded Structured Query language in Java (SQLJ) support



Searchable topic ID:   sqljep
Last updated: Jun 21, 2007 4:12:58 PM CDT    WebSphere Application Server Express, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.websphere.exp.doc/info/exp/ae/tdat_sqljep.html

Library | Support | Terms of Use | Feedback