Session doesn't fetch the latest data from table after using nativequery to update the table. Can see the data being
updated after using the native query. But after that I've used the namedquery to fetch the data from table. It doesn't
refresh from database. Instead it always returns the existing object in session.

I have a scenario where in the table there are 20 records and 2500 concurrent users/threads are hitting the db and trying to update those 20 records.
No new inserts. Due to this we were having locking problems with the table. Table just tracks the user responses in

I've planned to batch the updates and send them in a batch. I've used createNativeQuery to update the table.
Had to use the native query to update the db counts.

1) String sql = "UPDATE TEST SET NEG_COUNT = NEG_COUNT + ?1, POS_COUNT = POS_COUNT + ?2 WHERE ID = ?3";
Query query = session.createNativeQuery(sql);
query.setParameter(1, 1);
query.setParameter(2, 1);
query.setParameter(3, 1);
query.setFlushMode(FlushModeType.COMMIT);
int rows = query.executeUpdate(); // updates the db

2) Query query = session.createQuery("from TEST where id in (:id)");

Step does not reflect the latest data that was updated in step1.

Any ideas?
Thanks

This is expected and documented in http://docs.jboss.org/hibernate/stable/ ... tch-direct



The possible solutions are:

* Call session.evict() before the second query
* Call session.evict(entity) before the second query
* Use session.refresh(entity) which has been designed with this use case in mind:

Thanks for the reply.
I was using JPA's Entitymanager and not the hibernate session. But using Hibernate's JPA implementation.
Entitymanager does not have evict().

Thanks
Krish