my dog learned polymorphism*
The moose likes EJB and other Java EE Technologies and the fly likes How much data can a session bean hold? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "How much data can a session bean hold?" Watch "How much data can a session bean hold?" New topic
Author

How much data can a session bean hold?

Gale Greaser
Greenhorn

Joined: Aug 05, 2002
Posts: 17
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
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
Probably not. Is there any chance of being able to split this over several pages by making it into several excel spreadsheets?
Kyle


Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
Gale Greaser
Greenhorn

Joined: Aug 05, 2002
Posts: 17
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
Ranch Hand

Joined: Jan 30, 2001
Posts: 228
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...........


Adios
Gale Greaser
Greenhorn

Joined: Aug 05, 2002
Posts: 17
Thank you for your help!
I think I will just get x number or rows at a time.
I appriciate your responce!
Andrey Solonchuk
Greenhorn

Joined: Mar 29, 2003
Posts: 4
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)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How much data can a session bean hold?
 
Similar Threads
How to create excel file in jsp
How to Export web page(jsp page) to excel using jsp or servlets
Need help in find the text from 1000 Records
dispaly records in format of excel
Memory Problem