Subject Re: [ib-support] Survival of Prepared state was Re: just if you are curious
Author Kenneth Foo

The original question was indeed about persisting a preparedstatement for
in another transaction.

I'm really just wondering if there are any ways to avoid recompiling the SQL
of prepared statements into BLR over and over again (since it's going to be
same for every call that I make). Or if FB already does some kind of
caching of
these BLRs from the given SQL string?

Does the SQL->BLR compilation take up much processing power?


----- Original Message -----
From: "Phil Shrimpton" <phil@...>
To: <>
Sent: Monday, February 24, 2003 3:57 PM
Subject: Re: [ib-support] Survival of Prepared state was Re: just if you are

> On Sunday 23 February 2003 14:38, you wrote:
> Hi,
> > > > If I understand correctly, the JayBird driver doesn't allow prepared
> > > > statements to persist beyond a commited transaction.
> >
> > >No 'component' set allows this, as FB does not allow this. Basically,
> > >everything in FB is only valid within the context of a transaction,
> >
> > Indeed FB does allow this. Commit with retain (implemented in Delphi
> > components as CommitRetaining) opens a new transaction after committing,
> > using the same transaction context as the one just committed.
> You are of course correct (as always). I did not consider
> because I was assumuing the question was about 'persisting prepared
> statements after a commit, to be used later with another transaction, and
> xxxRetaining basically 'restarts' the same transaction immediatly on
> > Does the Jaybird driver not support CommitRetaining?
> Its not in the JDBC specs, so if it does, it may be buried.
> > Maybe statement handles are not as tightly bound to transactions as you
> > suppose.
> It has always been my understanding that resultsets, statement handles
> are only valid in the context of the 'current' transaction', and when the
> transaction ends, the result sets, statements etc. become invaild. I am
> my understand of resultsets becomming invalid is correct, but maybe my
> understanding of statment handles is incorrect.
> Phil
> --
> Linux 2.4.4-4GB
> 7:22am up 41 days, 13:11, 1 user, load average: 0.56, 0.23, 0.08
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to