Re: unable to see new/updated records
Date: Mon, 30 Nov 2009 14:14:54 -0800 (PST)
Message-ID: <537a2b79-6282-4f99-8178-3cf77cf2e47f_at_b15g2000yqd.googlegroups.com>
On Nov 30, 4:46 pm, Arkadiy <vertl..._at_gmail.com> wrote:
snip
> 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
Does the oracle database server still think your app is connected?
Is it possible that your app is generating an oracle error but you have exception handling somewhere that is ignoring the ( perhaps ) failed connection? Received on Mon Nov 30 2009 - 16:14:54 CST