Committing transactions
By default, the auto-commit behavior assumes the AutoCommit and StoreCommitInterval properties specified in the adapter's configuration file and the open action are using the default values. If you want more control over when changes are committed to a database, set the openDatabase action's autoCommit parameter to false and in your EPL code, manually commit data using the Connection event's commitRequest action.
To commit a transaction manually
1. Create a callback action to handle the results of the commitRequest action.
2. Call the commitRequest() action of the Connection event (for the open database) with the name of the callback action.
The definitions for the two forms of the commitRequest action are:
action commitRequest(
action<Connection, integer, string, string> callback) returns integer
and:
action commitRequestFull(
string token,
dictionary<string, string> extraParams,
action<Connection, integer, string, string> callback) returns integer