MobiLink Synchronization Reference
  Synchronization Events

begin_connection_autocommit connection event

Function 

Turns on autocommit.

Parameters 

None.

Default action 

Autocommit is off.

Description 

When the MobiLink synchronization server connects to the consolidated database, it turns off autocommit so that it can roll back the upload and download streams if an error occurs.

However, if you are using an Adaptive Server Enterprise consolidated database, you cannot perform DDL functions such as creating temporary tables unless autocommit is on. If you are using an Adaptive Server Enterprise consolidated database, run your DDL commands in the begin_connection_autocommit event. When the event is finished, autocommit is turned off.

Begin_connection_autocommit scripts must be written so that they are repeatable. This is because if an error or deadlock occurs, the MobiLink synchronization server needs to be able to retry the script (since it can't roll it back).