Module java.sql
Package java.sql
-
Interface Summary Interface Description Array The mapping in the Java programming language for the SQL typeARRAY.Blob The representation (mapping) in the Java™ programming language of an SQLBLOBvalue.CallableStatement The interface used to execute SQL stored procedures.Clob The mapping in the Java™ programming language for the SQLCLOBtype.Connection A connection (session) with a specific database.ConnectionBuilder A builder created from aDataSourceobject, used to establish a connection to the database that thedata sourceobject represents.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 byDriverManager.NClob The mapping in the Java™ programming language for the SQLNCLOBtype.ParameterMetaData An object that can be used to get information about the types and properties for each parameter marker in aPreparedStatementobject.PreparedStatement An object that represents a precompiled SQL statement.Ref The mapping in the Java programming language of an SQLREFvalue, 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 aResultSetobject.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 theConnection.rollbackmethod.ShardingKey Interface used to indicate that this object represents a Sharding Key.ShardingKeyBuilder A builder created from aDataSourceorXADataSourceobject, used to create aShardingKeywith sub-keys of supported data types.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 Summary Class Description Date A thin wrapper around a millisecond value that allows JDBC to identify this as an SQLDATEvalue.DriverManager The basic service for managing a set of JDBC drivers.DriverPropertyInfo Driver properties for making a connection.SQLPermission The permission for which theSecurityManagerwill check when code that is running an application with aSecurityManagerenabled, calls theDriverManager.deregisterDrivermethod,DriverManager.setLogWritermethod,DriverManager.setLogStream(deprecated) method,SyncFactory.setJNDIContextmethod,SyncFactory.setLoggermethod,Connection.setNetworkTimeoutmethod, or theConnection.abortmethod.Time A thin wrapper around thejava.util.Dateclass that allows the JDBC API to identify this as an SQLTIMEvalue.Timestamp A thin wrapper aroundjava.util.Datethat allows the JDBC API to identify this as an SQLTIMESTAMPvalue.Types The class that defines the constants that are used to identify generic SQL types, called JDBC types. -
Enum Summary Enum Description ClientInfoStatus Enumeration for status of the reason that a property could not be set via a call toConnection.setClientInfoJDBCType 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 Summary Exception Description BatchUpdateException The subclass ofSQLExceptionthrown when an error occurs during a batch update operation.DataTruncation An exception thrown as aDataTruncationexception (on writes) or reported as aDataTruncationwarning (on reads) when a data values is unexpectedly truncated for reasons other than its having exceededMaxFieldSize.SQLClientInfoException The subclass ofSQLExceptionis thrown when one or more client info properties could not be set on aConnection.SQLDataException The subclass ofSQLExceptionthrown 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 ofSQLExceptionthrown when the SQLState class value is '0A' ( the value is 'zero' A).SQLIntegrityConstraintViolationException The subclass ofSQLExceptionthrown when the SQLState class value is '23', or under vendor-specified conditions.SQLInvalidAuthorizationSpecException The subclass ofSQLExceptionthrown when the SQLState class value is '28', or under vendor-specified conditions.SQLNonTransientConnectionException The subclass ofSQLExceptionthrown for the SQLState class value '08', or under vendor-specified conditions.SQLNonTransientException The subclass ofSQLExceptionthrown when an instance where a retry of the same operation would fail unless the cause of theSQLExceptionis corrected.SQLRecoverableException The subclass ofSQLExceptionthrown 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 ofSQLExceptionthrown when the SQLState class value is '42', or under vendor-specified conditions.SQLTimeoutException The subclass ofSQLExceptionthrown when the timeout specified byStatement.setQueryTimeout,DriverManager.setLoginTimeout,DataSource.setLoginTimeout,XADataSource.setLoginTimeouthas expired.SQLTransactionRollbackException The subclass ofSQLExceptionthrown when the SQLState class value is '40', or under vendor-specified conditions.SQLTransientConnectionException The subclass ofSQLExceptionfor the SQLState class value '08', or under vendor-specified conditions.SQLTransientException The subclass ofSQLExceptionis 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.