Re: unable to see new/updated records

> 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/