[DBUTILS-57] BeanProcessor not able to map an alias column from a HSQLDB query to the any bean properties

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3

Environment

hsqldb-1.9.0-rc4 memory mode
DBUtils 1.2

• Assignee: Unassigned
• Reporter: Wynand
• Created: 11/Aug/09 09:08
• Updated: 03/Nov/09 20:51
• Resolved: 03/Nov/09 20:21

Description

Using a query with an alias, hsqldb engine doesn't populate the column name metadata only the column label metadata.

In such a case the column isn't mapped.

To resolve this, the column label should be used in case the column name is not available.

Here is a snippet from org.apache.commons.dbutils.BeanProcessor.mapColumnsToProperties line 393 :

...
for (int col = 1; col <= cols; col++) {
String columnName = rsmd.getColumnName(col);

// columnName is empty, revert to column label
if (columnName.length() == 0)

{ columnName = rsmd.getColumnLabel(col); }

...