Re: unable to see new/updated records
From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Fri, 4 Dec 2009 00:42:18 -0800 (PST)
Message-ID: <6b53089d-ddcf-402f-9067-1519ac506b4e_at_v25g2000yqk.googlegroups.com>
On Dec 1, 12:46 am, Arkadiy <vertl..._at_gmail.com> wrote:
> 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
Date: Fri, 4 Dec 2009 00:42:18 -0800 (PST)
Message-ID: <6b53089d-ddcf-402f-9067-1519ac506b4e_at_v25g2000yqk.googlegroups.com>
On Dec 1, 12:46 am, Arkadiy <vertl..._at_gmail.com> wrote:
> 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
Are there indeed new records introduced (committed) since last query? Does this very same query return results when executed outside of your app? What's Oracle version (both server and client?) If you're on 11g, this might be something related to OCI Client Result Cache feature introduced in 11.1. It is said to be completely transparent to applications and should handle data set changes automatically, but this might not always be true due to defects in implementation...
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Fri Dec 04 2009 - 02:42:18 CST