javax.sql

  • The javax.sql package provides interfaces and classes for interacting with data sources, including connection pooling and event management.

  • Key interfaces define factories for connections (DataSource, ConnectionPoolDataSource), manage pooled connections (PooledConnection), and enable disconnected data access (RowSet).

  • Event listener interfaces like ConnectionEventListener and StatementEventListener allow for monitoring connection and statement events.

  • RowSet objects, combined with readers and writers, enable manipulating data independently of the data source.

  • The package leverages the JavaBeans component model for integration with other Java technologies.

Interfaces

CommonDataSource Interface that defines the methods which are common between DataSource, XADataSource and ConnectionPoolDataSource
ConnectionEventListener

An object that registers to be notified of events generated by a PooledConnection object. 

ConnectionPoolDataSource A factory for PooledConnection objects. 
DataSource

A factory for connections to the physical data source that this DataSource object represents. 

PooledConnection An object that provides hooks for connection pool management. 
RowSet The interface that adds support to the JDBC API for the JavaBeansTM component model. 
RowSetInternal The interface that a RowSet object implements in order to present itself to a RowSetReader or RowSetWriter object. 
RowSetListener An interface that must be implemented by a component that wants to be notified when a significant event happens in the life of a RowSet object. 
RowSetMetaData An object that contains information about the columns in a RowSet object. 
RowSetReader The facility that a disconnected RowSet object calls on to populate itself with rows of data. 
RowSetWriter An object that implements the RowSetWriter interface, called a writer
StatementEventListener An object that registers to be notified of events that occur on PreparedStatements that are in the Statement pool. 

Classes

ConnectionEvent

An Event object that provides information about the source of a connection-related event. 

RowSetEvent An Event object generated when an event occurs to a RowSet object. 
StatementEvent A StatementEvent is sent to all StatementEventListeners which were registered with a PooledConnection