Each event-hook procedure is executed on the same connection as the synchronization itself. The following are exceptions:
sp_hook_dbmlsync_all_error
sp_hook_dbmlsync_communication_error
sp_hook_dbmlsync_download_log_ri_violation
sp_hook_dbmlsync_misc_error
sp_hook_dbmlsync_sql_error
These procedures are called before a synchronization fails. On failure, synchronization actions are rolled back. By executing on a separate connection, you can use these procedures to log information about the failure, without the logging actions being rolled back along with the synchronization actions.
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |