Re: [Dbi-interbase-devel] DBD and Interbase functionality

[Chris W. <ch...@cw...>]

On Tue, 2002-04-30 at 16:02, Adam Clarke wrote:
> Chris, I think that you are being bitten by an issue that is described in
> the FAQ for the driver. See http://dbi.interbase.or.id/faq.html. In summary
> Interbase keeps track of transaction context in the database handle. With
> AutoCommit on (the default) the DBI behaviour is to call an implicit commit
> upon certain events, one of those being a final fetch from a statement
> handle. So your St1 hits it's final fetch and AutoCommit does it's thing but
> unfortunately for your example (because the transaction context is pegged o
> the dbh) this also commits St2 which hasn't done anything yet!

Ah, this makes sense. Thanks for the lucid explanation.

> I believe that my rejigged test code (not tested) will solve this problem in
> this simple case, however for other situations (like nested select
> statements) the best solution is to manage your own transactions or
> investigate the new ib_softcommit driver specific option.

The modified script should work, but only because it avoids the problem
-- which seems in this case the best solution :-)

AFAIK this only happens in one place, so I may see about modifying that
code.

Thanks much for the help.

Chris

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.