[jira] Created: (TUSCANY-233) Case sensitivity DAS config file

[Rick Rineholt (JIRA)]

Case sensitivity   DAS config file
----------------------------------

         Key: TUSCANY-233
         URL: http://issues.apache.org/jira/browse/TUSCANY-233
     Project: Tuscany
        Type: Improvement

  Components: Java DAS RDB  
    Reporter: Rick Rineholt


It appears that databases and SQL  tend to by default ignore case by converting 
table names and columns by default to upper case.  DAS code seems to be 
sensitive to case making it necessary to uppercase all database artifacts in 
the config file. It would be more natural if DAS config file if by default 
followed this same behavior.  I believe when case sensitivity is required the 
artifacts are quoted, maybe DAS config should follow this   (ie  Column 
name="Date"  is uppercased then compared so it matches tables created by 
default to "DATE" "date" etc but ""Date&quot'" matches only "Date"
Makes it possilbe to have the same behavior as SQL ease of use 90% not worrying 
about case but case can be made significant.
For reference see :
"Case sensitivity and object names" in
http://www-128.ibm.com/developerworks/db2/library/techarticle/0203adamache/0203adamache.html

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira