community.borland.com

Article #25332: How to programmatically rollback limbo transactions

Problem:
How do I programmatically rollback limbo transactions?

Solution:
Attach to the database
  use isc_database_info to get a list of all limbo transactions.
 
For each limbo
   isc_reconnect_transaction to attach to it.
   isc_rollback_transaction
 
Here is the function declaration for isc_reconnect_transaction from ibase.h
which is shipped with the InterBase kit.
 
ISC_STATUS  ISC_EXPORT isc_reconnect_transaction (
    ISC_STATUS ISC_FAR,
    isc_db_handle ISC_FAR *, 
    isc_tr_handle ISC_FAR *, 
    short, 
    char ISC_FAR *);

Last Modified: 17-OCT-00