AutomaticPreparedBatchStatement.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.database.statement;

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

  24. import org.dbunit.dataset.datatype.DataType;
  25. import org.dbunit.dataset.datatype.TypeCastException;

  26. import java.sql.SQLException;

  27. /**
  28.  * @author Manuel Laflamme
  29.  * @since Jun 12, 2003
  30.  * @version $Revision$
  31.  */
  32. public class AutomaticPreparedBatchStatement implements IPreparedBatchStatement
  33. {

  34.     /**
  35.      * Logger for this class
  36.      */
  37.     private static final Logger logger = LoggerFactory.getLogger(AutomaticPreparedBatchStatement.class);

  38.     private final IPreparedBatchStatement _statement;
  39.     private int _batchCount = 0;
  40.     private int _threshold;
  41.     private int _result = 0;

  42.     public AutomaticPreparedBatchStatement(IPreparedBatchStatement statement, int threshold)
  43.     {
  44.         _statement = statement;
  45.         _threshold = threshold;
  46.     }

  47.     ////////////////////////////////////////////////////////////////////////////
  48.     // IPreparedBatchStatement interface

  49.     public void addValue(Object value, DataType dataType) throws TypeCastException,
  50.             SQLException
  51.     {
  52.         logger.debug("addValue(value={}, dataType={}) - start", value, dataType);

  53.         _statement.addValue(value, dataType);
  54.     }

  55.     public void addBatch() throws SQLException
  56.     {
  57.         logger.debug("addBatch() - start");

  58.         _statement.addBatch();
  59.         _batchCount++;

  60.         if (_batchCount % _threshold == 0)
  61.         {
  62.             _result += _statement.executeBatch();
  63.         }
  64.     }

  65.     public int executeBatch() throws SQLException
  66.     {
  67.         logger.debug("executeBatch() - start");

  68.         _result += _statement.executeBatch();
  69.         return _result;
  70.     }

  71.     public void clearBatch() throws SQLException
  72.     {
  73.         logger.debug("clearBatch() - start");

  74.         _statement.clearBatch();
  75.         _batchCount = 0;
  76.     }

  77.     public void close() throws SQLException
  78.     {
  79.         logger.debug("close() - start");

  80.         _statement.close();
  81.     }
  82. }