Use is subject to License Terms. Your use of this web site or any of its content or software indicates your agreement to be bound by these License Terms.

Copyright © 2006 Sun Microsystems, Inc. All rights reserved.

JDBC for CDC/FP Optional Package

Package java.sql

Provides the API for accessing and processing data stored in a data source (usually a relational database) using the JavaTM programming language.

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.
 

Package java.sql Description

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.

What the JDBCTM for CDC/FP Optional Package includes

The JDBCTM CDC/FP Optional Package API includes a strict subset of the JDBC 3.0 API which provides the 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.

Versions

The parent JDBC 3.0 API incorporates all of the previous JDBC API versions:

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.

What the java.sql Package Contains

The java.sql package contains API for the following:

Package Specification

Related Documentation

@since 1.1



JDBC for CDC/FP Optional Package

Copyright © 2006 Sun Microsystems, Inc. All rights reserved. Use is subject to License Terms. Your use of this web site or any of its content or software indicates your agreement to be bound by these License Terms.

For more information, please consult the JSR 169 specification.