Hi all,
I want to update a row in a table.Like (sql)update table abc set x=2 where y=1.I want to know how to write this query in hybernate.
With regards,
gs

Hi,
I have the same problem.
Basically I want to update a particular row in the table.
Can some one give a small example on this.

The best start is here:

http://www.hibernate.org/hib_docs/v3/reference/en/html/

There is also a simple exmple
[url]
http://www.hibernate.org/hib_docs/v3/re ... eblog.html
[/url]

I think gs_1481 wants update some object property without full retrieve object from db like this "update Cat as cat set cat.owner = :newOwner where cat = :cat"

I think it will be very usefull feature.
But as i know there's only sql-update query and it's only in Hibernate 3.
And there isn't a feature to update single object property without object select.

there is dynamic-insert and dynamic-update wich sets only the needet properties.

So yes, you have to retrieve the object but the update is slim.

And then Hibernate3 allows true bulk-updates at least throug HQL.