See: Description
| Interface | Description |
|---|---|
| Array |
The mapping in the Java programming language for the SQL type
ARRAY. |
| Blob |
The representation (mapping) in
the Java™ programming
language of an SQL
BLOB value. |
| CallableStatement |
The interface used to execute SQL stored procedures.
|
| Clob |
The mapping in the Java™ 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.
|
| DriverAction |
An interface that must be implemented when a Driver wants to be
notified by
DriverManager. |
| NClob |
The mapping in the Java™ 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.
|
| SQLType |
An object that is used to identify a generic SQL type, called a JDBC type or
a vendor specific data type.
|
| 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 | Description |
|---|---|
| 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 an application with a
SecurityManager enabled, calls the
DriverManager.deregisterDriver method,
DriverManager.setLogWriter method,
DriverManager.setLogStream (deprecated) method,
SyncFactory.setJNDIContext method,
SyncFactory.setLogger method,
Connection.setNetworktimeout method,
or the Connection.abort 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 | Description |
|---|---|
| ClientInfoStatus |
Enumeration for status of the reason that a property could not be set
via a call to
Connection.setClientInfo |
| JDBCType |
Defines the constants that are used to identify generic
SQL types, called JDBC types.
|
| PseudoColumnUsage |
Enumeration for pseudo/hidden column usage.
|
| RowIdLifetime |
Enumeration for RowId life-time values.
|
| Exception | Description |
|---|---|
| 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
exceeded 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', or under vendor-specified conditions. |
| 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', or under vendor-specified conditions. |
| SQLInvalidAuthorizationSpecException |
The subclass of
SQLException thrown when the SQLState class value
is '28', or under vendor-specified conditions. |
| SQLNonTransientConnectionException |
The subclass of
SQLException thrown for the SQLState
class value '08', or under vendor-specified conditions. |
| 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', or under vendor-specified conditions. |
| SQLTimeoutException |
The subclass of
SQLException thrown when the timeout specified by
Statement.setQueryTimeout, DriverManager.setLoginTimeout,
DataSource.setLoginTimeout,XADataSource.setLoginTimeout
has expired. |
| SQLTransactionRollbackException |
The subclass of
SQLException thrown when the SQLState class value
is '40', or under vendor-specified conditions. |
| SQLTransientConnectionException |
The subclass of
SQLException for the SQLState class
value '08', or under vendor-specified conditions. |
| SQLTransientException |
The subclass of
SQLException is thrown in situations where a
previously 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.
|
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 7.
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.2 APIJDBCType enum and SQLType interfaceREF CURSORS in CallableStatement
DatabaseMetaData methods to return maximum Logical LOB size
and if Ref Cursors are supportedjava.sql and javax.sql Features Introduced in the JDBC 4.1 APIConnection,
ResultSet and Statement objects to be
used with the try-with-resources statementCallableStatement and
ResultSet to specify the Java type to convert to via the
getObject methodDatabaseMetaData methods to return PseudoColumns and if a
generated key is always returnedConnection to specify a database schema,
abort and timeout a physical connection.Statement object when its dependent
objects have been closedDriver,
DataSource, ConnectionPoolDataSource and
XADataSourcejava.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.
Submit a bug or feature
For further API reference and developer documentation, see Java SE Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.
Copyright © 1993, 2025, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Also see the documentation redistribution policy.
Scripting on this page tracks web page traffic, but does not change the content in any way.