Begin a new database transaction. If rollbackOnly() is called, or if an exception propagates out of try, the transaction will be rolled back. Otherwise, the transaction will be committed.

Should be instantiated using try:

try (tx = sql.Transaction()) {
    //do work here
    if (something) {
        tx.rollbackOnly();
    }
}