Saving data from a SQL-query for later use

This is a discussion on Saving data from a SQL-query for later use within the JDBC JAVA forums in Framework and Interface Programming category; 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...

Go Back   Application Development Forum > Framework and Interface Programming > JDBC JAVA

Object Mix

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 10-27-2004, 02:01 PM
Jesper Sahner
Guest
 
Default Saving data from a SQL-query for later use

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
Reply With Quote
  #2  
Old 10-27-2004, 02:49 PM
Bryce
Guest
 
Default Re: Saving data from a SQL-query for later use

On 27 Oct 2004 11:01:10 -0700, jespersahner@hotmail.com (Jesper
Sahner) wrote:

>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
Reply With Quote
  #3  
Old 10-27-2004, 03:42 PM
Galen Boyer
Guest
 
Default Re: Saving data from a SQL-query for later use

On 27 Oct 2004, jespersahner@hotmail.com wrote:
> 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.

--
Galen Boyer
Reply With Quote
  #4  
Old 10-28-2004, 01:10 AM
Ann
Guest
 
Default Re: Saving data from a SQL-query for later use


"Jesper Sahner" <jespersahner@hotmail.com> wrote in message
news:7bb4f21d.0410271001.1ede132a@posting.google.c om...
> 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



Reply With Quote
Reply


Thread Tools
Display Modes


All times are GMT -5. The time now is 07:50 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vB Ad Management by =RedTyger=

In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.