You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tuscany.apache.org by "Jean-Sebastien Delfino (JIRA)" <tu...@ws.apache.org> on 2006/05/11 10:55:08 UTC
[jira] Updated: (TUSCANY-233) Case sensitivity DAS config file
[ 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