Package com.interface21.jdbc.core

The classes in this package make JDBC easier to use and reduce the likelihood of common errors.

See:
Description

Interface Summary

BatchPreparedStatementSetter	Callback interface used by the JdbcTemplate class.
ColumnExtractor	Interface to be implemented by objects that know how to extract columns from a ResultSet and ensure that they are of a given type.
DataFieldMaxValueIncrementer	Interface that defines contract of incrementing any data store field's maximum value.
PreparedStatementCreator	One of the two central callback interfaces used by the JdbcTemplate class.
PreparedStatementSetter	Callback interface used by the JdbcTemplate class.
ResultReader	Extension of RowCallbackHandler interfaces that saves the accumulated results as a Collection.
ResultSetExtracter	Callback interfaces used by the JdbcTemplate class's doWithResultSetXXXX() methods.
RowCallbackHandler	One of the two central callback interfaces used by the JdbcTemplate class.
SQLExceptionTranslater	Interface to be implemented by classes that can translate between SQLExceptions and our data access strategy-agnostic com.interface21.dao.DataAccessException.

Class Summary

DefaultColumnExtractor	Default implementation of the ColumnExtractor interface.
JdbcHelper	Utility class to use for JDBC queries from J2EE applications.
JdbcTemplate	This is the central class in this package. It simplifies the use of JDBC and helps to avoid common errors.
PreparedStatementCreatorFactory	Helper class that can efficiently create multiple PreparedStatementCreator objects with different parameters based on a SQL statement and a single set of parameter declarations.
ReadOnlyResultSet	A class that implements java.sql.ResultSet which is used in the JdbcTemplateclass.
RowCountCallbackHandler	Implementation of RowCallbackHandler.
SQLErrorCodes	JavaBean for holding JDBC Error Codes - loaded through BeanFactory implementation.
SQLErrorCodeSQLExceptionTranslater	Implementation of SQLExceptionTranslator that uses specific vendor codes defined in a configuration file named "sql-error-codes.xml".
SQLExceptionTranslaterFactory	Factory for creating SQLExceptionTranslator based on the DatabaseProductName taken from the DatabaseMetaData.
SqlParameter	Object to represent a SQL parameter definition.
SQLStateSQLExceptionTranslater	Implementation of SQLExceptionTranslater that uses the SQLState code in the SQL exception.

Exception Summary

BadSqlGrammarException	Exception thrown when SQL specified is invalid.
InvalidParameterException	Exception thrown when a unauthorised method from a ResultSet instance is invoked.
InvalidResultSetMethodInvocationException	Exception thrown when a unauthorised method from a ResultSet instance is invoked.
JdbcUpdateAffectedIncorrectNumberOfRowsException	Exception thrown when a JDBC update affects an unexpected number of rows.
SQLWarningException	Exception thrown when we're not ignoring warnings.
UncategorizedSQLException	Exception thrown when we can't classify a SQLException into one of our generic data access exceptions

Package com.interface21.jdbc.core Description

The classes in this package make JDBC easier to use and reduce the likelihood of common errors. In particular, they:

• Simplify error handling, avoiding the need for try/catch/final blocks in application code.
• Present exceptions to application code in a generic hierarchy of unchecked exceptions, enabling applications to catch data access exceptions without being dependent on JDBC, and to ignore fatal exceptions there is no value in catching.
• Allow the implementation of error handling to be modified to target different RDBMSes without introducing proprietary dependencies into application code.

This package and related packages are discussed in Chapter 9 of Expert One-On-One J2EE Design and Development by Rod Johnson (Wrox, 2002).