[ http://issues.apache.org/jira/browse/DBUTILS-17?page=all ]
Henri Yandell updated DBUTILS-17:
---------------------------------
Attachment: DBUTILS-17.patch
Unit tests and modified class files to resolve this patch.
I'm unsure yet if they should be added. The use-case is to make it easier to
work out a count(*), but I'd expect it to only be saving the user a cast in the
end (unless there are databases that like to return the result of select
count(*) with a non Number type (we convert primitive ints etc up to Numbers).
> [dbutils] ScalarHandler subclasses that return Integers and Longs
> -----------------------------------------------------------------
>
> Key: DBUTILS-17
> URL: http://issues.apache.org/jira/browse/DBUTILS-17
> Project: Commons DbUtils
> Issue Type: Improvement
> Environment: Operating System: All
> Platform: All
> Reporter: greg hawkes
> Priority: Minor
> Fix For: 1.1
>
> Attachments: DBUTILS-17.patch, IntScalarHandler.java,
> LongScalarHandler.java
>
>
> 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.
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
