|Subject||Re: Inconsistent read / writes|
> "I get a connection and starts reading a record from it,periodically,
> but always on the same connection. If I change that record fromisql,
> nothing happens, I still get the previous value for that record.I've
> also tried IBConsole but that did not help either. The interestingI think this is what you could call standard behaviour and is related
> thing I tried QuickDesk and If I change the record with that, then I
> get the new value in the java program. I tried also with FIBPlus in
> Delphi (QuickDesk also uses FIBPlus) but the java still shows the
> previous value."
to the the transaction model. Basically a snopshot of the DB is taken
when the transaction is created and only changes within the current
transaction will be reflected. This becomes a problem when you have a
single connection doing a lot of reads as it never gets refreshed.
The easiest solution to this is to get a new transaction by either
calling commit or release (i think commit is slightly more efficient
provided you are only doing selects).
Hope this helps