Deploying and Managing Apama Applications > Using the Apama Database Connector > The ADBC Event Application Programming Interface > Committing transactions
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.
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

action commitRequestFull(
string token,
dictionary<string, string> extraParams,
action<Connection, integer, string, string> callback) returns integer
Copyright © 2013 Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.