commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 38907] New: - ScalarHandler subclasses that return Integers and Longs
Date Thu, 09 Mar 2006 10:54:25 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=38907>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=38907

           Summary: ScalarHandler subclasses that return Integers and Longs
           Product: Commons
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P4
         Component: DbUtils
        AssignedTo: commons-dev@jakarta.apache.org
        ReportedBy: greg@onemancoding.com


I (and, looking around, many other people) most often use ScalarHandler to fetch
the result of an SQL count(*) column. ScalarHandler works, but I was forever
needing to parse the result to create an Integer (and occasionally, a Long)
value. Several possible solutions have been proposed to make this task easier.
This is mine.

I have extended ScalarHandler to create IntScalarHandler and LongScalarHandler,
which return Integers and Longs, respectively. Their usage is exactly the same
as ScalarHandler. They have been tested on Oracle, MS-SQL Server, and PostgreSQL
databases, and have proven to be very effective. I hope that they can be
included in the DbUtils distribution, where they fit right alongside the
existing ScalarHandler.

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

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