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