[hibernate-issues] [Hibernate-JIRA] Updated: (EJB-265) Incorrect SQL generated for JPA QL Update statement involving multiple entities

[Alex Savitsky (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/EJB-265?page=all ]

Alex Savitsky updated EJB-265:
------------------------------

    Attachment: Branch.java
                Visit.java
                Issue.java

Entity files that generate the described error. The query with error is defined in Issue.java as a named query

> Incorrect SQL generated for JPA QL Update statement involving multiple entities
> -------------------------------------------------------------------------------
>
>          Key: EJB-265
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-265
>      Project: Hibernate Entity Manager
>         Type: Bug

>     Versions: 3.2.1
>  Environment: Hibernate 3.2.2 GA, Oracle 9i
>     Reporter: Alex Savitsky
>  Attachments: Branch.java, Issue.java, PersistentEntity.java, Visit.java
>
>
> When generating SQL for statements like this: UPDATE Issue i SET i.dueDate = i.dueDate + 10 WHERE i.visit.branch.id = :branchId, an extra comma is generated at the end of table list: update Issue,  set DUE_DATE=DUE_DATE+10 where BRANCH_ID=?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira