I didn't know POI would run in 32MB! Wow! <bg> -----Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 12:05 AM To: POI Users List Subject: Re: poi/hssf memory help please
Holy crap it looks like your total heap size is 32MB? Default in Java is like 64MB. >java -Xmx128m -Xms128m... Would set it to 128mb with a min of the same. I didn't know WL would run in only 32 mb! Wow! -andy -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this email are those of the author and are almost definitely not shared by the Apache Software Foundation, its board or its general membership. In fact they probably most definitively disagree with everything espoused in the above email. > From: [EMAIL PROTECTED] > Reply-To: "POI Users List" <[EMAIL PROTECTED]> > Date: Mon, 22 Dec 2003 22:47:38 EST > To: [EMAIL PROTECTED] > Subject: poi/hssf memory help please > > Hello, i am using: > > redhat linux enterprise > weblogic6.1 > java 1.3.1 > > When generating a 1000+ row x 54 col excel sheet using HSSF, the java servlet > throws an outofmemory exception everytime (if i do one with 600 rows or less, > it works fine). This is the first time i am using hssf and I followed the > tutorial code: > > HSSFRow title = sheet.createRow((short)0); > title.createCell((short)0).setCellValue("columnname1"); > title.createCell((short)1).setCellValue("columnname2"); > ......etc..... > title.createCell((short)54).setCellValue("columnname53"); > > ResultSet rs = getresultset(); > int rowcount=1; > rs = executeQuery(sql); //get resultset, leftout some jdbc codes > while (rs.next()) //has 1000+ rows > { > HSSFRow datarow = sheet.createRow((short)rowcount); > rowcount++; > for(int colcount=0; colcount<55;colcount++) > { > datarow.createCell((short)colcount).setCellValue(rs.getString(colcount+1)); > } > } > > Here's memory usage log file from 2 tries, both resulted in outofmemory: > > [GC 13773K->10735K(32640K), 0.0287972 secs] > <Dec 22, 2003 10:04:35 AM EST> <Debug> <DEBUG> <*********************FIRST > FOR LOOP:0> > ...... > <Dec 22, 2003 10:07:04 AM EST> <Debug> <DEBUG> <CELL COUNT:50 CELL VALUE:0> > //*****Note this row never finished, cell count should reach 54 like every > other row. > [Full GC 32639K->29327K(32640K), 1.8477303 secs] > [Full GC 29327K->29289K(32640K), 1.8480125 secs] > <Dec 22, 2003 10:07:08 AM EST> <Error> <HTTP> > <[WebAppServletContext(2438883,yyy,/yyy)] Servlet failed with Exception > java.lang.OutOfMemoryError > <<no stack trace available>> > > > -------------- > > > [GC 11797K->8490K(32640K), 0.0076758 secs] > [GC 11818K->8461K(32640K), 0.0067751 secs] > <Dec 22, 2003 10:15:11 AM EST> <Debug> <DEBUG> <*********************FIRST > FOR LOOP:0> > ....... > <Dec 22, 2003 10:17:12 AM EST> <Debug> <DEBUG> <CELL COUNT:54 CELL VALUE:0> > [Full GC 30728K->27639K(32640K), 1.7628752 secs] > [Full GC 32457K->28945K(32640K), 2.1956773 secs] > [Full GC 28945K->28945K(32640K), 1.7103354 secs] > <Dec 22, 2003 10:17:19 AM EST> <Error> <HTTP> > <[WebAppServletContext(2438883,yyy,/yyy)] Servlet failed with Exception > java.lang.OutOfMemoryError > <<no stack trace available>> > > > From the log it seems the machine is not out of memory? I am really not sure > what is going on with hssf now. Please help, thank you > > gaga > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
