Hi!
How would you save data from a SQL-query for later use?
Is RowSet an option?
I know this is a broad question, but I would like some opinions on the subject.
Regards,
Jesper
Bryce - 27 Oct 2004 19:49 GMT
>Hi!
>
>How would you save data from a SQL-query for later use?
>Is RowSet an option?
>
>I know this is a broad question, but I would like some opinions on the subject.
Well, depends on the requirements, but I generally have a java object
that maps to the columns of a particular rowset. If there are multiple
rows, then I have one object per row then save in a collection, such
as a Map or List...
--
now with more cowbell
Galen Boyer - 27 Oct 2004 20:42 GMT
> Hi!
>
> How would you save data from a SQL-query for later use?
> Is RowSet an option?
I wouldn't until it is shown that the trips to the database are
too expensive.

Signature
Galen Boyer
Ann - 28 Oct 2004 06:10 GMT
> Hi!
>
> How would you save data from a SQL-query for later use?
> Is RowSet an option?
what about the metadata?
> I know this is a broad question, but I would like some opinions on the subject.
>
> Regards,
> Jesper