In situations where the direct use of the JDBC connection is not possible, transaction statements can be used to control a local transaction.
- START TRANSACTION- synonym for connection.setAutoCommit(false)
- COMMIT- synonym for connection.setAutoCommit(true)
- ROLLBACK- synonym for connection.rollback() and returning to auto commit mode.