Retreving data from a resultset

Thread view:

tony - 15 Mar 2004 15:47 GMT

Hi

I want to retrieve all the data from a resultset and place it into a
file, are there any core library methods associated with this action
or do I have to scroll through the resultset using getXXX methods and
handle writing to a file in my own class?

Any thoughts on or around this issue would be very much appreciated

Tony

Reply to this Message

RC - 16 Mar 2004 14:29 GMT

> I want to retrieve all the data from a resultset and place it into a
> file, are there any core library methods associated with this action

I don't think so.

> or do I have to scroll through the resultset using getXXX methods and
> handle writing to a file in my own class?

Yes

Reply to this Message

Wendy S - 16 Mar 2004 19:46 GMT

> I want to retrieve all the data from a resultset and place it into a
> file, are there any core library methods associated with this action
> or do I have to scroll through the resultset using getXXX methods and
> handle writing to a file in my own class?
> Any thoughts on or around this issue would be very much appreciated

They are not part of the core, but a couple of Jakarta Commons BeanUtils
classes look interesting: ResultSetDynaClass and RowSetDynaClass. If you
already have a business object and a data access class that knows how to
write that object to the database, then one of those classes plus
BeanUtils.copyProperties might be of use.

Signature

Wendy in Chandler, AZ

Reply to this Message

Retreving data from a resultset

Free Magazines