It's not a secret anymore!
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
jQuery in Action, 3rd edition