java.lang.OutOfMemoryError
Hello,
I'm getting a resultset from Oracle.
I need to get colums name and the resultset in a HSSFSheet of my
HSSFWorkbook.
It will looks like toad view data (top-> colums name and data after).
I create an arraylist of arraylist
1)the colums name for the first arraylist,
2)data
After i loop into the arraysList of arrayList, and i tried to set the
value of the entire HSSFSheet with this method:
oneSheet = workBook.getSheetAt(sheetNb);
oneRow = oneSheet.getRow(rowNb);
if (oneRow == null) {
oneRow = oneSheet.createRow(rowNb);
}
oneCell = oneRow.getCell((short) cellNb);
if (oneCell == null) {
oneCell = oneRow.createCell((short) cellNb);
}
oneCell.setCellValue(stringValue);
There are just 46 000 rows and for each rows 25 cells.
At the end i have this exception:
java.lang.OutOfMemoryError
Do you know an other way to set the value of a HSSFSheet from an
ArrayList, Hashmap, Array?
Thx
benjamin CHALLAMEL,
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
