Skip to main content

Avoid COMMIT/ROLLBACK calls in database objects

Usually, the control of the transaction should be handled by the its "owner". If the transaction was started by some Java code, the commit and rollback of this should be done in the Java code.

So, in this situation, calling a COMMIT or ROLLBACK from a database object is a bad pratice and should be avoided.

This rule ignores procedures and functions with PRAGMA AUTONOMOUS_TRANSACTION.