The IBM Toolbox for Java JDBC driver

 

WAS supports the IBM Toolbox for Java JDBC driver, which is part of a library of Java classes optimized for accessing iSeries and AS/400 data and resources.

IBM Toolbox for Java is available in these versions:

• IBM Toolbox for Java licensed program

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

• JTOpen

  Open source version of IBM Toolbox for Java, and is more frequently updated than the licensed program version.

The JDBC driver for both versions supports JDBC 2.0.

If you are running WAS, 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