I'm doing automation tool for ETL testing. It will extract data from an Oracle database and paste in Microsoft Excel and compare source-target based on the key columns.
While generating report, if the records exceeds 8000 it hits an exception:
Exception in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap space
Have also increased the Heap memory size to -Xmx1524m
which didn't work. If i increase it more than 1524m
, Eclipse is not opening.