hi,

We have an issue with our application where one SQL statement fired from application getting stale value from DB (Oracle11G 11.2.0.4). The SQL comes out from create SQL statement. The output of the query fired from application is different from the same SQL executed from sqlplus. Confirmed not a transaction issue, since the value is commited in DB for sure.

It returns D-1 data.

select * from ( SELECT TRAN.* FROM ADS_USER.TRANSACTION TRAN, ADS_USER.SETUP_X_EVENT AREV WHERE TRAN.TXN_ID = AREV.TXN_ID AND AREV.AR_ID = 9395 ORDER BY TRAN.TXN_VALUE_DT DESC, TRAN.TXN_TS DESC ) where rownum <= 1

More points:
1. Hibernate caching is off.
hbm.cacheProvider org.hibernate.cache.NoCacheProvider
2. Version used is Hibernate 3.3.2.GA
3. Issue happened on 7th March and then again on 8th April. We are not sure whether this will happen again on 09th may.
4. On a given day when the issue happen at some intervals the results from SQL is correct and then suddenly it goes and get the stale value.
5. The same query runs every 5 mins against DB

Is there any know issue with Hibernate? Or anyknow know of a similar problem where the issue might be in Oracle?