[jira] [Created] (CAY-1896) Flattened attributes don't work with optimistic locking on

["John Huss (JIRA)" <ji...@apache.org>]

John Huss created CAY-1896:
------------------------------

             Summary: Flattened attributes don't work with optimistic locking on
                 Key: CAY-1896
                 URL: https://issues.apache.org/jira/browse/CAY-1896
             Project: Cayenne
          Issue Type: Bug
          Components: Core Library
    Affects Versions: 3.2M1
            Reporter: John Huss
         Attachments: cayenne-mvn-snippet.zip

Flattened attributes can not be modified and saved with if you have optimistic locking turned on for a to-one relationship in the same entity with the flattened attribute.  

For example, say you have Artist and Painting and a flattened attribute "artistName" on Painting and you set this to a new value.  And you also have optimistic locking on the Painting.artist relationship.  It tries to generate SQL for the flattened object (Artist) that includes the to-one relationship foreign key from the source object (Painting) and fails because the column is not found:

UPDATE ARTIST SET NAME = ? WHERE ID IS NULL AND ARTIST_ID = ?
Column 'ARTIST_ID' is either not in any table in the FROM list...

A minimal example is attached.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)