How to receive data via sockets retrieved through Result Set?

Question

Statement st=(Statement) sqlcon.createStatement();
ResultSet p=st.executeQuery("SELECT * FROM `chat`.`online_users`");

I have got the data from the database through the object of ResultSet but when i am sending it to the client through sockets it is giving an error. It is not serializable. How to send data and receive data retrieved through ResultSet across socket?

score 2 · Accepted Answer · edited May 23 '17 at 11:43

2

Read the data from the ResultSet, push it in a List then send your List. All the implementations like ArrayList already implement Serializable interface, you can read this answer to know more about List Serialization.

edited May 23 '17 at 11:43

Community

1
1

answered Apr 17 '12 at 14:54

Luiggi Mendoza

85,076
16
154
332

score 1 · Answer 2 · answered Apr 17 '12 at 14:46

Well, you could inherit from ResultSet and implement Serializable interfaces in a new class. I would suggest a better approach would be to send XML between layers, or if you want an all Java solution, how about creating an object for each row, stuffing them in a collection class or vector, and serializing it instead of the ResultSet class.

score 1 · Answer 3 · answered Apr 17 '12 at 15:13

1

Since it needs to be serializable and send it across a network connection a CachedRowSet seems to be a good option for you to try.

answered Apr 17 '12 at 15:13

ChadNC

2,528
4
25
39

How to receive data via sockets retrieved through Result Set?

3 Answers3