wood burning stoves 2.0*
The moose likes JDBC and the fly likes returning resultsets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
List to HashMap?
SOAP Interface to EJB
Arguments and return type from org.aspectj.lang.Signature, or org.aspectj.lang.ProceedingJoinPoint
string comparison with compareTo() method
UrlyBird - RMI server and Data design issues