|
JDBC for CDC/FP Optional Package | ||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |
See:
Description
Interface Summary | |
Blob | The representation (mapping) in
the JavaTM programming
language of an SQL
BLOB value. |
CallableStatement | The interface used to execute SQL stored procedures. |
Clob | The mapping in the JavaTM programming language
for the SQL CLOB type. |
Connection | A connection (session) with a specific database. |
DatabaseMetaData | Comprehensive information about the database as a whole. |
PreparedStatement | An object that represents a precompiled SQL statement. |
ResultSet | A table of data representing a database result set, which is usually generated by executing a statement that queries the database. |
ResultSetMetaData | An object that can be used to get information about the types
and properties of the columns in a ResultSet object. |
Savepoint | The representation of a savepoint, which is a point within
the current transaction that can be referenced from the
Connection.rollback method. |
Statement | The object used for executing a static SQL statement and returning the results it produces. |
Class Summary | |
Date | A thin wrapper around a millisecond value that allows
JDBC to identify this as an SQL DATE value. |
Time | A thin wrapper around the java.util.Date class that allows the JDBC
API to identify this as an SQL TIME value. |
Timestamp | A thin wrapper around java.util.Date that allows
the JDBC API to identify this as an SQL TIMESTAMP value. |
Types | The class that defines the constants that are used to identify generic SQL types, called JDBC types. |
Exception Summary | |
BatchUpdateException | An exception thrown when an error occurs during a batch update operation. |
DataTruncation | An exception that reports a DataTruncation warning (on reads) or throws a DataTruncation exception (on writes) when JDBC unexpectedly truncates a data value. |
SQLException | An exception that provides information on a database access error or other errors. |
SQLWarning | An exception that provides information on database access warnings. |
Provides the API for accessing and processing data stored in a data source
(usually a relational database) using the JavaTM
programming language. This API includes a framework whereby different drivers
can be installed dynamically to access different data sources. Although the
JDBCTM API is mainly geared to passing
SQL statements to a database, it provides for reading and writing data from
any data source with a tabular format. The reader/writer facility, available
through the javax.sql.RowSet
group of interfaces, can be customized
to use and update data from a spread sheet, flat file, or any other tabular
data source.
java.sql
and the javax.sql
packages. This complete API is include in
the JavaTM 2 SDK Standard Edition (J2SETM), version 1.4. The java.sql
package
is referred to as the JDBC core API providing core application client database
access. The javax.sql
is referred to the JDBC Optional Package
API and extends the functionality of the core java.sql
package.
By strictly subsetting the established JDBC 3.0 API, which includes all previous JDBC API versions listed above, JDBC applications built using the JDBC CDC/FP API are upwardly portable to the full JDBC 3.0 API. A detailed list of the API differences (detailing classes, interfaces and methods) that have been removed a list is provided here
Classes, interfaces, methods, fields, constructors, and exceptions have the following "since" tags that indicate when they were introduced into the Java platform. When these "since" tags are used in JavadocTM comments for the JDBC API, they indicate the following:
NOTE: Many of the new features are optional; consequently, there is some variation in drivers and the features they support. Always check your driver's documentation to see whether it supports a feature before you try to use it.
java.sql
Package Containsjava.sql
package contains API for the following:
Statement
-- used to send basic SQL statements PreparedStatement
-- used to send prepared statements
or basic SQL statements (derived from Statement
)
CallableStatement
-- used to call database stored
procedures (derived from PreparedStatement
)
Connection
interface -- provides methods for creating
statements and managing connections and their properties Savepoint
-- provides savepoints in a transaction
ResultSet
interface Blob
interface -- mapping for SQL BLOB
Clob
interface -- mapping for SQL CLOB
Date
class -- mapping for SQL DATE
Time
class -- mapping for SQL TIME
Timestamp
class -- mapping for SQL TIMESTAMP
Types
class -- provides constants for SQL types
DatabaseMetaData
interface -- provides information
about the database ResultSetMetaData
interface -- provides information
about the columns of a ResultSet
object Savepoint
-- allows a point within a current
transaction from the Connection.rollback
method
SQLException
-- thrown by most methods when there
is a problem accessing data and by some methods for other reasons SQLWarning
-- thrown to indicate a warning DataTruncation
-- thrown to indicate that data may
have been truncated BatchUpdateException
-- thrown to indicate that not
all commands in a batch update executed successfully
@since 1.1
|
JDBC for CDC/FP Optional Package | ||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |