WebSphere Application Server Network Deployment, Version 6.1
             Operating Systems: AIX, HP-UX, Linux, Solaris, Windows, z/OS

             Personalize 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

[AIX HP-UX Linux Solaris Windows] 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.

[z/OS] WebSphere Application Server for z/OS provides support for applications that use Structured Query Language in Java (SQLJ ) to connect to a DB2 for z/OS backend database.

Procedure

  1. Acquire the required drivers to run SQLJ.
    [AIX HP-UX Linux Solaris Windows] [i5/OS]
    • 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
    [z/OS] The level of support provided depends on the driver that is used to connect to DB2 for z/OS, such as:
    • The DB2 for z/OS Legacy Driver in conjunction with the DB2 for z/OS Local JDBC Provider (RRS), which supports the use of SQLJ-backed servlets, session beans, and entity beans using bean-managed persistence
    • The DB2 Universal JDBC Driver in conjunction with the DB2 Universal JDBC Driver Provider, which supports the use of SQLJ-backed servlets, session beans, and entity beans using bean managed persistence or container managed persistence
  2. Review the appropriate task file for instructions on using SQLJ.



In this information ...


IBM Redbooks, demos, education, and more


Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

IBM Suggests
Task topic    

Terms of Use | Feedback

Last updated: Feb 25, 2009 9:32:38 AM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.nd.multiplatform.doc/info/ae/ae/tdat_sqljep.html