Deploying and Managing Apama Applications > Using the Apama Database Connector > The ADBCHelper Application Programming Interface > Committing database changes
Committing database changes
The default auto-commit behavior is driver auto commit, assuming 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 open action's autoCommit parameter to false and in your EPL code, manually commit data using one of the following DBUtil event actions in your EPL code:

action doSQLCommit()

action doSQLCommitAck( integer ackNum )
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.