Oops, Here is the SQL i'm executing:
SELECT e.mfpartnumber as PARTNUMBER, desc.longdescription as
DESCRIPTION, desc.name as NAME, desc.thumbnail as THUMBNAIL,
g.identifier as IDENTIFIER, g.catgroup_id as GROUPID
FROM DB2USR.catentry e, DB2USR.catgroup g, DB2USR.catentdesc
desc, DB2USR.catgpenrel rel
WHERE e.catentry_id = desc.catentry_id
AND e.member_id=g.member_id
AND rel.catentry_id = e.catentry_id
AND rel.catgroup_id = g.catgroup_id
AND rel.sequence = 1
ORDER BY PARTNUMBER
Mike Zatko wrote:
> Hello,
> This should be a very simple question. I am pulling in a table in a
> query that contains a bunch of Strings and an Integer. It works fine
> except its not getting the values for the ints. How do I map the
> database integer column to my bean? I've tried using int, Integer, and
> String, but none work.
>
>
> public class MerchantBean {
> private String partNumber;
> private String description;
> private String name;
> private String thumbnail;
> private String picture;
> private String identifier;
> private int groupId;
>
> ...
> }
>
>
>
> Heres the snippet of code, nothing spectacular:
>
> runner = new QueryRunner();
> handler =
> new BeanListHandler(MerchantBean.class);
> List merchantRecords =
> (List)runner.query(conn,
> configuration.getMerchantFileQuery(), handler);
>
>
> Everything works fine except I get 0's for my groupId field. Any ideas?
> Thanks.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
|