[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: TestCase.zip
                application.properties

Complete test case, as an Eclipse Java project. Oracle JDBC Driver is not included. application.properties need to be placed in src folder, and DB connection info need to be specified in it. 

> 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, TestCase.zip, Visit.java, application.properties
>
>
> 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