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)
