Connections for event-hook procedures

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_com_error

  • sp_hook_dbmlsync_download_fatal_sql_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.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1