How to execute this UPDATE SQL Statement to update multiple

niravparekh · **Joined:** Wed Dec 10, 2008 2:14 pm **Posts:** 17

Hi,
I want to execute one update Statement using hibernate.

I have to execute this query.
"Update Table1 set column1 = 0 WHERE ID=2"

This statement updates more then one rows in Table1.

Can someone tell me what is the syntex to execute this statement?

Thanks in advance

wolli · **Posted:** Wed Jan 28, 2009 2:36 am

In 2.0 there should be a session.ExecuteUpdate() methode. I haven't used it yet, since I'm still on 1.2. If you also use a version before 2.0 you have to build your own IDbCommand (session.Connection.CreateCommand()).

niravparekh · **Joined:** Wed Dec 10, 2008 2:14 pm **Posts:** 17

Thanks for your reply,
But is it possible to post an example how to achieve this ?

I am looking for some example to do like this/

TigerShark · **Joined:** Wed Feb 20, 2008 10:45 am **Posts:** 10

What version of NH are you using?

niravparekh · **Joined:** Wed Dec 10, 2008 2:14 pm **Posts:** 17

I am using 2.2