How much data can a session bean hold?

[Gale Greaser]

Hi -
I'm wondering if it's wise to dump thousands of database records into a session bean to be displayed in a JSP who's MIME is that for an excel document. (An excel spreadsheet will be displayed in the browser window displaying all records in the database.
Please advise -
Thanks!

[Kyle Brown]

Probably not. Is there any chance of being able to split this over several pages by making it into several excel spreadsheets?
Kyle

[Gale Greaser]

Thanks for your reply!
All the data needs to be in one Excel spreadsheet.
Is there any other way of doing this without beans? Would it be better to put the ResultSet into the request and access the records in the ResultSet directly in the JSP?

[sandy gupta]

Not at all......RS is a db object and should not be transported around the system else some class that never created the RS will have to remember to close it which could cause a potential for memory leaks in u'r system...........
Now coming to the problem..........What i would suggest u to do is get a smaller RS from the db say 50 rows, store them in a Object which u can serialize and pass around........and ask the user if he wants to see more..........I think that that is the best way to do it...........

[Gale Greaser]

Thank you for your help!
I think I will just get x number or rows at a time.
I appriciate your responce!

[Andrey Solonchuk]

hi, hay be you neddn`t put result set in request
you may be can produse xml with data from result set. its not hard
(i thinking about this problem in my task now)