Anurag, Thanks for the reply. I didn't visualize the connection closure.
The issue is crystal reports has a method where I can pass only the resultset object, public void setDataSource(java.sql.ResultSet data, java.lang.String oldTableAlias, java.lang.String newTableAlias) throws ReportSDKException In that case, I have to pass just the sql, call some java class/bean to get the resultset and pass it to the report. But then again the same connection issue will be there. Oops! I need to check with Crystal Reports forum. Will come back once that doubt is cleared? Regards Thiru -----Original Message----- From: Anurag Garg [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 11:49 AM To: Struts Users Mailing List Subject: RE: Can I pass an object through request object from Action class Hi, If you are closing the connection object in the action class, in that scenario you cannot use the resultset object in your report generation code. To pass the result set object in the report generation code, use CachedRowSet class and populate it from resultset object and than pass your object of the CachedResultSet object in report generation code using request or session object whatever you like. It will work.. Anurag Garg -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 11:32 AM To: [EMAIL PROTECTED] Subject: Can I pass an object through request object from Action class Importance: High Hi, Already I raised this question to this list. But no reply. Let me rephrase the question again. I need to execute and show the reports using struts. I have input jsp, action class and action form associated to that. In the action class I will generate the sql based on the input from jsp page/action form, create a result set. Now I need to pass the resultset to the report generation code. Can I put the resultset object in the request object and pass the resultset to the success page defined for the action? If this approach is not good/possible, please let me know with the correct approach. Thanks, Thiru
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited. Visit Us at http://www.polaris.co.in
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]