Dear all

I dont know is this the place to ask this question. I tried the CreateQuery() function and named query option and all, but it failed.


can Anybody help me saying how to execute the query
"UPDATE category SET lft = lft + 2 WHERE lft >2"


ofcourse I dont want to select all the entries and execute one by one,
I am looking for a single executeUpdate()

thanks and regards
boolee

Hibernate version:3




Name and version of the database you are using:Mysql 3.x

"it failed" is not a sufficient description of your problem.

sorry.. i was thinking that somebody might post a codesample for that.

Below is the code i used


it gave me an error

root0_0_, this_.name as name0_0_, this_.lft as lft0_0_, this_.rgt as rgt0_0_ from nested_category t
his_ where this_.rgt=? and this_.lft=? and this_.name=?
Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxError: expecting DOT, found '=' near lin
e 1, column 25 [update Category set lft = lft + 2 where lft >2 ]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:74)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:214)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
................................................

can anyone pls give me a code sample for executing the query

thanks
boolee

I tried the modified query



it gave the error



the mysql query details produced is