WebSphere Application Server Network Deployment, Version 6.0.x   Operating Systems: AIX, HP-UX, Linux, Solaris, Windows
             [TIP: Focusing the table of contents and search results]

Using 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.

About this task

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 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.



Sub-topics
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
Related concepts
Embedded Structured Query language in Java (SQLJ) support
Task topic    

Terms of Use | Feedback

Last updated: Mar 8, 2007 8:14:28 PM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/tdat_sqljep.html

© Copyright IBM Corporation 2003, 2006. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)