The IBM Toolbox for Java JDBC driver

WebSphere Application Server - Express supports the IBM Toolbox for Java JDBC driver. This JDBC driver is included with the IBM Toolbox for Java product.

IBM Toolbox for Java is a library of Java classes that are optimized for accessing iSeries and AS/400 data and resources. You can use the IBM Toolbox for Java JDBC driver to access local or remote DB2 UDB for iSeries 400 databases from server-side and client-side Java applications that run on any platform that supports Java.

IBM Toolbox for Java is available in these versions:

IBM Toolbox for Java licensed program
The licensed program is available with every i5/OS release, Version 4 Release 2 (V4R2) or later. You can install the licensed program on your iSeries system, and then either copy the IBM Toolbox for Java JAR file (jt400.jar) to your system or update your system classpath to locate the server installation. For product documentation for IBM Toolbox for Java, see IBM Toolbox for Java.

JTOpen
JTOpen is the open source version of IBM Toolbox for Java, and is more frequently updated than the licensed program version. You can download JTOpen from the IBM Toolbox for Java: Downloads page.

You can also download the JTOpen Programming Guide. The guide includes instructions for installing JTOpen, as well as information about the JDBC driver.

The JDBC driver for both versions supports JDBC 2.0. For more information about IBM Toolbox for Java and JTOpen, see the product Web site at http://www-1.ibm.com/servers/eserver/iseries/toolbox/index.html.

If you are running WebSphere Application Server - Express, Version 5, on a non-iSeries platform, download the JTOpen version of IBM Toolbox for Java.

To configure the jt400.jar file, do the following:

1. Download the jt400.jar file. Save the JAR file to a directory, such as /JDBCDrivers/Toolbox.

2. Start the administrative console.

3. In the administrative console topology tree, expand Environment and click Manage WebSphere Variables.

4. Verify that the scope is set to Node.

5. Click OS400_TOOLBOX_JDBC_DRIVER_PATH.

6. In the Value field, specify the fully qualified path of the directory that contains the jt400.jar file. Do not include the jt400.jar file in this value. For example, if the file is saved in /JDBCDrivers/Toolbox, the value of the variable is /JDBCDrivers/Toolbox. This path is referenced in the jdbc-resource-provider-templates.xml file, which is used to configure JDBC resource providers.

7. Save the configuration.

To use a Toolbox JDBC driver, select UDB DB2 for iSeries (Toolbox) or UDB DB2 for iSeries (Toolbox XA) when you create a new JDBC provider. When the provider is created, the classpath field contains this value: ${OS400_TOOLBOX_JDBC_DRIVER_PATH}/jt400.jar.