This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes returning resultsets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "returning resultsets" Watch "returning resultsets" New topic

returning resultsets

shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
I have a method which should do a "select" query and return the resultant rows as it is in the form of a table. Since i cannot use ResultSet to shuttle data between methods, what could be a possible solution to this problem?? I was reading abt CachedRowSet which is a kind of a "disconnected" result set. So can I return a cached rowset from my method?? And then the caller of my method can use it....Before getting into the code details, I just wanted to know if there is any other possible or better solution?
Mani Ram
Ranch Hand

Joined: Mar 11, 2002
Posts: 1140
Look at this article

Quaerendo Invenietis
shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
Originally posted by Mani Ram:
Look at this article

thanx,guess i am on the right track.
It is sorta covered in the JavaRanch Style Guide.
subject: returning resultsets
It's not a secret anymore!