Getting old values from database, even after update?

Question

I am using MySQL as DB, and Toplink essential as persistence layer.

There is a column, that I used to update regularly. But am always getting the value the value that was there at instance of START of the server.

But I restart the server, then only, its giving me the updated value.

What could be the problem?

using two windows; window 1 isn't committed. window 2 doesn't see uncommitted results of window 1? whereas window 1 can. — xQbert, Dec 17 '11 at 02:35
Are you making the updates outside of the application/TopLink? This could cause a caching issue depending on your settings. — Beau Grantham, Dec 17 '11 at 02:56
I tried both ways, 1 tried to test things using toplink and other by updating the value manually in DB. Both ways I am getting same result. — Ashish Agarwal, Dec 17 '11 at 03:04
how are you doing the update? Have you tried an insert or update statement right on the server? — Robert, Dec 17 '11 at 04:16

Ashish Agarwal · Accepted Answer · 2011-12-19T04:41:15.607

0

I was able to fix the problem by updating Persistence.xml, which allowed to disable any kind of Caching done by toplink.

<properties>
    <property name="toplink.cache.shared.default" value="false"/>
</properties>

edited Dec 19 '11 at 04:41

answered Dec 17 '11 at 04:57

Ashish Agarwal

1 Answers1