sagili mohan

Greenhorn
+ Follow
since Jul 12, 2005
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by sagili mohan

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