hibernate insert batch with postgresql

Question

is there a solution for batch insert via hibernate in partitioned postgresql table? currently i'm getting an error like this...

57286 [pool-1-thread-18] ERROR org.hibernate.jdbc.AbstractBatcher - Exception executing batch: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1 at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61) at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46) at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)....

i have found this link http://lists.jboss.org/pipermail/hibernate-dev/2007-October/002771.html but i can't find anywhere on the web is this problem solved or how it can be get around

Answer 1

You might want to try using a custom Batcher by setting the hibernate.jdbc.factory_class property. Making sure hibernate won't check the update count of batch operations might fix your problem, you can achieve that by making your custom Batcher extend the class BatchingBatcher, and then overriding the method doExecuteBatch(...) to look like:

    @Override
    protected void doExecuteBatch(PreparedStatement ps) throws SQLException, HibernateException {
     if ( batchSize == 0 ) {
      log.debug( "no batched statements to execute" );
     }
     else {
      if ( log.isDebugEnabled() ) {
       log.debug( "Executing batch size: " + batchSize );
      }

      try {
//     checkRowCounts( ps.executeBatch(), ps );
       ps.executeBatch();
      }
      catch (RuntimeException re) {
       log.error( "Exception executing batch: ", re );
       throw re;
      }
      finally {
       batchSize = 0;
      }

     }

    }

Note that the new method doesn't check the results of executing the prepared statements. Keep in mind that making this change might affect hibernate in some unexpected way (or maybe not).

Answer 2

thnx! it did the trick, no problems poped up, so far :)....one thing thou... i had to implement BatcherFactory class and put it int the persistence.xml file, like this:

property name="hibernate.jdbc.factory_class" value="path.to.my.batcher.factory.implementation" from that factory i've called my batcher implementation with the code above

ps hibernate core 3.2.6 GA

thanks once again

Answer 3

They say to use Two triggers in partitioned table or @SQLInset annotation Here : http://www.redhat.com/f/pdf/jbw/jmlodgenski_940_scaling_hibernate.pdf pages 21-26