Mailing-List: contact issues-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: issues@commons.apache.org
Message-ID: <417475737.1256554619494.JavaMail.jira@brutus>
Date: Mon, 26 Oct 2009 10:56:59 +0000 (UTC)
From: =?utf-8?Q?Julien_Aym=C3=A9_=28JIRA=29?= <jira@apache.org>
To: issues@commons.apache.org
Subject: [jira] Commented: (DBUTILS-57) BeanProcessor not able to map an
 alias column from a HSQLDB query to the any bean properties
In-Reply-To: <991131300.1249981755203.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/DBUTILS-57?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1276=
9986#action_12769986 ]=20

Julien Aym=C3=A9 commented on DBUTILS-57:
------------------------------------

This request is coherent to what has been done into the last BeanUtils rele=
ase: see issue BEANUTILS-344.

> BeanProcessor not able to map an alias column from a HSQLDB query to the =
any bean properties
> -------------------------------------------------------------------------=
-------------------
>
>                 Key: DBUTILS-57
>                 URL: https://issues.apache.org/jira/browse/DBUTILS-57
>             Project: Commons DbUtils
>          Issue Type: Bug
>         Environment: hsqldb-1.9.0-rc4 memory mode
> DBUtils 1.2
>            Reporter: Wynand
>
> Using a query with an alias, hsqldb engine doesn't populate the column na=
me 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.mapColumn=
sToProperties line 393 :=20
> ...
>        for (int col =3D 1; col <=3D cols; col++) {           =20
>             String columnName =3D rsmd.getColumnName(col);
>            // columnName is empty, revert to column label
>             if (columnName.length() =3D=3D 0) {
>                 columnName =3D rsmd.getColumnLabel(col);
>             }           =20
>             ...

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.