commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Henri Yandell (JIRA)" <>
Subject [jira] Updated: (DBUTILS-17) [dbutils] ScalarHandler subclasses that return Integers and Longs
Date Thu, 02 Nov 2006 07:18:17 GMT
     [ ]

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:
>             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,,
> 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:
For more information on JIRA, see:


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message