ResultSet through ObjectOutputStream

[FlyNn]

Hi Java Gurus,

I'll start with a sequence diagram first:

1. Client app sends a string to server ---> 2. Server calls MySQL procedure ---> 3. MySQL DB builds table---> 4. Server runs a query on MySQL and gets a ResultSet.

Now, the idea is to return the ResultSet (or data inside the result set) back to the Client app. I know the ResultSet isn't serialized which when I run the program throws java.io.NotSerialisableException.

I'd like some guidance as to how I could make the result set serialisable or if there are any other ways/techniques to return the data back to the Client app.

P.S. Is it SerialiZable or SerialiSable. :confused:

Thanks in advance

[masijade]

See this thread.

P.S. if you Google there are RMI JDBC Driver examples.

[FlyNn]

Thanks masijade :)

Sounds pretty simple :) Surprised I did not think of that myself :confused: :D

[JosAH]

I'd like some guidance as to how I could make the result set serialisable or if there are any other ways/techniques to return the data back to the Client app.

P.S. Is it SerialiZable or SerialiSable. :confused:

Your server has to fetch the data from each row of the result set and store it in a Vector or a List. After the Vector or List (or whatever) is populated the result set can be closed and the list has to be send to the client. Of course all data in the list has to be Serializable. The British should've written it as serialisable but of course the tribes on the wrong side of the pond spell it as serializable, bloody bastards! ;-)

kind regards,

Jos

[FlyNn]

Thanks JosAH

HashMap it is then! :)

FlYnN