Committing or rolling back SQLJ transactions

If you disable autocommit for an SQLJ connection, you need to perform explicit commit or rollback operations. You do this using execution clauses that contain the SQL COMMIT or ROLLBACK statements.

Example

To commit a transaction in an SQLJ program, use a statement like this:

#sql [myConnCtx] {COMMIT};

To roll back a transaction in an SQLJ program, use a statement like this:

#sql [myConnCtx] {ROLLBACK};