How can I pass a ResultSet from an EJB to a client? what are the best classes to use?

Jonas Bergqvist

It is better that you iterate through the ResultSet on the server side and return a Vector of Vectors (or something else similar) representing the rows and columns of the ResultSet. Everything that is sent between the EJB server and the EJB client should of course be serializable (due the to RMI specification). A ResultSet is NOT serializable and therefore you should (can) not return a ResultSet.