Update several Columns in one Hibernate Query?

hibernate nhibernate hql
Paks picture Paks · Sep 6, 2012 · Viewed 35.4k times · Source

i have the Following HQL:

String hql = "UPDATE Buchung as b " +
             "set STORNO = :Storno " +
             "where ID = :BuchungID";

Is it possible to Update more then one column in a HQL? For Example:

String hql = "UPDATE Buchung as b " +
              "set STORNO = :Storno " +
              "set NAME = :Name " +
               ......  
              "where ID = :BuchungID";

I know how to do that in MSSQL but i dont know how to do that in Hibernate.

Answer

Miroslav Popovic picture Miroslav Popovic · Sep 6, 2012

HQL is no different than SQL in this case. Just use comma to separate columns:

String hql = "UPDATE Buchung as b set " +
          "STORNO = :Storno," +
          "NAME = :Name " +
           ......  
          "where ID = :BuchungID";

Related questions

Using a CASE statement in HQL select

Is there any way to do the following in HQL: SELECT case when flag = true then SUM(col1) else SUM(col2) FROM myTable

Read More
Using a join in a Hibernate HQL update query

i have the following hibernate mapping: <class name="Domain.Roomreservation, Core" table="Reservationroom"> <id name="ID" unsaved-value="undefined"> <generator class="native"> <!--<param name="sequence">GLOBALSEQUENCE</param>--> &…

Read More
IFNULL equivalent in Hibernate Query Language?

I'm trying to write an HQL query which will calculate an average rating for an item. I want the query to return 0 instead of null when there are no rating for a given item - so that I can use …

Read More