Summary
DB2 provides drivers for JDBC and SQLj. DB2 JDBC drivers come in two flavors: the app driver (Type II) and the net driver (Type III). The former uses JNI to invoke DB2 CLI libraries, and the latter uses a TCP/IP connection to communicate with a DB2 JDBC server. DB2 JDBC drivers support the JDBC 2.1 core functionality and some standard extensions functionality.
JDBC includes Connection objects for managing connections, Statement objects for executing SQL queries, and ResultSet objects for manipulating a cursor. In addition, DB2 JDBC 2.1 drivers provide additional support for LOBs, batch updates, scrollable cursors, JTA, and JNDI.
SQLj provides a static SQL alternative to JDBC's dynamic SQL interface. SQLj source files are translated into ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
