IBM Support

What type of JDBC driver does the Toolbox have?

Question & Answer


Question

What type of JDBC driver does the Toolbox have?

Answer

 Java categorizes JDBC drivers into four types. The Toolbox driver is a Type 4 driver. This means (in Sun's words) that it "converts JDBC calls directly into the network protocol used by the DBMS. This allows a direct call from the client machine to the DBMS server and is an excellent solution for intranet access."
More specifically, the Toolbox driver communicates directly with the IBM i database Host Server. This is the same path that the IBM i Access for Windows ODBC driver uses to access the database. Note: IBM i Access for Windows is NOT required in order for you to use the IBM Toolbox for Java.
  • Does the Toolbox JDBC driver support JDBC 2.0?
    Yes, as of Modification 2 of the Toolbox. Existing programs will certainly not need to change. However, in order to take advantage of the new JDBC 2.0 features, your program must be compiled and run using JDK 1.2 (Java 2). You can still use the Toolbox JDBC driver with JDK 1.1.x, but in that case your program will only be able to use the JDBC 1.x functionality.
  • Does the Toolbox JDBC driver support JDBC 3.0?
    Yes, as of Modification 5 of the Toolbox (Version 5 Release 2 or JTOpen version 3.x). Existing programs will not need to change. However, in order to take advantage of the new JDBC 3.0 features, your program must be compiled and run using JDK 1.4 (Java 2). You can still use the Toolbox JDBC driver with JDK 1.2.x, but in that case your program will only be able to use the JDBC 1.1.x and 1.2.x functionality. In addition, some parts of the Toolbox JDBC support require functionality from a system running OS/400 Version 5 Release 2 or later. Check the Toolbox javadoc to see which JDBC 3.0 methods require IBM i support.
  • Does the Toolbox JDBC driver support JDBC 4.0?
    Yes, as of JTOpen 6.1. Existing programs will not need to change. However, in order to take advantage of the new JDBC 4.0 features, your program must be compiled and run using JDK 1.6 (Java 6) or higher, and you must use the JDBC 4.0 version of the Toolbox jar file. To obtain the JDBC 4.0 version of the Toolbox, go to the JTOpen download site and download the file named "jtopen_x_x_jdbc40_jdk6.zip" (where "x_x" specifies the JTOpen release, for example "7_1" for JTOpen 7.1).

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Product Synonym

IBM i

Document Information

Modified date:
17 March 2020

UID

ibm11117953

Page Feedback