You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@cayenne.apache.org by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org> on 2007/06/08 21:29:28 UTC

[JIRA] Created: (CAY-800) SQLTemplate improvement

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.