hibernate update problem

fangEve · **Joined:** Sat Mar 03, 2007 5:32 am **Posts:** 20

i tried to update my record using customize HQL. but i have encounter some problem.

My code is as follow:

Code:

           
 String sql="update Enquiry enq SET enq.threadStatus= :threadStatus where enq.id= :threadId";            
            Query query=session.createQuery(sql);
            query.setInteger("threadStatus",2);
            query.setInteger("threadId", Integer.parseInt(threadId));
            int result=query.executeUpate();

from my console my sql look like this:
update COLLAB_THREAD enquiry0_ set enquiry0_.THREAD_STATUS=? where (enquiry0_.ID=?)

my error is as follow:
Incorrect syntax near 'enquiry0_'.
org.hibernate.exception.SQLGrammarException: could not execute update query

please help. thanks.

batmat · **Posted:** Fri Mar 23, 2007 8:03 am

Did you try executing the query inside your favorite sql client to know which enquiry0_ is wrong? (Since it's present three times in the generated SQL).

fangEve · **Joined:** Sat Mar 03, 2007 5:32 am **Posts:** 20

but i though the enquiry_0, is just the alias to represent the table name.?

batmat · **Posted:** Sun Mar 25, 2007 7:37 am

Yes, that's it. But, it seems like your dbms doesn't like this somewhere, so you should try and know which part of the query is rejected.

Maybe also, about this part of the query:

Quote:

Code:

query.setInteger("threadId", Integer.parseInt(threadId));

Try and debug what Integer.parseInt() returns... I don't think this is the problem, but check it out anyway...