SQLTemplate improvement
-----------------------
Key: CAY-800
URL: https://issues.apache.org/cayenne/browse/CAY-800
Project: Cayenne
Issue Type: Improvement
Components: Cayenne Core Library
Affects Versions: 3.0
Reporter: Andrus Adamchik
Assignee: Andrus Adamchik
Priority: Minor
Fix For: 3.0
"SELECT *" SQLTemplates sometimes mess up the capitalization of labels in a
returned DataRow, so it can't be converted to an object properly. Most users
would follow a naming convention for the table names (ALL_UPPERCASE or
all_lowercase). Unfortunately such mapping will not work consistemtly across
different databases and SELECT * queries. So what was suggested on the mailing
list [1] to address this problem (and avoid using #result workaround) is an API
to force capitalization of the result set labels.
I did a few preliminary tests, and this solution works extremely well.
[1] http://objectstyle.org/cayenne/lists/cayenne-user/2007/06/0044.html
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
