sql developer 2.1.0.62.61: export to excel fails
724704Sep 28 2009 — edited Sep 29 2009I have just installed the newest version of SQL Seveloper EA (2.1.0.62.61). The export to an Excel file will only work if less than 10.000 records are selected. From the 10.000th Record on the export process extremly slows down and the Excel file quickly becomes larger than 1 gigabyte. (currently 17,000 records and 25 gigabytes of file size!!). If the disk is full, the export will collapse at some point (German Error message 'There is not enough disk space available' below) The Export as CSV file works fine!
java.io.IOException: Es steht nicht genug Speicherplatz auf dem Datenträger zur Verfügung
at java.io.FileOutputStream.writeBytes(Native Method)
at java.io.FileOutputStream.write(FileOutputStream.java:260)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:109)
at java.io.FilterOutputStream.write(FilterOutputStream.java:80)
at org.apache.poi.poifs.storage.BigBlock.doWriteData(BigBlock.java:54)
at org.apache.poi.poifs.storage.DocumentBlock.writeData(DocumentBlock.java:219)
at org.apache.poi.poifs.storage.BigBlock.writeBlocks(BigBlock.java:85)
at org.apache.poi.poifs.filesystem.POIFSDocument$BigBlockStore.writeBlocks(POIFSDocument.java:602)
at org.apache.poi.poifs.filesystem.POIFSDocument.writeBlocks(POIFSDocument.java:274)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.writeFilesystem(POIFSFileSystem.java:262)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:742)
at oracle.dbtools.raptor.format.ExcelFormatter.startRow(ExcelFormatter.java:93)
at oracle.dbtools.raptor.format.ui.TableFormatterWrapper.print(TableFormatterWrapper.java:206)
at oracle.dbtools.raptor.format.ResultsFormatter.print(ResultsFormatter.java:195)
at oracle.dbtools.raptor.format.ResultsFormatter.doPrint(ResultsFormatter.java:396)
at oracle.dbtools.raptor.dialogs.actions.TableExportAction$5.doWork(TableExportAction.java:582)
at oracle.dbtools.raptor.dialogs.actions.TableExportAction$5.doWork(TableExportAction.java:579)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:489)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)