Hi,
I want update data in particular table for particular column in the database with Hibernate.
Can any one provide Hibernate Query for this.
My object is : NoticeSummary (It is having the property fields like transactionStatus, referenceNumberCds etc.,)
Iam creating like this:
Session s = HibernateSession.currentSession();
Query q = s.createQuery("FROM NoticeSummary n SET n.transactionStatus
= ? WHERE n.referenceNumberCds = ?");
But it is giving exception like
Caused by: net.sf.hibernate.QueryException: unexpected token: SET [FROM com.nextel.ebn.common.to.NoticeSummary n SET n.transactionStatus = ? WHERE n.referenceNumberCds = ?]
at net.sf.hibernate.hql.FromParser.token(FromParser.java:101)
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
Can any one help