[jira] Created: (IBATIS-563) failed batch operations can lead to jdbc driver sequence errors

["Alan Charley (JIRA)" <ib...@incubator.apache.org>]

failed batch operations can lead to jdbc driver sequence errors
---------------------------------------------------------------

                 Key: IBATIS-563
                 URL: https://issues.apache.org/jira/browse/IBATIS-563
             Project: iBatis for Java
          Issue Type: Bug
          Components: SQL Maps
    Affects Versions: 2.3.4
         Environment: Hp NonStop H06.14 , NonStop Java 1.5.0_02  Ibatis build 2.3.4.726

            Reporter: Alan Charley


Upon failure of a batched SQL statement the driver will report  "function_sequence_error" on the next attempt to use the statement. This because statement is being cached and is marked as being part of a batch operation.  Before closing the statement the batch operation should be cleared.  See code snippet below from SqlExecutor.java


    public void cleanupBatch(SessionScope sessionScope) {
      for (int i = 0, n = statementList.size(); i < n; i++) {
        PreparedStatement ps = (PreparedStatement) statementList.get(i);
  
      /* code added by ajc follows */
        if (ps != null) {
           try {	
            ps.clearBatch();	
           } catch (SQLException e) {
               // ignore
           }
        }
        /* end of code by ajc */
 
        closeStatement(sessionScope, ps);
      }
      currentSql = null;
      statementList.clear();
      batchResultList.clear();
      size = 0;
    }
  }

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.