Examples of org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator

Package org.springframework.jdbc.support

Examples of org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator
Implementation of SQLExceptionTranslator that analyzes vendor-specific error codes. More precise than an implementation based on SQL state, but vendor-specific.
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.
- Use subclass translator. Java 6 introduces its own SQLException hierarchy and in a Java 6 or later environment we will attempt a translation based on the subclass of the exception.
- Apply error code matching. Error codes are obtained from the SQLErrorCodesFactory by default. This factory loads a "sql-error-codes.xml" file from the class path, defining error code mappings for database names from database metadata.
- Fallback to a fallback translator. SQLStateSQLExceptionTranslator is the default fallback translator, analyzing the exception's SQL state only.
The configuration file named "sql-error-codes.xml" is by default read from this package. It can be overridden through a file of the same name in the root of the class path (e.g. in the "/WEB-INF/classes" directory). @author Rod Johnson @author Thomas Risberg @author Juergen Hoeller @see SQLErrorCodesFactory @see SQLStateSQLExceptionTranslator

      if (resultSet == null) {
        try {
          this.statement.setBoolean(pColOrdinal, pValue);
        }
        catch (SQLException e) {
          DataAccessException errorVar = new SQLErrorCodeSQLExceptionTranslator().translate("DBDataSet.setValue(" + pColOrdinal +"," + pValue + ")", "", e );
          ErrorMgr.addError(errorVar);
          throw errorVar;
        }
      } else {
        // AD:20/11/2008: Allow for CachedRowSet to be updated if the DBDataSet has already been populated.

View Full Code Here

      if (resultSet == null) {
        try {
          this.statement.setShort(pColOrdinal, pValue);
        }
        catch (SQLException e) {
          DataAccessException errorVar = new SQLErrorCodeSQLExceptionTranslator().translate("DBDataSet.setValue(" + pColOrdinal +"," + pValue + ")", "", e );
          ErrorMgr.addError(errorVar);
          throw errorVar;
        }
      } else {
        // AD:20/11/2008: Allow for CachedRowSet to be updated if the DBDataSet has already been populated.

View Full Code Here

      if (resultSet == null) {
        try {
          this.statement.setString(pColOrdinal, pValue);
        }
        catch (SQLException e) {
          DataAccessException errorVar = new SQLErrorCodeSQLExceptionTranslator().translate("DBDataSet.setValue(" + pColOrdinal +"," + pValue + ")", "", e );
          ErrorMgr.addError(errorVar);
          throw errorVar;
        }
      } else {
        // AD:20/11/2008: Allow for CachedRowSet to be updated if the DBDataSet has already been populated.

View Full Code Here

                s.setPrev(null);
                this.cache.remove(s.getKey());
                try {
                    s.getHandle().close();
                } catch (java.sql.SQLException qq_SQLEx) {
                    throw new SQLErrorCodeSQLExceptionTranslator().translate("SQL tasks", "", qq_SQLEx );
                }


            }


        }

View Full Code Here

     * database type with a generic database type
     * @param e The exception that was thrown
     * @return
     */
    public static DataAccessException translateSQLException(SQLException e){
      return new SQLErrorCodeSQLExceptionTranslator().translate("SQL tasks", null, e );
    }

View Full Code Here

     * @return
     */
    public static DataAccessException translateSQLException(int dbType, SQLException e){
        switch (dbType) {
            case Constants.DB_VT_DB2:
                return new SQLErrorCodeSQLExceptionTranslator("DB2").translate("SQL tasks", null, e );
            case Constants.DB_VT_INFORMIX:
                return new SQLErrorCodeSQLExceptionTranslator("Informix").translate("SQL tasks", null, e );
            case Constants.DB_VT_INGRES:
                return new SQLErrorCodeSQLExceptionTranslator("PostgreSQL").translate("SQL tasks", null, e );
            case Constants.DB_VT_MYSQL:
                return new SQLErrorCodeSQLExceptionTranslator("MySQL").translate("SQL tasks", null, e );
            case Constants.DB_VT_ORACLE:
                return new SQLErrorCodeSQLExceptionTranslator("Oracle").translate("SQL tasks", null, e );
            case Constants.DB_VT_SYBASE:
                return new SQLErrorCodeSQLExceptionTranslator("Sybase").translate("SQL tasks", null, e );
            default:
                return new SQLErrorCodeSQLExceptionTranslator().translate("SQL tasks", null, e );
        }
    }

View Full Code Here

   * @see org.springframework.jdbc.support.SQLStateSQLExceptionTranslator
   */
  static SQLExceptionTranslator newJdbcExceptionTranslator(Object connectionFactory) {
    // Check for PersistenceManagerFactory's DataSource.
    if (connectionFactory instanceof DataSource) {
      return new SQLErrorCodeSQLExceptionTranslator((DataSource) connectionFactory);
    }
    else {
      return new SQLStateSQLExceptionTranslator();
    }
  }

View Full Code Here

   * @see org.springframework.jdbc.support.SQLStateSQLExceptionTranslator
   */
  public static SQLExceptionTranslator newJdbcExceptionTranslator(SessionFactory sessionFactory) {
    DataSource ds = getDataSource(sessionFactory);
    if (ds != null) {
      return new SQLErrorCodeSQLExceptionTranslator(ds);
    }
    return new SQLStateSQLExceptionTranslator();
  }

View Full Code Here

   * for the SessionFactory's underlying DataSource.
   */
  protected synchronized SQLExceptionTranslator getDefaultJdbcExceptionTranslator() {
    if (this.defaultJdbcExceptionTranslator == null) {
      if (getDataSource() != null) {
        this.defaultJdbcExceptionTranslator = new SQLErrorCodeSQLExceptionTranslator(getDataSource());
      }
      else {
        this.defaultJdbcExceptionTranslator = SessionFactoryUtils.newJdbcExceptionTranslator(getSessionFactory());
      }
    }

View Full Code Here

   * @see org.springframework.jdbc.support.SQLStateSQLExceptionTranslator
   */
  public static SQLExceptionTranslator newJdbcExceptionTranslator(SessionFactory sessionFactory) {
    DataSource ds = getDataSource(sessionFactory);
    if (ds != null) {
      return new SQLErrorCodeSQLExceptionTranslator(ds);
    }
    return new SQLStateSQLExceptionTranslator();
  }

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator

com.alibaba.cobar.client.CobarSqlMapClientTemplate

com.alibaba.cobar.client.support.execution.DefaultConcurrentRequestProcessor

Express.services.BusinessDBMgr

Express.services.SqlStatementCache

GenericDBMS.DBDataSet

GenericDBMS.DBUtilities

net.helipilot50.stocktrade.genericdbms.DBDataSet

net.helipilot50.stocktrade.genericdbms.DBUtilities

net.helipilot50.stocktrade.services.CustDBMgr

net.helipilot50.stocktrade.services.CustomerMgr

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.