commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Graham <grahamdavid1...@yahoo.com>
Subject Re: [DBUTILS] How to handle and int
Date Sat, 07 Feb 2004 19:15:36 GMT
http://jakarta.apache.org/commons/dbutils/apidocs/org/apache/commons/dbutils/BasicRowProcessor.html

Notice that there is a constructor that accepts a ColumnProcessor.  All
you need to do is this:

new BasicRowProcessor(new BasicColumnProcessor());

David

--- Mike Zatko <zatko440@comcast.net> wrote:
> I've downloaded the latest build, but I am unsure as to where the 
> BasicColumnProcessor class fits in. The mapColumnsToProperties method 
> requires ResultSetMetaData which is hidden inside the BeanListHandler in
> 
> my own code. Does this mean I'd have to write my own Handler? Are there 
> any examples on this anywhere?
> 
> Thanks
> 
> 
> David Graham wrote:
> 
> >Grab a nightly build and use the BasicColumnProcessor class.  This is
> such
> >a common problem that we should probably release 1.1 soon.
> >
> >David
> >
> >--- Mike Zatko <zatko440@comcast.net> 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
> >>
> >>    
> >>
> >
> >
> >__________________________________
> >Do you Yahoo!?
> >Yahoo! Finance: Get your refund fast by filing online.
> >http://taxes.yahoo.com/filing.html
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: commons-user-help@jakarta.apache.org
> >
> >
> >  
> >
> 
> 


__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message