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.
This archive was generated by hypermail 2.0.0 : Fri Jun 08 2007 - 15:29:52 EDT