The following rules apply:
If the access service is configured for long transactions, the SQL submitted must not be sensitive to a commit. For example, if the SQL is an insert statement that does not batch a commit into the statement, the insert rolls back using long transaction rules.
If the access service is configured for short transactions, the SQL submitted is bound by short transactions that supply a commit by default.
