"How To" Guides for IBM DB2 UDB Databases

Using JDBC to access DB2 UDB from Java

Types of JDBC drivers

When using a JDBC driver to access a database from Java, the JDBC protocols must be converted to the native database protocols on either the client or the server. A Type 2 JDBC driver uses the native database software installed on the client system. A Type 4 driver can be implemented in pure Java on the client, but may require some routines (stored procedures, for example) to be installed on the server side.

The Type 4 JDBC driver uses a number of stored procedures that in the SYSIBM schema. These routines are provided with DB2 and require DbVisualizer call these stored procedures over an RRSAF connection and therefore require Workload Manager and RSS.

Next: Binder 

Home > Computers > Databases > IBM DB2 > JDBC > JDBC

Viewing mobile website page. Switch to WML or Full HTML