cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Huss (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CAY-1896) Flattened attributes don't work with optimistic locking on
Date Fri, 31 Jan 2014 23:18:19 GMT

     [ https://issues.apache.org/jira/browse/CAY-1896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

John Huss updated CAY-1896:
---------------------------

    Attachment:     (was: cayenne-mvn-snippet.zip)

> 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: 0001-Fix-flattened-attributes.patch
>
>
> 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)

Mime
View raw message