Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: [DbUtils] ClassCastException
Date: Tue, 22 Jun 2004 10:31:39 -0400
Message-ID: <93AF13596239A243A4D4D1E66955CE2521A0E4@EXNJMB22.nam.nsroot.net>
Thread-Topic: [DbUtils] ClassCastException
Thread-Index: AcRYZaE37WkoeiheSLWAh7gee155KQ==
From: "Anderson, James H [IT]" <james.h.anderson@citigroup.com>
To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>

(This is a resend of a msg I sent yesterday which I did not see appear =
on the list. In fact, I haven't received any mail from the list for a =
day or two...)

I'm getting a ClassCastException that I don't understand. I hope someone =
can help with this, because I'd very much like to be able to use DbUtil =
on my project!

The stack trace:

org.apache.commons.dbutils.BasicRowProcessor$CaseInsensitiveHashMap
java.lang.ClassCastException: =
org.apache.commons.dbutils.BasicRowProcessor$CaseInsensitiveHashMap
	at com.ssmb.recom.aft.access.DbUtil.select(DbUtil.java:143)
	at com.ssmb.recom.aft.access.DbUtil.selectOneMapTrimmed(DbUtil.java:66)
	at =
com.ssmb.recom.aft.datamanager.AftRequests.nextBusinessDate(AftRequests.j=
ava:3454)
	at =
com.ssmb.recom.aft.datamanager.AftRequests.nextBusinessDateAfter(AftReque=
sts.java:3489)
	at =
com.ssmb.recom.aft.datamanager.AftRequests.main(AftRequests.java:2920)

The invoking code:

        java.sql.Date sqlDate =3D new java.sql.Date( date.getTime() );

        String selectTradingDate =3D "select trading_date from =
trade_days where trading_date >=3D ? and banking_day =3D 'B'";

        Object[] params =3D { sqlDate };
        boolean  commit =3D true;

        Map h =3D null;
        try {
            h =3D (Map) DbUtil.selectOneMapTrimmed(selectTradingDate, =
params, commit);
        } catch (Exception e) {
            logger.error("No trade date >=3D " + date, e);
            throw new RuntimeException(e.getMessage());
        }
        java.util.Date tradeDate =3D (java.util.Date) =
h.get("trading_date");


My wrapper code as invoked in the code, above:

package com.ssmb.recom.aft.access;

import java.sql.*;
import java.util.*;
import org.apache.commons.dbutils.*;
import org.apache.commons.dbutils.handlers.*;
import org.apache.commons.dbutils.wrappers.*;
import org.apache.commons.beanutils.BeanUtils;

import com.ssmb.recom.datamgr.RecomDataSource;

public class DbUtil {

[...]

	/**
	   select one row, set param=3Dnull to avoid parameter substitution
	 */
	public static Object selectOneMapTrimmed(String query, Object[] param, =
boolean commit)
	throws Exception {

		MapHandler h =3D new MapHandler() {
				public Object handle (ResultSet rs) throws SQLException {
					StringTrimmedResultSet wrapped =3D new StringTrimmedResultSet(rs);
					rs =3D ProxyFactory.instance().createResultSet(wrapped);
					Object returnVal =3D null;
					try {
						returnVal =3D super.handle(rs);
					} catch (SQLException e) {
						System.out.println(e.getMessage());
						throw e;
					}
					return returnVal;
				}
			};

		if (param =3D=3D null) {
			return select(query, h, commit);
		} else {
			return select(query, param, h, commit);
		}
	}

[...]

}

The table being queried:

table              database   creator    created  =20
------------------ ---------- ---------- ----------
trade_days         db2tst08   vimdbat    06/20/2000

column             type     length scale nulls
------------------ -------- ------ ----- -----
trading_date       date     4      0     y   =20
trading_day        char     1      0     y   =20
trading_dow        smallint 2      0     y   =20
banking_day        char     1      0     y   =20
--------------------


Note:

When I execute this query using vanilla JDBC, everything works fine.

Any help appreciated,

jim

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org