Hi everyone,

It's possible to execute such query :


There're lots of such report, so i can't select this reports and than update them in cycle.

I can do it getting sql prepare statement from Connection, but will there be any troubles with objects in cache ?

Thank's[/code]

You should definitely do this by using a native SQL query. You should manually flush the cache afterwards.

How can i do it ?

I mean how can i flush cache for some objects.
And createSQLQuery doesn't work. because it invokes "executeQuery", but when query is "update ...", you should invoke "execute".

Now i did such :
Connection conn = session.connection();
PreparedStatement ps = conn.prepareStatement("UPDATE report " +
" SET deleted = ? WHERE updated_time < ?");

oops - yes - createSQLQuery is for queries.

To refresh the session call session.refresh(Object yourobject)

Justin

.. which may prove cumbersome for you as you may have multiple objects and thus need to iterate over all the objects.
As far as I know, there isn't a method to bulk-kick all objects of a given class out of the session cache. Anyone else know of a method (besides closing the session)?

Justin

Not just closing session but also refreshing Ecache.

You can use session.clear() to clear the Session level cache, and SessionFactory.evictXXX() to clear the second level cache.