TransactionOperation.java

  1. /*
  2.  *
  3.  * The DbUnit Database Testing Framework
  4.  * Copyright (C)2002-2004, DbUnit.org
  5.  *
  6.  * This library is free software; you can redistribute it and/or
  7.  * modify it under the terms of the GNU Lesser General Public
  8.  * License as published by the Free Software Foundation; either
  9.  * version 2.1 of the License, or (at your option) any later version.
  10.  *
  11.  * This library is distributed in the hope that it will be useful,
  12.  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  13.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  14.  * Lesser General Public License for more details.
  15.  *
  16.  * You should have received a copy of the GNU Lesser General Public
  17.  * License along with this library; if not, write to the Free Software
  18.  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  19.  *
  20.  */

  21. package org.dbunit.operation;

  22. import org.slf4j.Logger;
  23. import org.slf4j.LoggerFactory;

  24. import org.dbunit.DatabaseUnitException;
  25. import org.dbunit.database.IDatabaseConnection;
  26. import org.dbunit.dataset.IDataSet;

  27. import java.sql.Connection;
  28. import java.sql.SQLException;

  29. /**
  30.  * Decorates an operation and executes within the context of a transaction.
  31.  *
  32.  * @author Manuel Laflamme
  33.  * @version $Revision$
  34.  * @since Feb 21, 2002
  35.  */
  36. public class TransactionOperation extends DatabaseOperation
  37. {

  38.     /**
  39.      * Logger for this class
  40.      */
  41.     private static final Logger logger = LoggerFactory.getLogger(TransactionOperation.class);

  42.     private final DatabaseOperation _operation;

  43.     /**
  44.      * Creates a TransactionOperation that decorates the specified operation.
  45.      */
  46.     public TransactionOperation(DatabaseOperation operation)
  47.     {
  48.         _operation = operation;
  49.     }

  50.     ////////////////////////////////////////////////////////////////////////////
  51.     // DatabaseOperation class

  52.     public void execute(IDatabaseConnection connection, IDataSet dataSet)
  53.             throws DatabaseUnitException, SQLException
  54.     {
  55.         logger.debug("execute(connection={}, dataSet={}) - start", connection, dataSet);

  56.         IDatabaseConnection databaseConnection = connection;
  57.         Connection jdbcConnection = databaseConnection.getConnection();

  58.         if (jdbcConnection.getAutoCommit() == false)
  59.         {
  60.             throw new ExclusiveTransactionException();
  61.         }

  62.         jdbcConnection.setAutoCommit(false);
  63.         try
  64.         {
  65.             _operation.execute(databaseConnection, dataSet);
  66.             jdbcConnection.commit();
  67.         }
  68.         catch (DatabaseUnitException e)
  69.         {
  70.             jdbcConnection.rollback();
  71.             throw e;
  72.         }
  73.         catch (SQLException e)
  74.         {
  75.             jdbcConnection.rollback();
  76.             throw e;
  77.         }
  78.         catch (RuntimeException e)
  79.         {
  80.             jdbcConnection.rollback();
  81.             throw e;
  82.         }
  83.         finally
  84.         {
  85.             jdbcConnection.setAutoCommit(true);
  86.         }
  87.     }
  88. }