File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes ResultSet Serailization Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ResultSet Serailization" Watch "ResultSet Serailization" New topic

ResultSet Serailization

prashant pachouri

Joined: May 27, 2001
Posts: 12
Hi All
The Result Set object does not implement serializable.
So if I have to send data back to client what should I do!
do I have to fill the data in an object and send it.
Thanks a lot!


If you are not living on the edge, you are wasting Space.
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
You can store the data in a Collection (vector or ArrayList) and send the collection object to the client.

So much trouble in the world -- Bob Marley
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
The ResultSet object does not represent the actual data from the database. It is a pointer to get the next row. Imagine if the ResultSet did contain all the data and you did a SELECT * FROM TABLE1 and TABLE1 contained 10 million rows! How would you store all that data?

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
I agree. Here's the link:
subject: ResultSet Serailization
It's not a secret anymore!