Hi,

I have read few post in the forum related to this issue, but I still have some questions.

I know very well that Hibernate is orm so it's not designed to run updates on multiple rows. but there is a situation when it can be useful.

sometimes I need to change a flag on several rows, not 10,20 but 500 or 1000 rows. And here sql is the winner to do the tast as I can write something like

update data set flag = 'x' where flag = 'z'

My guess is to get the statement from the session and issue an sql on the db. but my concern is what happends with the session and secondary cache. how ehcache will realize that I updated 1000 records in the background

is there a way to do this the best possible way with hibernate ??

Thanks for any suggestions!!!

Istvano

Hibernate version:
2.8

See the blog for a commentary on Batching
http://blog.hibernate.org/cgi-bin/blosxom.cgi/index.html?find=batch&plugin=find&path=

Also H3 supports batch updates (and deletes) natively in HQL so an updates as you have shown can be performed directly.

Hi

Consider If i have to insert 1000 records then 1000 insert queries would be executed.

Can i do it in a Single Query?

And my Other Question is How do it handle the Connection here. If i go on inserting 1000 records will my connection pool get exhausted.

Consider i open the connection in the Constructor and close the connection in the finally block in all the methods. If that is the case i wont be able to close the connection and my connection pool will get exhausted.

Thanks for the reply, it was quite helpfull. for the moment I have to stay with hb2.8 so I will do the scroll stuff.

Thanks

Istvano