Updating with Hibernate - please for urgent help

herbatniczek · **Joined:** Tue Nov 22, 2005 6:55 am **Posts:** 41

I have a simple code:

Code:

int updatedEntities = getHibernateTemplate().executeFind(new HibernateCallback() {

             public Object doInHibernate(Session session) throws HibernateException {

                return session.createQuery(
                        "UPDATE CustomerActionModel customerAction " +
                        "set customer = (select Customer  customer where " +
                        "customer.customerId = customerAction.customerId) where customerAction.userTask.objecId = ?")
                        .setLong(0,userTask.getObjectId().longValue()).executeUpdate();
                        
             }
         });

The method executeUpdate() is undefined for the type Query...

If put list() here it works (ofcourse if i remove updatedEntities)

But i would like to have an info if any of rows have been updated...
The int value would be mostly appreciated

steckemetz · **Posted:** Tue Jan 10, 2006 12:11 pm

Hi,

executeUpdate should work.
What version of hibernate do you use?
Mapping files ?

herbatniczek · **Joined:** Tue Nov 22, 2005 6:55 am **Posts:** 41

version 2.x

herbatniczek · **Joined:** Tue Nov 22, 2005 6:55 am **Posts:** 41

version of jar is 2.1.6

if it's not apprpriate, could u show me how to update ?

I haven't found sollution yet

The hql query should be as I show above and I would like to know if the update was successful or not.

steckemetz · **Posted:** Fri Jan 20, 2006 4:16 am

Hi,

can you simplify the update and see what happens ?
like

Code:

"UPDATE CustomerActionModel customerAction " +
                        "set customer = 1 where customerAction.userTask.objecId = ?"

or

Code:

"UPDATE CustomerActionModel customerAction " +
                        "set customer = (select Customer  customer where " +
                        "customer.customerId = customerAction.customerId)"