[ https://issues.apache.org/jira/browse/DBUTILS-113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Benedikt Ritter updated DBUTILS-113: ------------------------------------ Fix Version/s: 1.6 > Add support for conversion of ResultSet strings to enums in the BeanProcessor > ----------------------------------------------------------------------------- > > Key: DBUTILS-113 > URL: https://issues.apache.org/jira/browse/DBUTILS-113 > Project: Commons DbUtils > Issue Type: Improvement > Reporter: Graylin Kim > Assignee: Benedikt Ritter > Priority: Minor > Labels: patch > Fix For: 1.6 > > Attachments: DBUTILS-113.patch, DBUTILS-113.patch, bean_enums.diff, > bean_enums2.diff, bean_enums3.diff, bean_enums4.patch > > > When using commons-dbutils I frequently use enum values with corresponding > enum in the database. In this situation, using the BeanListHandler produces > the following exception causing me to write a custom bean handler for enum > conversion. > {quote} > Cannot set status: incompatible types, cannot convert java.lang.String to > gov.nysenate.openleg.util.Storage$Status Query: SELECT * FROM changelog WHERE > 1=1 AND time >= ? AND time <= ? Parameters: [2013-07-24 00:00:00, 2013-07-26 > 23:59:59] > java.sql.SQLException: Cannot set status: incompatible types, cannot convert > java.lang.String to gov.nysenate.openleg.util.Storage$Status Query: SELECT * > FROM changelog WHERE 1=1 AND time >= ? AND time <= ? Parameters: [2013-07-24 > 00:00:00, 2013-07-26 23:59:59] > at > org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363) > at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:350) > at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:288) > {quote} > It seems to me that commons-dbutils should be able to handle this conversion. -- This message was sent by Atlassian JIRA (v6.2#6252)