DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
The IBM® Data Server Driver for JDBC and SQLJ provides a set of extensions to the support that is provided by the JDBC specification.
javax.sql.DataSource ds =
new com.ibm.db2.jcc.DB2SimpleDataSource();
((com.ibm.db2.jcc.DB2BaseDataSource) ds).setServerName("sysmvs1.stl.ibm.com");| Interface name | Applicable data sources | Purpose |
|---|---|---|
| DB2CallableStatement | 1, 2 | Extends the java.sql.CallableStatement and the com.ibm.db2.jcc.DB2PreparedStatement interfaces. |
| DB2Connection | 1, 2, 3 | Extends the java.sql.Connection interface. |
| DB2DatabaseMetaData | 1, 2, 3 | Extends the java.sql.DatabaseMetaData interface. |
| DB2Diagnosable | 1, 2, 3 | Provides a mechanism for getting DB2® diagnostics from a DB2 SQLException. |
| DB2ParameterMetaData | 2 | Extends the java.sql.ParameterMetaData interface. |
| DB2PreparedStatement | 1, 2, 3 | Extends the com.ibm.db2.jcc.DB2Statement and java.sql.PreparedStatement interfaces. |
| DB2ResultSet | 1, 2, 3 | Extends the java.sql.ResultSet interface. |
| DB2RowID | 1, 2 | Used for declaring Java™ objects for use with the ROWID data type. |
| DB2Statement | 1, 2, 3 | Extends the java.sql.Statement interface. |
| DB2Struct | 2 | Provides methods for working with java.sql.Struct objects. |
| DB2SystemMonitor | 1, 2, 3 | Used for collecting system monitoring data for a connection. |
| DB2TraceManagerMXBean | 1, 2, 3 | Provides the MBean interface for the remote trace controller. |
| DB2Xml | 1, 2 | Used for updating data in XML columns and retrieving data from XML columns. |
| DBBatchUpdateException | 1, 2, 3 | Used for retrieving error information about batch execution of statements that return automatically generated keys. |
Note: The interface applies to
connections to the following data sources:
|
||
| Class name | Applicable data sources | Purpose |
|---|---|---|
| DB2Administrator | 2 | Instances of the DB2Administrator class are used to retrieve DB2CataloguedDatabase objects. |
| DB2BaseDataSource | 1, 2, 3 | The abstract data source parent class for all IBM Data Server Driver for JDBC and SQLJ-specific implementations of javax.sql.DataSource, javax.sql.ConnectionPoolDataSource, and javax.sql.XADataSource. |
| DB2Binder | 1, 2 | Provides the runJDBCBinder method as an alternative to the DB2Binder utility for binding IBM Data Server Driver for JDBC and SQLJ packages. |
| DB2CataloguedDatabase | 2 | Contains methods that retrieve information about a local DB2 for Linux, UNIX, and Windows database. |
| DB2ClientRerouteServerList | 1, 2 | Implements the java.io.Serializable and javax.naming.Referenceable interfaces. |
| DB2ConnectionPoolDataSource | 1, 2, 3 | A factory for PooledConnection objects. |
| DB2DataSource | 1, 2, 3 | Extends the extends DB2BaseDataSource class, and implements the javax.sql.DataSource, java.io.Serializable, and javax.naming.Referenceable interfaces. |
| DB2ExceptionFormatter | 1, 2, 3 | Contains methods for printing diagnostic information to a stream. |
| DB2JCCPlugin | 2 | The abstract class for implementation of JDBC security plug-ins. |
| DB2PooledConnection | 1, 2, 3 | Provides methods that an application server can use to switch users on a preexisting trusted connection. |
| DB2PoolMonitor | 1, 2 | Provides methods for monitoring the global transport objects pool for the connection concentrator and Sysplex workload balancing. |
| DB2SimpleDataSource | 1, 2, 3 | Extends the DataBaseDataSource class. Does not support connection pooling or distributed transactions. |
| DB2Sqlca | 1, 2, 3 | An encapsulation of the DB2 SQLCA. |
| DB2TraceManager | 1, 2, 3 | Controls the global log writer. |
| DB2Types | 1 | Defines data type constants. |
| DB2XADataSource | 1, 2, 3 | A factory for XADataSource objects. An object that implements this interface is registered with a naming service that is based on the Java Naming and Directory Interface (JNDI). |
| DBTimestamp | 1, 2, 3 | A subclass of Timestamp that handles timestamp values with extra precision or time zone information. |
Note: The class applies to connections
to the following data sources:
|
||