org.springframework.jdbc.support

Interface SQLExceptionTranslator

All Known Implementing Classes:

AbstractFallbackSQLExceptionTranslator, SQLErrorCodeSQLExceptionTranslator, SQLExceptionSubclassTranslator, SQLStateSQLExceptionTranslator

public interface SQLExceptionTranslator

Strategy interface for translating between SQLExceptions and Spring's data access strategy-agnostic DataAccessException hierarchy.

Implementations can be generic (for example, using SQLState codes for JDBC) or wholly proprietary (for example, using Oracle error codes) for greater precision.

Author:

Rod Johnson, Juergen Hoeller

See Also:

DataAccessException

Method Summary

Modifier and Type	Method and Description
DataAccessException	translate(java.lang.String task, java.lang.String sql, java.sql.SQLException ex) Translate the given SQLException into a generic DataAccessException.

Method Detail

translate

DataAccessException translate(java.lang.String task,
                              java.lang.String sql,
                              java.sql.SQLException ex)

Translate the given SQLException into a generic DataAccessException.

The returned DataAccessException is supposed to contain the original SQLException as root cause. However, client code may not generally rely on this due to DataAccessExceptions possibly being caused by other resource APIs as well. That said, a getRootCause() instanceof SQLException check (and subsequent cast) is considered reliable when expecting JDBC-based access to have happened.

Parameters:

task - readable text describing the task being attempted

sql - the SQL query or update that caused the problem (if known)

ex - the offending SQLException

Returns:

the DataAccessException wrapping the SQLException, or null if no translation could be applied (in a custom translator; the default translators always throw an UncategorizedSQLException in such a case)

See Also:

NestedRuntimeException.getRootCause()