Re: Row values changing back to old values randomly???

DG wrote:
> Hello everyone!
>
> Has anyone every seen the following behavior?
>
> Oracle 9.? running on AIX, no problems here Windows NT machine,
> Oracle client installed on the NT machine with ODBC driver v 9.2.0.2
>
> We have set up an ODBC source on the NT machine. An application (app
> server) opens a connection pool with e.g. 4 read connections and 4 write
> connections.
>
> An application changes e.g. two rows in two different tables and commits.
>
> The changed data is visible in TOAD from another machine.
>
> After about 2 minutes, the data is reverted back to old values without
> any activity from the app server whatsoever.
>
> How is this possible? Note, this is definitely not a bug in the app
> server code because the app runs without problems on 3 other Oracle
> database installations and on many many other installations using
> PostgreSQL, SQL Server and DB2. The app doesn't even know what the old
> row values were!
>
> Has anyone ever see something like this happening and how to solve it?
>
> Thank you and best regards,
>
> David

And what makes you think Oracle is the culprit here when you yourself say that the same code works OK in other Oracle installations.

I strongly suspect it's your App Server but to be sure... you can audit the tables in question and see who actually is doing the changes.

Regards
/Rauf Received on Fri May 27 2005 - 10:58:37 CDT