|Subject||Re: Inconsistent read / writes|
> > "I get a connection and starts reading a record from it,then I
> > but always on the same connection. If I change that record from
> > nothing happens, I still get the previous value for that record.
> > also tried IBConsole but that did not help either. The interesting
> > thing I tried QuickDesk and If I change the record with that,
> > get the new value in the java program. I tried also with FIBPlusin
> > Delphi (QuickDesk also uses FIBPlus) but the java still shows therelated
> > previous value."
> I think this is what you could call standard behaviour and is
> to the the transaction model. Basically a snopshot of the DB istaken
> when the transaction is created and only changes within the currenta
> transaction will be reflected. This becomes a problem when you have
> single connection doing a lot of reads as it never gets refreshed.efficient
> The easiest solution to this is to get a new transaction by either
> calling commit or release (i think commit is slightly more
> provided you are only doing selects).From what I understand, apparently a transaction is created then when
> Hope this helps
I call "getConnection()" (using Interclient) and that transaction is
not released until I destroy that Java connection? Wouldn't it be
more correct if the transaction was created on calling the
createStatement() or executeQuery(..) functions?
Natal Vande Casteele