Hi Benjamin, last year I ran into the same trouble while unloading DB2 tables. Try to scan the list archive for out-of-memory exceptions to get an idea howto circumvent the resource hungry use of the user model in version 2.* (Blame M$ Excel for that of cause ;=). The solution was to write cvs as plain ASCII line format with tabs as delimiter, named the file *.xls and open that im Excel. Unfor- tunatly without any fancy formatting, dull handling of big decimal and all that stuff.
HTH, cu Stefan > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] > Gesendet am: Mittwoch, 25. Januar 2006 12:40 > An: [email protected] > Betreff: resultset from Oracle to a HSSFSheet > > 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/ --------------------------------------------------------------------- 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/
