Saving data from a SQL-query for later use

[Jesper Sahner]

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]

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...

 

[Galen Boyer]

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.

 

[Ann]

Hi!

How would you save data from a SQL-query for later use?
Is RowSet an option?

what about the metadata?

 

[marcus]

Well -- for data integrity he might want to get all the data at once.
Some data might change between queries and he prefers to have an
integral set rather than latest of each piece.

It is possible to use the metadata concept to create a very flexible
object to store your data, and even to assist in generating queries --
and in my case building web forms to populate those queries. Links the
database structure to the webform so one change wass all that was
required for 3 -- count 'em boys -- three related tasks. damn I like
"--"'s

 

[Galen Boyer]

Well -- for data integrity he might want to get all the data at
once. Some data might change between queries and he prefers to
have an integral set rather than latest of each piece.

It is possible to use the metadata concept to create a very
flexible object to store your data, and even to assist in
generating queries -- and in my case building web forms to
populate those queries. Links the database structure to the
webform so one change wass all that was required for 3 -- count
'em boys -- three related tasks. damn I like "--"'s

But once you start saying, "Cache it" which is what the OP is
talking about" you have to solve the staleness issue. That ain't
no picnic. And, them entity beans, shudder...