Hi All,

I tried one Hibernate update query like this.
function() {
Bean b = new Bean();

b.setName("Name");
b.setDesc("Desc");
b.setStatus("A");
b.setID(107);
getHibernateTemplate().update(b);
return null;
}

In this case, one update query is generated which is having its primary key i.e. Id of the table in where condition.
Now I want name and status in where condition and on the basis of these I want to update desc.

Can AnyOne help me for this problem ?

Thanks,
Gopal

Hi Gopal, is the following of any help?

http://www.hibernate.org/hib_docs/v3/re ... tch-direct

-- Dan

Hi,

I know this method and This is working fine when I am using this upto Spring Layer (Main Method). But When I am using the same thing in trinidad (For view Layer). I am getting following error.

org.springframework.orm.hibernate3.HibernateQueryException: query must begin with SELECT or FROM: UPDATE [UPDATE com.persistence.Bean SET name = :name WHERE ID = :Id]; nested exception is org.hibernate.QueryException: query must begin with SELECT or FROM: UPDATE [UPDATE com.persistence.Bean SET name = :name WHERE ID = :Id]

The method I mentioned in my first post is working fine for that. But by using same method I am having that issue.
Can you resolve that issue ?

Thanks,
Gopal