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?

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3942182#3942182

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3942182


-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to