You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by "Anderson, James H [IT]" <ja...@citigroup.com> on 2004/06/21 14:56:30 UTC
[DbUtils] ClassCastException
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.java:3454)
at com.ssmb.recom.aft.datamanager.AftRequests.nextBusinessDateAfter(AftRequests.java:3489)
at com.ssmb.recom.aft.datamanager.AftRequests.main(AftRequests.java:2920)
The invoking code:
java.sql.Date sqlDate = new java.sql.Date( date.getTime() );
String selectTradingDate = "select trading_date from trade_days where trading_date >= ? and banking_day = 'B'";
Object[] params = { sqlDate };
boolean commit = true;
Map h = null;
try {
h = (Map) DbUtil.selectOneMapTrimmed(selectTradingDate, params, commit);
} catch (Exception e) {
logger.error("No trade date >= " + date, e);
throw new RuntimeException(e.getMessage());
}
java.util.Date tradeDate = (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=null to avoid parameter substitution
*/
public static Object selectOneMapTrimmed(String query, Object[] param, boolean commit)
throws Exception {
MapHandler h = new MapHandler() {
public Object handle (ResultSet rs) throws SQLException {
StringTrimmedResultSet wrapped = new StringTrimmedResultSet(rs);
rs = ProxyFactory.instance().createResultSet(wrapped);
Object returnVal = null;
try {
returnVal = super.handle(rs);
} catch (SQLException e) {
System.out.println(e.getMessage());
throw e;
}
return returnVal;
}
};
if (param == null) {
return select(query, h, commit);
} else {
return select(query, param, h, commit);
}
}
[...]
}
The table being queried:
table database creator created
------------------ ---------- ---------- ----------
trade_days db2tst08 vimdbat 06/20/2000
column type length scale nulls
------------------ -------- ------ ----- -----
trading_date date 4 0 y
trading_day char 1 0 y
trading_dow smallint 2 0 y
banking_day char 1 0 y
--------------------
Note:
When I execute this query using vanilla JDBC, everything works fine.
Any help appreciated,
jim
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org
Re: [DbUtils] ClassCastException
Posted by David Graham <gr...@yahoo.com>.
What does your DbUtil line 143 look like? When you set a breakpoint at
that line and inspect it in your debugger what is the class being
returned?
David
--- "Anderson, James H [IT]" <ja...@citigroup.com> wrote:
> 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.java:3454)
> at
>
com.ssmb.recom.aft.datamanager.AftRequests.nextBusinessDateAfter(AftRequests.java:3489)
> at
> com.ssmb.recom.aft.datamanager.AftRequests.main(AftRequests.java:2920)
>
> The invoking code:
>
> java.sql.Date sqlDate = new java.sql.Date( date.getTime() );
>
> String selectTradingDate = "select trading_date from trade_days
> where trading_date >= ? and banking_day = 'B'";
>
> Object[] params = { sqlDate };
> boolean commit = true;
>
> Map h = null;
> try {
> h = (Map) DbUtil.selectOneMapTrimmed(selectTradingDate,
> params, commit);
> } catch (Exception e) {
> logger.error("No trade date >= " + date, e);
> throw new RuntimeException(e.getMessage());
> }
> java.util.Date tradeDate = (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=null to avoid parameter substitution
> */
> public static Object selectOneMapTrimmed(String query, Object[] param,
> boolean commit)
> throws Exception {
>
> MapHandler h = new MapHandler() {
> public Object handle (ResultSet rs) throws SQLException {
> StringTrimmedResultSet wrapped = new StringTrimmedResultSet(rs);
> rs = ProxyFactory.instance().createResultSet(wrapped);
> Object returnVal = null;
> try {
> returnVal = super.handle(rs);
> } catch (SQLException e) {
> System.out.println(e.getMessage());
> throw e;
> }
> return returnVal;
> }
> };
>
> if (param == null) {
> return select(query, h, commit);
> } else {
> return select(query, param, h, commit);
> }
> }
>
> [...]
>
> }
>
> The table being queried:
>
> table database creator created
> ------------------ ---------- ---------- ----------
> trade_days db2tst08 vimdbat 06/20/2000
>
> column type length scale nulls
> ------------------ -------- ------ ----- -----
> trading_date date 4 0 y
> trading_day char 1 0 y
> trading_dow smallint 2 0 y
> banking_day char 1 0 y
> --------------------
>
>
> Note:
>
> When I execute this query using vanilla JDBC, everything works fine.
>
> Any help appreciated,
>
> jim
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-dev-help@jakarta.apache.org
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org