In an ArrayList or something similar. I pass to the ArrayList all the info of the ResultSet. I thing there is a better way to pass the database data to the JSP, using Rowsets.
HTH. -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Marco Tedone Enviado el: martes, 05 de agosto de 2003 10:31 Para: JBoss-user-list Asunto: [JBoss-user] [OOT] Passing ResultSet to an external client Hi everybody, I hope that you are fine :) >From my web client (a Struts Action) I am trying to get a ResultSet from a session bean deployed under Jboss. The queried database is MySQL and the query is executed correctly as at the end I can see from Jboss console the log message that the object is of type com.mysql.jdbc.ResultSet. The problem is that I get also the following exception: java.io.NotSerializableException: com.mysql.jdbc.ResultSet I can guess that the ResultSet is not serializable, which has its logic if you want (i.e. a ResultSet must be managed thus requiring a continue interaction with the database, therefore each operation on it would require to colloquiate with Jboss :). Please note that the record format is unknown at compile time as the query is created dynamically. So my question is: how would you pass something similar to a RecordSet from Jboss to a web client? Thanks for any help, Marco ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01 /01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
