EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #333 background imageLoading...
Page #333 background image
javax.sql.DataSource ds =
new com.ibm.db2.jcc.DB2SimpleDataSource();
((com.ibm.db2.jcc.DB2BaseDataSource) ds).setServerName("sysmvs1.stl.ibm.com");
Table 83 summarizes the IBM Data Server Driver for JDBC and SQLJ-only
interfaces.
Table 83. Summary of IBM Data Server Driver for JDBC and SQLJ-only interfaces provided by the IBM Data Server
Driver for JDBC and SQLJ
Interface name Applicable data sources Purpose
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.
DB2PreparedStatement 1, 2, 3 Extends the com.ibm.db2.jcc.DB2Statement and
java.sql.PreparedStatement interfaces.
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.
DB2TraceManagerMXBean 1, 2, 3 Provides the MBean interface for the remote trace
controller.
DB2SystemMonitor 1, 2, 3 Used for collecting system monitoring data for a
connection.
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:
1. DB2 for z/OS
2. DB2 Database for Linux, UNIX, and Windows
3. IBM Informix Dynamic Server
Table 84 summarizes the IBM Data Server Driver for JDBC and SQLJ-only classes.
Table 84. Summary of IBM Data Server Driver for JDBC and SQLJ-only classes provided by the IBM Data Server
Driver for JDBC and SQLJ
Class name Applicable data sources Purpose
DB2Administrator ( DB2 Database
for Linux, UNIX, and Windows
only)
2 on page 318 Instances of the DB2Administrator class are used
to retrieve DB2CataloguedDatabase objects.
DB2BaseDataSource 1 on page 318, 2 on page 318,
3 on page 318
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.
DB2CataloguedDatabase 2 on page 318 Contains methods that retrieve information about
a local DB2 Database for Linux, UNIX, and
Windows database.
DB2ClientRerouteServerList 1 on page 318, 2 on page 318 Implements the java.io.Serializable and
javax.naming.Referenceable interfaces.
Chapter 7. JDBC and SQLJ reference information 317
|||
|
|

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability