sqlCommitControl

The build descriptor option sqlCommitControl allows generation of a Java™ runtime property that specifies whether a commit occurs after every change to the default database.

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

Valid values of sqlCommitControl are as follows:
NOAUTOCOMMIT
The commit is not automatic; the behavior is consistent with previous versions of EGL; and the Java runtime property is set to false, as is the default.

For details on the rules of commit and rollback in this case, see Logical unit of work.

AUTOCOMMIT
The commit is automatic; the behavior is consistent with previous versions of the Informix® product I4GL; and the Java runtime property is set to true.

Related concepts
Build descriptor options
Java runtime properties

Related reference
Build descriptor options
Default database
genProperties

Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.