Question & Answer
Question
What JDBC drivers does IBM provide for DB2 on IBM i?
Answer
IBM provides two different JDBC drivers for the IBM i database:
- The "Native" JDBC driver. This is shipped as part of the IBM Developer Kit for Java (57xxJV1). It is implemented by making native method calls to the SQL CLI (Call Level Interface). Consequently, it only runs on the IBM i JVM. The class name to register is com.ibm.db2.jdbc.app.DB2Driver. The URL subprotocol is db2.
- The "Toolbox" JDBC driver. This is shipped as part of the IBM Toolbox for Java (57xxJC1). It is implemented by making direct socket connections to the database host server. This happens to be the same route that the IBM System i™ Access for Windows ODBC driver takes. However, IBM System i™ Access for Windows is NOT required. The Toolbox runs on any JVM. The class name to register is com.ibm.as400.access.AS400JDBCDriver. The URL subprotocol is as400
In general, we strive to make both JDBC drivers behave the same. There are slight differences which are documented.
[{"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;AS400
Was this topic helpful?
Document Information
Modified date:
17 March 2020
UID
ibm11117935