You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by bu...@apache.org on 2006/03/09 11:54:25 UTC
DO NOT REPLY [Bug 38907] New: - ScalarHandler subclasses that return Integers and Longs
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
DO NOT REPLY [Bug 38907] - [dbutils] ScalarHandler subclasses that return Integers and Longs
Posted by bu...@apache.org.
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
------- Additional Comments From greg@onemancoding.com 2006-03-14 07:46 -------
(From update of attachment 17855)
/*
* $Header: $
* $Revision: $
* $Date: $
*
* ====================================================================
*
* The Apache Software License, Version 1.1
*
* Copyright (c) 2006 The Apache Software Foundation. All rights
* reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
*
* 1. Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
*
* 2. Redistributions in binary form must reproduce the above copyright
* notice, this list of conditions and the following disclaimer in
* the documentation and/or other materials provided with the
* distribution.
*
* 3. The end-user documentation included with the redistribution, if
* any, must include the following acknowledgement:
* "This product includes software developed by the
* Apache Software Foundation (http://www.apache.org/)."
* Alternately, this acknowledgement may appear in the software itself,
* if and wherever such third-party acknowledgements normally appear.
*
* 4. The names "The Jakarta Project", "Commons", and "Apache Software
* Foundation" must not be used to endorse or promote products derived
* from this software without prior written permission. For written
* permission, please contact apache@apache.org.
*
* 5. Products derived from this software may not be called "Apache"
* nor may "Apache" appear in their names without prior written
* permission of the Apache Software Foundation.
*
* THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
* WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
* OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
* ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
* USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
* OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
* OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
* SUCH DAMAGE.
* ====================================================================
*
* This software consists of voluntary contributions made by many
* individuals on behalf of the Apache Software Foundation. For more
* information on the Apache Software Foundation, please see
* <http://www.apache.org/>.
*/
package org.apache.commons.dbutils.handlers;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* <code>ResultSetHandler</code> implementation that converts one
* <code>ResultSet</code> column into a Long. This class is thread safe.
*
* @author Greg Hawkes
*/
public class LongScalarHandler extends
org.apache.commons.dbutils.handlers.ScalarHandler {
/**
* Create a new instance of LongScalarHandler.
*
* Calls to <code>handle()</code> will retrieve the first column
* from the <code>ResultSet</code>.
*/
public LongScalarHandler() {
super();
}
/**
* Creates a new instance of LongScalarHandler.
*
* @param columnIndex The index of the column to retrieve from the
* <code>ResultSet</code>.
*/
public LongScalarHandler(int columnIndex) {
super(columnIndex);
}
/**
* Creates a new instance of LongScalarHandler.
*
* @param columnName The name of the column to retrieve from the
* <code>ResultSet</code>.
*/
public LongScalarHandler(String columnName) {
super(columnName);
}
/**
* Returns one <code>ResultSet</code> column as a Long via the
* <code>ResultSet.getObject()</code> method that performs type
* conversions.
*
* @return A <code>Long</code> containing the value of the column,
* or <code>null</code> if there are no rows in the <code>ResultSet</code>.
*
* @throws SQLException if the column cannot be converted to a Long
*
* @see
org.apache.commons.dbutils.ResultSetHandler#handle(java.sql.ResultSet)
*/
public final Object handle(ResultSet rs) throws SQLException {
Object result = super.handle(rs);
if (result == null) {
return null;
}
if (result instanceof Long) {
return result;
}
if (result instanceof Number) {
return new Long(((Number) result).longValue());
}
try {
return Long.valueOf(result.toString());
} catch (NumberFormatException ex) {
throw new SQLException("Cannot convert resultset column to a
Long");
}
}
}
--
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
DO NOT REPLY [Bug 38907] - ScalarHandler subclasses that return Integers and Longs
Posted by bu...@apache.org.
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
------- Additional Comments From greg@onemancoding.com 2006-03-09 10:56 -------
Created an attachment (id=17855)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=17855&action=view)
Source file for LongScalarHandler
Source code for LongScalarHandler class. Includes Apache foundation license
comment block.
--
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
DO NOT REPLY [Bug 38907] - ScalarHandler subclasses that return Integers and Longs
Posted by bu...@apache.org.
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
------- Additional Comments From greg@onemancoding.com 2006-03-09 10:56 -------
Created an attachment (id=17854)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=17854&action=view)
IntScalarHandler.java
Source code for IntScalarHandler class. Includes Apache foundation license
comment block.
--
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
DO NOT REPLY [Bug 38907] - [dbutils] ScalarHandler subclasses that return Integers and Longs
Posted by bu...@apache.org.
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
ebourg@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|ScalarHandler subclasses |[dbutils] ScalarHandler
|that return Integers and |subclasses that return
|Longs |Integers and Longs
--
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