Hi

I am using Hibernate 2.1. I need to do a simple update to multiple rows in 'Users' table. The equivalent SQL looks like:

update users set status=1 where users_id in (1, 2, 3, 5, 6, 7);

I am hesitating to fetch Users object, modify and then save to do one simpl eupdate. Can someone tell me how to do it ?

At the moment, I am trying out following code:
Session session = HibernateUtil.getSession();
HibernateUtil.beginTransaction();
Query query = session.createQuery("update User set row_status_id = 1 where users_id in :usersList");
query.setParameter("usersList", "1, 2, 3, 5, 6, 7");
HibernateUtil.commitTransaction();
------

Please let me know if this needs any correction or alternate way.

Thanks
Ron

Hi,

Just a tought

Wouldn't it be easier for you just to take the connection and issue a SQL statement into it? If you're not using hibernate's ability to map data to objects, you might as well go directly through the JDBC connection and update your tables..

getSession().connection().createStatement() ...

I think it would be easier for you.


Good luck,
Vincent Giguere

I am using HIbernate's ability of persisting objects as much as I can. But I just think it is silly to fetch all required objects first then modify and then save them as it will end up into many database trips whereas we just need one update statement in one trip.

Thanks
Ron

I understand.

What about using getSession().connection().createStatement() ...

Did it work for you?

Instead of creating Statement from connection, I am just fetching all objects, modifying and calling update.

Thanks for your help

It seems that I can't experiment batch updates using the Eclipse plugin's HQL scatchpad. If I try I get . That's a pity, is there a workaround available?

not at the moment - add a jira request for it.