about ResultSet

[IPOz]

Hi,friends
I heard that i should use Collection to package data returned to client side in EJB.But i think it is not effective to transfer ResultSet to Collection.

Is it possible to return ResultSet to client side directly.
If it is then why the petstore example uses Collection to package data?Beside portability are there any other advantage using Collection?

Any suggestions are appreciated!

Best Regards! IPO_z@cmmail.com
Garbage in,Garbage out

 

[llucifer]

No it's not possible to directly return ResultSet to the client. The ResultSet object might fetch the data one row after the other from the db and therefor does not already "contain" all the data after you executed the query.
The simplest solutions is the copy the result to a collection and pass it to the client.

 

[IPOz]

Thanks for your response! I heard of CacheResultSet which conains all needed data.Anybody out there can give me details about using CacheResultSet ?

Thanks in advance! IPO_z@cmmail.com
Garbage in,Garbage out