You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by "greg hawkes (JIRA)" <ji...@apache.org> on 2006/07/06 13:39:30 UTC
[jira] Commented: (DBUTILS-17) [dbutils] ScalarHandler subclasses
that return Integers and Longs
[ http://issues.apache.org/jira/browse/DBUTILS-17?page=comments#action_12419487 ]
greg hawkes commented on DBUTILS-17:
------------------------------------
No problem, Henri. I assume that you're referring to issue http://issues.apache.org/jira/browse/DBUTILS-27. I realise that this issue tackles a similar problem to my own, but I believe that mine is a more general solution to a wider range of problems. In fact, DBUTILS-27 would be simple to implement using a call to my IntScalarHandler routine.
> [dbutils] ScalarHandler subclasses that return Integers and Longs
> -----------------------------------------------------------------
>
> Key: DBUTILS-17
> URL: http://issues.apache.org/jira/browse/DBUTILS-17
> Project: Commons DbUtils
> Type: Improvement
> Environment: Operating System: All
> Platform: All
> Reporter: greg hawkes
> Priority: Minor
> Fix For: 1.1
> Attachments: 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: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org