I have a spreadsheet generated by Excel 2003 that reliably triggers POI HSSF to ask for all the memory my JVM has to give and then asks for more, causing a heap dump etc. I have not seen this in bugtrack or on the user lists - for small sheets - and wonder if perhaps this is a unique error.
My spreadsheet is only 22 records, and about 11 columns. All data is general or text format. My application is running under Java 1.4, a 2GB JVM on a quad processor server with 8 GB of physical memory. No other applications on the server. The application is IBM Maximo Asset Manager 6.2 on a Websphere 6.0.2_27 application server. Bugtrack has many complaints about how HSSF needs lots of memory and runs out of memory when processing large sheets, but 22 lines with 9 to 11 columns? That is rather small. I can provide the sheet or a hex format dump if that is useful to anyone who would like to look into this more deeply. I doubt that it is usefule to attach the file and send to the list. Jacob Steijn Application Specialist CSC 400 Commerce Dr. Newark DE 19713 USA GTS | office: 302.391.7712 | mobile: 302.359.4058 | AIM: cscjjs | email: [email protected] | www.csc.com This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
