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:

> 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

Original text of this message