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.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

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

This feature requires Internet access.

Task topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 7:21:45 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=vela&product=was-nd-dist&topic=sqljep
File name: tdat_sqljep.html