|
Java™ Platform Standard Ed. 6 |
|||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |
See:
Description
Interface Summary | |
---|---|
Array | The mapping in the Java programming language for the SQL type
ARRAY . |
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. |
Driver | The interface that every driver class must implement. |
NClob | The mapping in the JavaTM programming language
for the SQL NCLOB type. |
ParameterMetaData | An object that can be used to get information about the types
and properties for each parameter marker in a
PreparedStatement object. |
PreparedStatement | An object that represents a precompiled SQL statement. |
Ref | The mapping in the Java programming language of an SQL REF
value, which is a reference to an SQL structured type value in the database. |
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. |
RowId | The representation (mapping) in the Java programming language of an SQL ROWID value. |
Savepoint | The representation of a savepoint, which is a point within
the current transaction that can be referenced from the
Connection.rollback method. |
SQLData | The interface used for the custom mapping of an SQL user-defined type (UDT) to a class in the Java programming language. |
SQLInput | An input stream that contains a stream of values representing an instance of an SQL structured type or an SQL distinct type. |
SQLOutput | The output stream for writing the attributes of a user-defined type back to the database. |
SQLXML | The mapping in the JavaTM programming language for the SQL XML type. |
Statement | The object used for executing a static SQL statement and returning the results it produces. |
Struct | The standard mapping in the Java programming language for an SQL structured type. |
Wrapper | Interface for JDBC classes which provide the ability to retrieve the delegate instance when the instance in question is in fact a proxy class. |
Class Summary | |
---|---|
Date | A thin wrapper around a millisecond value that allows
JDBC to identify this as an SQL DATE value. |
DriverManager | The basic service for managing a set of JDBC drivers. NOTE: The DataSource interface, new in the
JDBC 2.0 API, provides another way to connect to a data source. |
DriverPropertyInfo | Driver properties for making a connection. |
SQLPermission | The permission for which the SecurityManager will check
when code that is running in an applet calls the
DriverManager.setLogWriter method or the
DriverManager.setLogStream (deprecated) method. |
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. |
Enum Summary | |
---|---|
ClientInfoStatus | Enumeration for status of the reason that a property could not be set
via a call to Connection.setClientInfo |
RowIdLifetime | Enumeration for RowId life-time values. |
Exception Summary | |
---|---|
BatchUpdateException | The subclass of SQLException thrown when an error
occurs during a batch update operation. |
DataTruncation | An exception thrown as a DataTruncation exception
(on writes) or reported as a
DataTruncation warning (on reads)
when a data values is unexpectedly truncated for reasons other than its having
execeeded MaxFieldSize . |
SQLClientInfoException | The subclass of SQLException is thrown when one or more client info properties
could not be set on a Connection . |
SQLDataException | The subclass of SQLException thrown when the SQLState class value is '22'. |
SQLException | An exception that provides information on a database access error or other errors. |
SQLFeatureNotSupportedException | The subclass of SQLException thrown when the SQLState class value is '0A'
( the value is 'zero' A). |
SQLIntegrityConstraintViolationException | The subclass of SQLException thrown when the SQLState class value is '23'. |
SQLInvalidAuthorizationSpecException | The subclass of SQLException thrown when the SQLState class value is '28'. |
SQLNonTransientConnectionException | The subclass of SQLException thrown for the SQLState
class value '08', representing
that the connection operation that failed will not succeed when
the operation is retried without the cause of the failure being corrected. |
SQLNonTransientException | The subclass of SQLException thrown when an instance where a retry
of the same operation would fail unless the cause of the SQLException
is corrected. |
SQLRecoverableException | The subclass of SQLException thrown in situations where a
previously failed operation might be able to succeed if the application performs
some recovery steps and retries the entire transaction or in the case of a
distributed transaction, the transaction branch. |
SQLSyntaxErrorException | The subclass of SQLException thrown when the SQLState class value is '42'. |
SQLTimeoutException | The subclass of SQLException thrown when the timeout specified by Statement
has expired. |
SQLTransactionRollbackException | The subclass of SQLException thrown when the SQLState class value is '40'. |
SQLTransientConnectionException | The subclass of SQLException for the SQLState class
value '08', representing
that the connection operation that failed might be able to succeed when
the operation is retried without any application-level changes. |
SQLTransientException | The subclass of SQLException is thrown in situations where a
previoulsy failed operation might be able to succeed when the operation is
retried without any intervention by application-level functionality. |
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
package, referred to as the JDBC core API,
and the javax.sql
package, referred to as the JDBC Optional
Package API. This complete JDBC API
is included in the JavaTM
Standard Edition (Java SETM), version 6.
The javax.sql
package extends the functionality of the JDBC API
from a client-side API to a server-side API, and it is an essential part
of the JavaTM Enterprise Edition
(Java EETM) technology.
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.
NOTE: The class SQLPermission
was added in the
JavaTM 2 SDK, Standard Edition,
version 1.3 release. This class is used to prevent unauthorized
access to the logging stream associated with the DriverManager
,
which may contain information such as table names, column data, and so on.
java.sql
Package Containsjava.sql
package contains API for the following:
DriverManager
facility
DriverManager
class -- makes a connection with a driver
SQLPermission
class -- provides permission when code
running within a Security Manager, such as an applet,
attempts to set up a logging stream through the
DriverManager
Driver
interface -- provides the API for registering
and connecting drivers based on JDBC technology ("JDBC drivers");
generally used only by the DriverManager
class
DriverPropertyInfo
class -- provides properties for a
JDBC driver; not used by the general user
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
Array
interface -- mapping for SQL ARRAY
Blob
interface -- mapping for SQL BLOB
Clob
interface -- mapping for SQL CLOB
Date
class -- mapping for SQL DATE
NClob
interface -- mapping for SQL NCLOB
Ref
interface -- mapping for SQL REF
RowId
interface -- mapping for SQL ROWID
Struct
interface -- mapping for SQL STRUCT
SQLXML
interface -- mapping for SQL XML
Time
class -- mapping for SQL TIME
Timestamp
class -- mapping for SQL TIMESTAMP
Types
class -- provides constants for SQL types
SQLData
interface -- specifies the mapping of
a UDT to an instance of this class
SQLInput
interface -- provides methods for reading
UDT attributes from a stream
SQLOutput
interface -- provides methods for writing
UDT attributes back to a stream
DatabaseMetaData
interface -- provides information
about the database
ResultSetMetaData
interface -- provides information
about the columns of a ResultSet
object
ParameterMetaData
interface -- provides information
about the parameters to PreparedStatement
commands
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
java.sql
and javax.sql
Features Introduced in the JDBC 4.0 APIjava.sql.Driver
class via Class.forName
PreparedStatement
that is associated
with a PooledConnection
has been closed or the driver determines is invalid
java.sql
and javax.sql
Features Introduced in the JDBC 3.0 APIConnectionPoolDataSource
-- specify
how connections are to be pooled
PreparedStatement
object
ResultSet
objects
returned from CallableStatement
objects open at the
same time
CallableStatement
objects by name as well as by index
ResultSet
holdability -- ability to specify whether cursors
should be held open or closed at the end of a transaction
Ref
object references
BLOB
,
CLOB
, ARRAY
, and REF
values.
java.sql.Types.DATALINK
data type --
allows JDBC drivers access to objects stored outside a data source
java.sql
Features Introduced in the JDBC 2.1 Core APIResultSet
interface that allow the cursor to be moved to a particular row or to a
position relative to its current position
ResultSet
updater methods
java.math.BigDecimal
values,
additional security, and
support for time zones in date, time, and timestamp values.
javax.sql
Features Introduced in the JDBC 2.0 Optional
Package APIDataSource
interface as a means of making a connection. The
Java Naming and Directory InterfaceTM
(JNDI) is used for registering a DataSource
object with a
naming service and also for retrieving it.
RowSet
technology -- providing a convenient means of
handling and passing data
DISTINCT
type are the UDTs that may be custom mapped. The following three
steps set up a custom mapping:
DISTINCT
type in SQL
SQLData
interface.
Connection
object's type map
that contains two things:
Class
object for the class that implements the
SQLData
interface
When these are in place for a UDT, calling the methods
ResultSet.getObject
or CallableStatement.getObject
on that UDT will automatically retrieve the custom mapping for it. Also, the
PreparedStatement.setObject
method will automatically map the
object back to its SQL type to store it in the data source.
|
Java™ Platform Standard Ed. 6 |
|||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |
Copyright © 1993, 2010, Oracle and/or its affiliates. All rights reserved.