/*
 * Copyright 2002-2020 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      https://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.springframework.jdbc.support;

import java.sql.SQLException;

import javax.sql.DataSource;

import org.springframework.core.SpringProperties;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.lang.Nullable;

JdbcAccessor-aligned subclass of the plain DataSourceTransactionManager, adding common JDBC exception translation for the commit and rollback step. Typically used in combination with JdbcTemplate which applies the same SQLExceptionTranslator infrastructure by default.

Exception translation is specifically relevant for commit steps in serializable transactions (e.g. on Postgres) where concurrency failures may occur late on commit. This allows for throwing ConcurrencyFailureException to callers instead of TransactionSystemException.

Analogous to HibernateTransactionManager and JpaTransactionManager, this transaction manager may throw DataAccessException from AbstractPlatformTransactionManager.commit and possibly also from AbstractPlatformTransactionManager.rollback. Calling code should be prepared for handling such exceptions next to TransactionException, which is generally sensible since TransactionSynchronization implementations may also throw such exceptions in their flush and beforeCommit phases.

Author:Juergen Hoeller, Sebastien Deleuze
See Also:
Since:5.3
/** * {@link JdbcAccessor}-aligned subclass of the plain {@link DataSourceTransactionManager}, * adding common JDBC exception translation for the commit and rollback step. * Typically used in combination with {@link org.springframework.jdbc.core.JdbcTemplate} * which applies the same {@link SQLExceptionTranslator} infrastructure by default. * * <p>Exception translation is specifically relevant for commit steps in serializable * transactions (e.g. on Postgres) where concurrency failures may occur late on commit. * This allows for throwing {@link org.springframework.dao.ConcurrencyFailureException} to * callers instead of {@link org.springframework.transaction.TransactionSystemException}. * * <p>Analogous to {@code HibernateTransactionManager} and {@code JpaTransactionManager}, * this transaction manager may throw {@link DataAccessException} from {@link #commit} * and possibly also from {@link #rollback}. Calling code should be prepared for handling * such exceptions next to {@link org.springframework.transaction.TransactionException}, * which is generally sensible since {@code TransactionSynchronization} implementations * may also throw such exceptions in their {@code flush} and {@code beforeCommit} phases. * * @author Juergen Hoeller * @author Sebastien Deleuze * @since 5.3 * @see DataSourceTransactionManager * @see #setDataSource * @see #setExceptionTranslator */
@SuppressWarnings("serial") public class JdbcTransactionManager extends DataSourceTransactionManager {
Boolean flag controlled by a spring.xml.ignore system property that instructs Spring to ignore XML, i.e. to not initialize the XML-related infrastructure.

The default is "false".

/** * Boolean flag controlled by a {@code spring.xml.ignore} system property that instructs Spring to * ignore XML, i.e. to not initialize the XML-related infrastructure. * <p>The default is "false". */
private static final boolean shouldIgnoreXml = SpringProperties.getFlag("spring.xml.ignore"); @Nullable private volatile SQLExceptionTranslator exceptionTranslator; private boolean lazyInit = true;
Create a new JdbcTransactionManager instance. A DataSource has to be set to be able to use it.
See Also:
  • setDataSource
/** * Create a new JdbcTransactionManager instance. * A DataSource has to be set to be able to use it. * @see #setDataSource */
public JdbcTransactionManager() { super(); }
Create a new JdbcTransactionManager instance.
Params:
  • dataSource – the JDBC DataSource to manage transactions for
/** * Create a new JdbcTransactionManager instance. * @param dataSource the JDBC DataSource to manage transactions for */
public JdbcTransactionManager(DataSource dataSource) { this(); setDataSource(dataSource); afterPropertiesSet(); }
Specify the database product name for the DataSource that this transaction manager uses. This allows to initialize an SQLErrorCodeSQLExceptionTranslator without obtaining a Connection from the DataSource to get the meta-data.
Params:
  • dbName – the database product name that identifies the error codes entry
See Also:
/** * Specify the database product name for the DataSource that this transaction manager * uses. This allows to initialize an SQLErrorCodeSQLExceptionTranslator without * obtaining a Connection from the DataSource to get the meta-data. * @param dbName the database product name that identifies the error codes entry * @see JdbcAccessor#setDatabaseProductName * @see SQLErrorCodeSQLExceptionTranslator#setDatabaseProductName * @see java.sql.DatabaseMetaData#getDatabaseProductName() */
public void setDatabaseProductName(String dbName) { if (!shouldIgnoreXml) { this.exceptionTranslator = new SQLErrorCodeSQLExceptionTranslator(dbName); } }
Set the exception translator for this instance.

If no custom translator is provided, a default SQLErrorCodeSQLExceptionTranslator is used which examines the SQLException's vendor-specific error code.

See Also:
/** * Set the exception translator for this instance. * <p>If no custom translator is provided, a default * {@link SQLErrorCodeSQLExceptionTranslator} is used * which examines the SQLException's vendor-specific error code. * @see JdbcAccessor#setExceptionTranslator * @see org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator */
public void setExceptionTranslator(SQLExceptionTranslator exceptionTranslator) { this.exceptionTranslator = exceptionTranslator; }
Return the exception translator for this instance.

Creates a default SQLErrorCodeSQLExceptionTranslator for the specified DataSource if none set.

See Also:
/** * Return the exception translator for this instance. * <p>Creates a default {@link SQLErrorCodeSQLExceptionTranslator} * for the specified DataSource if none set. * @see #getDataSource() */
public SQLExceptionTranslator getExceptionTranslator() { SQLExceptionTranslator exceptionTranslator = this.exceptionTranslator; if (exceptionTranslator != null) { return exceptionTranslator; } synchronized (this) { exceptionTranslator = this.exceptionTranslator; if (exceptionTranslator == null) { if (shouldIgnoreXml) { exceptionTranslator = new SQLExceptionSubclassTranslator(); } else { exceptionTranslator = new SQLErrorCodeSQLExceptionTranslator(obtainDataSource()); } this.exceptionTranslator = exceptionTranslator; } return exceptionTranslator; } }
Set whether to lazily initialize the SQLExceptionTranslator for this transaction manager, on first encounter of an SQLException. Default is "true"; can be switched to "false" for initialization on startup.

Early initialization just applies if afterPropertiesSet() is called.

See Also:
/** * Set whether to lazily initialize the SQLExceptionTranslator for this transaction manager, * on first encounter of an SQLException. Default is "true"; can be switched to * "false" for initialization on startup. * <p>Early initialization just applies if {@code afterPropertiesSet()} is called. * @see #getExceptionTranslator() * @see #afterPropertiesSet() */
public void setLazyInit(boolean lazyInit) { this.lazyInit = lazyInit; }
Return whether to lazily initialize the SQLExceptionTranslator for this transaction manager.
See Also:
  • getExceptionTranslator()
/** * Return whether to lazily initialize the SQLExceptionTranslator for this transaction manager. * @see #getExceptionTranslator() */
public boolean isLazyInit() { return this.lazyInit; }
Eagerly initialize the exception translator, if demanded, creating a default one for the specified DataSource if none set.
/** * Eagerly initialize the exception translator, if demanded, * creating a default one for the specified DataSource if none set. */
@Override public void afterPropertiesSet() { super.afterPropertiesSet(); if (!isLazyInit()) { getExceptionTranslator(); } }
This implementation attempts to use the SQLExceptionTranslator, falling back to a TransactionSystemException.
See Also:
/** * This implementation attempts to use the {@link SQLExceptionTranslator}, * falling back to a {@link org.springframework.transaction.TransactionSystemException}. * @see #getExceptionTranslator() * @see DataSourceTransactionManager#translateException */
@Override protected RuntimeException translateException(String task, SQLException ex) { DataAccessException dae = getExceptionTranslator().translate(task, null, ex); if (dae != null) { return dae; } return super.translateException(task, ex); } }