Subject RE: [firebird-support] How to Terminate a Firebird Transaction
Author Alan McDonald
> Hello.
> I started a firebird process (using some Coldfusion code) without
> knowing that it would take about a week or more to complete it. Is it
> possible to terminate a process (or transaction) in firebird? If so,
> is this advisable, and how is it done?
>
> I'm running firebird in superserver mode on my local system (the
> server is not connected to the internet). I'm relatively new to
> Firebird.
>
> The ColdFusion code involves a long looping process in which several
> selects and updates occur during each iteration. It just occurred to
> me that maybe its the ColdFusion process I need to terminate and not
> the Firebird one. Would that be correct?
>
> Thanks,
> dbambo2000

terminating CF will do nothing. If the process is indeed going to take a
week to complete (hard to imagine - but still) you can just stop the server
using the server manager.
If you are worried about the data, you will need to backup/restore the
database, otherwise I doubt anything will be untoward.
maybe tell us what te process was doing exactly
Alan