John Huss created CAY-1986:
------------------------------
Summary: SQLTemplate returning DataObjects fails on PK column case mismatch
Key: CAY-1986
URL: https://issues.apache.org/jira/browse/CAY-1986
Project: Cayenne
Issue Type: Bug
Components: Core Library
Affects Versions: 4.0.M2
Environment: trunk
Reporter: John Huss
Priority: Minor
If you create an SQLTemplate query that returns real DataObjects (say Artist objects) and
use a query like "select * from Artist limit 1" and have the primary key column defined in
the DataMap with mixed case (like artist_ID) that doesn't match what the database returns
for the column name, the result will contain nulls instead of objects.
Strangely the case of the other columns does not seem to matter, only the primary key column.
You can workaround it by naming the column all upper or lower case and configuring the SQLTemplate
to force upper or lower case column names to be returned. But I think it should just work
without needing to do this.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
|