sqlCommitControl

When you generate Java™ code, the sqlCommitControl build descriptor option allows generation of a Java runtime property that specifies whether a commit occurs after every change to the default database. Regardless of the value of this build descriptor option, EGL commits the changes to the database at the end of each run unit.

The vgj.jdbc.default.database.commitControl property is generated only if the genProperties build descriptor option is also set to PROGRAM or GLOBAL. You can set the Java runtime property at deployment time regardless of your decision at generation time.

Values

NOAUTOCOMMIT (the default)
EGL does not automatically commit changes to the database. You can commit the changes manually with the sysLib.commit() system function, or you can reverse the changes with sysLib.rollback().

For details on the rules of commit and rollback in this case, see the topic "Logical unit of work" in the EGL Language Reference.

AUTOCOMMIT
After each successful change to the database, EGL commits the change automatically. This behavior is consistent with previous versions of the Informix® product I4GL.
NOCOMMIT
EGL does not commit changes to the database. The sysLib.commit() and sysLib.rollback() system functions have no effect on the database. NOCOMMIT is appropriate for databases that do not support transactions and for programs running within a transaction defined outside of EGL.

Feedback