executeUpdate problem- (bug?)

[armita]

Trying to execute this query:

Query query = em.createQuery(" update Activity " +
 " set startDate=:startDate, endDate=:endDate" +
 ", actualStartDate=:actualStartDate, actualEndDate=:actualEndDate " +
 "where tag=:tag and ne.code=:code ");

I am getting SQL error. The problem is Hibernate creates this Query:

 update Activity, set startDate=?, endDate=?, actualStartDate=?, actualEndDate=? where tag=? and code=?

and the "," after Activity makes MySQL confused and therefore could not understand the command.
Is it a bug or I am doing something wrong here?

[epbernard]

Are you *sure* there is no "," in your own code?

[armita]

I cut&pasted my code and the jboss log. Is it tested for MySQL?

[armita]

Help me please! I am stucked with this error! Does anybody tested this feature with MySQL?! Can anyone confirm this so I can fill a bug report

[jaikiran]

I am not sure why this simple query should run into this problem, but just try your luck with the following query:

Query query = em.createQuery("update Activity set startDate=:startDate, endDate=:endDate , actualStartDate=:actualStartDate, actualEndDate=:actualEndDate where tag=:tag and ne.code=:code ");

i.e. try out by specifying the entire query in a single string instead of appending the strings using a "+". Not at a logical solution that i am suggesting, but as i said, you can try your luck.

[epbernard]

I'm not able to reproduce (except that I don't know what 'ne' is).
If you can reproduce then write down a minimal test case and post it to JIRA.