[ http://issues.apache.org/jira/browse/TUSCANY-233?page=all ]
Jean-Sebastien Delfino updated TUSCANY-233:
-------------------------------------------
Fix Version: Java-Mx
Version: Java-Mx
> 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
> Versions: Java-Mx
> Reporter: Rick Rineholt
> Fix For: Java-Mx
>
> 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"'" 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
