Java returning stale data from oracle
NickName:user1602187 Ask DateTime:2013-03-15T09:02:27

Java returning stale data from oracle

I have a java web app that pulls data from an oracle database, and the other day I modified some rows of data using oracle sql developer.

Now the problem is Java keeps returning the old data as if it never changed, but if I run the exact same query in sql developer it returns the current (modified) data.

I don't have any caching enabled, I checked with OracleDataSource.getImplicitCachingEnabled() and OracleDataSource.getExplicitCachingEnabled() and both are false.

Is there some kind of cache built into Oracle itself that needs to be cleared ? I have been racking my brain over this for 2 days.

I tried starting/stopping and undeploying/redeploying the app with no change. I even tried restarting tomcat itself and that hasn't helped. Any suggestions ?

Copyright Notice：Content Author:「user1602187」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/15422959/java-returning-stale-data-from-oracle

Products recommended by Amazon
More >>>
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
 HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
 AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
 Timberland Men's 6-Inch Premium Waterproof Boot
Timberland Men's 6-Inch Premium Waterproof Boot
More about “Java returning stale data from oracle” related questions
Java returning stale data from oracle

I have a java web app that pulls data from an oracle database, and the other day I modified some rows of data using oracle sql developer. Now the problem is Java keeps returning the old data as if...

Show Detail
Java MYSQL/JDBC query is returning stale data from cached Connection

I've been searching Stackoverflow for an answer but can't seem to find one that doesn't involve Hibernate or some other database wrapper. I'm using JDBC directly via the MYSQL 5.18 JDBC driver in a

Show Detail
Oracle stale connection

Every once in a while in my app I get this error: ERROR 2015-04-09 08:30:13,724 [http-bio-8080-exec-2] mojo.jdbc.MojoAlertDataAccess: Invalid or Stale Connection found in the Connection Cache java...

Show Detail
HTTP Call Returning Stale Data

I'm building an application that retrieves data at a set interval from a website and I'm retrieving stale data. Specifically, I'm pulling scores from NFL games but whenever the score changes, my

Show Detail
Returning multiple ref cursors from Oracle procedure to Java

In our web application we have 18 screens in a module. Our user wants all the data of the 18 screens in one page so that they can print the entire data at once. So, I wrote an Oracle procedure which

Show Detail
Django view returning stale data, fixed after server restart

I have a Django webserver with a postgresql database. I have a view (Django REST framework) that is giving exhibiting strange behavior. The view lists the date of the most recent record in a table.

Show Detail
Is it possible to serve stale data from Redis by design?

I have a Java application that is responsible for serving up various (sometimes large) json responses to client applications. At the app layer, it uses Redis (AWS ElastiCache) to cache the json wit...

Show Detail
When is returning stale state acceptable?

I am looking at possible combinations of a consistency with replication factor with Cassandra. For this combination RF 2 Write CL ONE Read CL ONE R. Strickland in Cassandra High Availability say...

Show Detail
Oracle Java stored procedures returning data

I'm trying to write a Java stored procedure that could return a result. I've found this doc on Oracle website, but none of the examples provided return data http://docs.oracle.com/cd/B19306_01/java...

Show Detail
Activity Recognition returning stale activity

I am currently writing an app that uses the Google's Activity Recognition API, however in my onHandleIntent method when I put a break point in there to examine the intent being passed in from the s...

Show Detail