commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fabio Insaccanebbia (JIRA)" <j...@apache.org>
Subject [jira] Created: (DBUTILS-34) BasicRowProcessor loses any information on database field case
Date Fri, 01 Dec 2006 20:55:21 GMT
BasicRowProcessor loses any information on database field case
--------------------------------------------------------------

                 Key: DBUTILS-34
                 URL: http://issues.apache.org/jira/browse/DBUTILS-34
             Project: Commons DbUtils
          Issue Type: Improvement
    Affects Versions: 1.0
            Reporter: Fabio Insaccanebbia
            Priority: Minor


In the BasicRowProcessor class there is a comment about the toMap method:
" This  implementation returns a <code>Map</code> with case insensitive column
names as keys.  Calls to map.get("COL") and map.get("col") return the same value"

So the "contract" of this method just says that the "get" method is case insensitive. The
current implementation obtains this result by putting all the keys in lowercase. This way
we simply "lose" every information about the case of the fields. If you call the "keys" iterator,
you don't have anymore the keys you inserted, but the "lowercase" version. 

I find it not completely correct: I would expect the keys to be exactly the ones I set on
the database, also if I can get the value in a case insensitive way.
I still have to find the idea for a pathc, but I'd like to know if you find my reasoning correct.

I consider the current behaviour a problem, since I had to map the database fields to a bean
and the "case" made it impossible, even if I had set my database to return mixed case fieldnames.

-- 
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

        

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org


Mime
View raw message