Subject Re: [IBO] Default Transaction Active
Author Helen Borrie
At 07:11 AM 25/05/2004 +0000, you wrote:
>I have been using the Status Monitor that comes with IBO to see if I
>get every transaction commit.....
>Now I some situations I can see that MyDatabase.
>(TIB_TransactionInternal) is active eventhough no statements are
>listed under it (No Query, Cursors etc).
>I have some other transactions in my appl. and I can follow the state
>of each of those, and see which statements are attached to this
>Should I do anything further to find out, why the default
>transactions is active (as I assume its the default transaction) ?

It is *a* default transaction. It's the one IBO (through the API) creates
for the connection. You are not supposed to do anything with/to/about
it. It doesn't command any user objects - user transactions are for that
(either explicit ones you drop in or the DefaultTransaction). The
DefaultTransaction is not the same one as the internal transaction. It
will be created and started by IBO any time it needs one for a user
operation and no transaction has been assigned.