[DBUTILS-113] Add support for conversion of ResultSet strings to enums in the BeanProcessor

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.6
• Labels: patch
• Assignee: Benedikt Ritter
• Reporter: Graylin Kim
• Created: 01/Aug/13 17:50
• Updated: 20/Jul/14 08:48
• Resolved: 08/May/14 09:23

Description

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.

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)

It seems to me that commons-dbutils should be able to handle this conversion.