java.sql

Stay organized with collections Save and categorize content based on your preferences.

Interfaces

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. 

Classes

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. 

DriverPropertyInfo

Driver properties for making a connection. 

SQLPermission Legacy security code; do not use. 
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. 

Enums

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. 

Exceptions

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', 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 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 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.