Re: unable to see new/updated records
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Tue, 01 Dec 2009 18:29:27 +0100
Message-ID: <7nl23oF3dvrikU2_at_mid.individual.net>
On 11/30/2009 11:37 PM, Mladen Gogala wrote:
Date: Tue, 01 Dec 2009 18:29:27 +0100
Message-ID: <7nl23oF3dvrikU2_at_mid.individual.net>
On 11/30/2009 11:37 PM, Mladen Gogala wrote:
> Does your app issue something like "BEGIN TRANSACTION"? I've had a Java
> application that was doing that. The application was issuing the same
> query over and over again, WITHIN THE SAME TRANSACTION. Transaction is the
> basic unit of work in a RDBMS and there is something called "ACID rules".
> If your transaction is started at connect time, you're bound to see only
> the data that was committed at the time your transaction has begun.
> That's the law. Try removing that "begin transaction" statement or, if
> that's not possible, try putting in a "COMMIT" after each select.
Also make sure that the data you want to see is actually committed by whatever writes it to the DB.
Cheers
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Tue Dec 01 2009 - 11:29:27 CST