poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "LiuGuoMing" <gm...@sytdc.com>
Subject 'java.lang.OutOfMemoryError: Java heap space'
Date Tue, 16 May 2006 02:24:27 GMT
Hi,ALL

I'm currently using POI to generate some fairly large Excel files 
(30,000+ rows), using the org.apache.poi.hssf.usermodel package. 

it occur 'java.lang.OutOfMemoryError: Java heap space' when run it. 

my code:

strSQL = "select * from mydatabase"; 
    
QueryData qryData = dbcmd.selQuery(strSQL); 
//  note: qryData.size() >2,0000
if (qryData.size() > 0)   
for (int i = 0;i < qryData.size();i++){ 
row=sheet.createRow((short)currRow); 
cell = row.createCell((short)0); 
cell.setCellValue(qryData.getRow(i).get("ID")); 
cell = row.createCell((short)1); 
cell.setCellValue(qryData.getRow(i).get("NAME")); 
cell = row.createCell((short)2); 
cell.setEncoding(HSSFCell.ENCODING_UTF_16); 
cell.setCellValue(qryData.getRow(i).get("ADDRESS")); 
cell = row.createCell((short)3); 
cell.setCellValue(qryData.getRow(i).get("TEL")); 
cell = row.createCell((short)4); 
cell.setCellValue(qryData.getRow(i).get("ORDERBY")); 
cell = row.createCell((short)5); 
cell.setCellValue(qryData.getRow(i).get("LINKID")); 
cell = row.createCell((short)6); 
cell.setCellValue(qryData.getRow(i).get("CSTATUS")); 
cell = row.createCell((short)7); 
cell.setCellValue(qryData.getRow(i).get("NTATUS")); 
cell = row.createCell((short)8); 
cell.setCellValue(qryData.getRow(i).get("FLG")); 

System.out.println(currRow); 

currRow=currRow+1; 
           
} 
} 



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message