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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
