org.springframework.jdbc.support
Class SQLErrorCodeSQLExceptionTranslator

public class SQLErrorCodeSQLExceptionTranslator

implements SQLExceptionTranslator

Implementation of SQLExceptionTranslator that uses specific vendor codes. More precise than SQLState implementation, but vendor specific.

The JdbcTemplate class enables error handling to be parameterized without making application's dependent on a particular RDBMS.

This class applies the following matching rules:

• Try custom translation implemented by any subclass. Note that this class is concrete and is typically used itself, in which case this rule doesn't apply.
• Apply error code matching. Error codes are obtained from the SQLErrorCodesFactory by default. This looks up error codes from the classpath and keys into them from the database name from the database metadata.
• Fallback to fallback translator. SQLStateSQLExceptionTranslator is the default fallback translator.

Author:

Rod Johnson, Thomas Risberg

Version: $Id: SQLErrorCodeSQLExceptionTranslator.java,v 1.1 2003/12/05 17:03:14 jhoeller Exp $

See Also: SQLErrorCodesFactory

public SQLErrorCodeSQLExceptionTranslator()

Constructor for use as a JavaBean. The SqlErrorCodes or DataSource property must be set.

public SQLErrorCodeSQLExceptionTranslator(SQLErrorCodes sec)

Create a SQLErrorCode translator given these error codes. Does not require a database metadata lookup to be performed using a connection.

Parameters:

sec - error codes

public SQLErrorCodeSQLExceptionTranslator(DataSource ds)

Create a SQLErrorCode translator for the given DataSource. Invoking this constructor will cause a connection to be obtained from the DataSource to get the metadata

Parameters:

ds - DataSource to use to find metadata and establish which error codes are usable

public void setDataSource(DataSource ds)

Set the DataSource. Setting this property will cause a connection to be obtained from the DataSource to get the metadata

Parameters:

ds - DataSource to use to find metadata and establish which error codes are usable

public void setFallbackTranslator(SQLExceptionTranslator fallback)

Override the default SQLState fallback translator

Parameters:

fallback - custom fallback exception translator to use if error code translation fails

public void setSqlErrorCodes(SQLErrorCodes sec)

Set custom error codes to be used for translation

Parameters:

sec - custom error codes to use

public DataAccessException translate(String task, String sql, SQLException sqlex)

See Also:

SQLExceptionTranslator.translate(java.lang.String,java.lang.String,java.sql.SQLException)

Association Links

to Class org.springframework.jdbc.support.SQLErrorCodes

Error codes available to subclasses

to Class org.springframework.jdbc.support.SQLExceptionTranslator

Fallback translator to use if SQLError code matching doesn't work