javax.sql.RowSetgroup of interfaces, can be customized to use and update data from a spread sheet, flat file, or any other tabular data source.
java.sqlpackage, referred to as the JDBC core API, and the
javax.sqlpackage, referred to as the JDBC Optional Package API. This complete JDBC API is included in the Java TM Standard Edition (Java SE TM), version 7. The
javax.sqlpackage 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 Java TM Enterprise Edition (Java EE TM) 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.sqlpackage contains API for the following:
DriverManagerclass -- makes a connection with a driver
SQLPermissionclass -- provides permission when code running within a Security Manager, such as an applet, attempts to set up a logging stream through the
Driverinterface -- provides the API for registering and connecting drivers based on JDBC technology ("JDBC drivers"); generally used only by the
DriverPropertyInfoclass -- 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
CallableStatement-- used to call database stored procedures (derived from
Connectioninterface -- provides methods for creating statements and managing connections and their properties
Savepoint-- provides savepoints in a transaction
Arrayinterface -- mapping for SQL
Blobinterface -- mapping for SQL
Clobinterface -- mapping for SQL
Dateclass -- mapping for SQL
NClobinterface -- mapping for SQL
Refinterface -- mapping for SQL
RowIdinterface -- mapping for SQL
Structinterface -- mapping for SQL
SQLXMLinterface -- mapping for SQL
Timeclass -- mapping for SQL
Timestampclass -- mapping for SQL
Typesclass -- provides constants for SQL types
SQLDatainterface -- specifies the mapping of a UDT to an instance of this class
SQLInputinterface -- provides methods for reading UDT attributes from a stream
SQLOutputinterface -- provides methods for writing UDT attributes back to a stream
DatabaseMetaDatainterface -- provides information about the database
ResultSetMetaDatainterface -- provides information about the columns of a
ParameterMetaDatainterface -- provides information about the parameters to
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
javax.sqlFeatures Introduced in the JDBC 4.1 API
Statementobjects to be used with the try-with-resources statement
ResultSetto specify the Java type to convert to via the
DatabaseMetaDatamethods to return PseudoColumns and if a generated key is always returned
Connectionto specify a database schema, abort and timeout a physical connection.
Statementobject when its dependent objects have been closed
javax.sqlFeatures Introduced in the JDBC 4.0 API
PreparedStatementthat is associated with a
PooledConnectionhas been closed or the driver determines is invalid
javax.sqlFeatures Introduced in the JDBC 3.0 API
ConnectionPoolDataSource-- specify how connections are to be pooled
ResultSetobjects returned from
CallableStatementobjects open at the same time
CallableStatementobjects by name as well as by index
ResultSetholdability -- ability to specify whether cursors should be held open or closed at the end of a transaction
java.sql.Types.DATALINKdata type -- allows JDBC drivers access to objects stored outside a data source
java.sqlFeatures Introduced in the JDBC 2.1 Core API
ResultSetinterface that allow the cursor to be moved to a particular row or to a position relative to its current position
java.math.BigDecimalvalues, additional security, and support for time zones in date, time, and timestamp values.
javax.sqlFeatures Introduced in the JDBC 2.0 Optional Package API
DataSourceinterface as a means of making a connection. The Java Naming and Directory InterfaceTM (JNDI) is used for registering a
DataSourceobject with a naming service and also for retrieving it.
RowSettechnology -- providing a convenient means of handling and passing data
DISTINCTtype are the UDTs that may be custom mapped. The following three steps set up a custom mapping:
DISTINCTtype in SQL
Connectionobject's type map that contains two things:
Classobject for the class that implements the
When these are in place for a UDT, calling the methods
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.
|Array|| The mapping in the Java programming language for the SQL type
|Blob|| The representation (mapping) in the JavaTM programming language of an SQL
|CallableStatement||The interface used to execute SQL stored procedures.|
|Clob|| The mapping in the JavaTM programming language for the SQL
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
|ParameterMetaData|| An object that can be used to get information about the types and properties for each parameter marker in a
|PreparedStatement||An object that represents a precompiled SQL statement.|
|Ref|| The mapping in the Java programming language of an SQL
|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
|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
|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.|
The object used for executing a static SQL statement and returning the results it produces.
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.|
A thin wrapper around a millisecond value that allows JDBC to identify this as an SQL
The basic service for managing a set of JDBC drivers.
Driver properties for making a connection.
|SQLPermission||Legacy security code; do not use.|
A thin wrapper around the
A thin wrapper around
The class that defines the constants that are used to identify generic SQL types, called JDBC types.
|ClientInfoStatus|| Enumeration for status of the reason that a property could not be set via a call to
|RowIdLifetime||Enumeration for RowId life-time values.|
|BatchUpdateException|| The subclass of
|DataTruncation|| An exception thrown as a
|SQLClientInfoException|| The subclass of
|SQLDataException|| The subclass of
An exception that provides information on a database access error or other errors.
|SQLFeatureNotSupportedException|| The subclass of
|SQLIntegrityConstraintViolationException|| The subclass of
|SQLInvalidAuthorizationSpecException|| The subclass of
|SQLNonTransientConnectionException|| The subclass of
|SQLNonTransientException|| The subclass of
|SQLRecoverableException|| The subclass of
|SQLSyntaxErrorException|| The subclass of
The subclass of
|SQLTransactionRollbackException|| The subclass of
|SQLTransientConnectionException|| The subclass of
|SQLTransientException|| The subclass of
An exception that provides information on database access warnings.