Does XML SQL Utility commit after it is done inserting, deleting, or updating? What happens if an error occurs?
By default the XSU executes a number of insert, delete, or update statements at a time. The number of statements batch together and executed at the same time can be overridden using the setBatchSize feature. Also, by default XSU does no explicit commits. If autocommit is on (default for the JDBC connection), then after each batch of statement executions a commit occurs. You can override this by turning autocommit off and then specifying after how many statement executions a commit should occur, which can be done using the setCommitBatch feature. If an error occurs, XSU rolls back to either the state the target table was in before the particular call to XSU, or the state right after the last commit made during the current call to XSU.
