Thanks, Ann

Not all what I wanted to hear, but about what I concluded from looking at
the code.

It looks like the new jdbc driver will have to rely completely on an
external transaction manager and won't be able to use the firebird multi-db
transaction management to pretend all-firebird multi db transactions are
local. (1) means I have to do some unpleasant db handle pooling/swapping.
Oh well.

Thanks again
david jencks

On 2001.05.22 15:37:55 -0400 Ann W. Harrison wrote:
> At 02:12 PM 5/22/2001 -0400, David Jencks wrote:
>
> >1. Is it possible to do work on the same transaction, in one db, through
> >more than one connection/dbhandle?
>
> No. There's a way to reattach to a transaction in limbo, but the
> reattach is limited to commit or rollback - no data actions allowed.
>
> >If not, how hard is this to implement?
>
> Probably hard.
>
> >2. Is it possible to add dbs to a transaction that is started but not
> yet
> >prepared?
>
> No, but the application can handle two separate transactions as if they
> were one, calling prepare on each, then, if that succeeds, commit on
> each.
>
> >( I know this is a little like read committed transaction
> >isolation, but the java xa stuff only supports adding resources one at a
> >time to a transaction, not all at once like isc_start_transaction and
> >isc_start_multiple). Again, if not, how hard is this to implement?
>
> Probably hard.
>
> >2.5 With a multi-db transaction, can you call commit on a different
> >connection/db handle than you started the transaction on?
>
> Only if you're reattaching to a limbo transaction.
>
> >3. Am I correct in thinking that isc_prepare_transaction2 will allow me
> to
> >store an externally generated xid for use in recovery?
>
> Yes.
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.
>
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>