Hi, our application needs a ResultSet obtained after a query. The client is a web application (running on Tomcat), while the database is queried through a session bean running in Jboss. At the beginning the type returned by the interface method was ResultSet, but then we obtained the following exception:

Exception while executing the query: java.io.NotSerializableException: com.mysql.jdbc.ResultSet

So we tried to defined the return type as Object (which is serializable) but the result is the same. I tried also to put the ResultSet in a List obtaining the same result.

Here follows part of the code (warning, it contains some encapsulated methods) to create the ResultSet:

try { ps = connect().prepareStatement(queryString); if (ps != null) { dbData = ps.executeQuery(); }

The dbData variable, when the query is executed contains the following, retrieved by Jboss console:

com.mysql.jdbc.ResultSet

The question is: how could I pass a ResultSet from Jboss to my client (please note that the record format is unknow at compile time, as the query is built dynamically)?

Thanks for any help,