unable to see new/updated records

From: Arkadiy <vertleyb_at_gmail.com>
Date: Mon, 30 Nov 2009 13:46:40 -0800 (PST)
Message-ID: <74f01afc-76b8-4370-9540-b72237eb59a0_at_d21g2000yqn.googlegroups.com>

Hi all,

I am trying to figure out what could cause the following issue.

Our app holds an OCCI connection, using it to obtain new/updated records from a table using their timestamps. It runs the select query once every 30 min for unlimited period of time (I do realize this is not the best way of doing this. The new version will reconnect on every cycle) .

We just noticed that the app stopped seeing the new records (the SELECT returns nothing). Otherwise everything looks fine.

Could this be because the connection object eventually gets into a wrong state?

Thanks for any help,

Arkadiy Received on Mon Nov 30 2009 - 15:46:40 CST

Original text of this message