Skip to main content


Showing posts from December, 2015

Resolve OutOfMemoryError With ExcelExport : Export Excel Utility with Apache POI Stream API (SXSSF)

Whenever we try to export excel of huge data (for ex: around 200000-300000 records), most of the time we end up with OutOfMemoryError:JavaHeapSpace. And also consuming more time to process or export that much of data. Main reason to this kind of problem is that, the prior version of Apache POI (prior to 3.8) will not provide proper solution for this kind of situations and also we have other issues with the API designed with those versions. Even I had faced issues of not supporting more than 65000 rows of data during exporting excel with prior versions of POI. But with the version 3.8 and higher they come with solutions for all these problems. To resolve Memory issue and performance issue of Excel Export they have utilized stream API to design their API to support huge data export and performance issues. With stream API we can flush only few rows of data into the Memory and reamining we can flush to the hard memory (permanent Memory). In this example y…

Reading a file while file being written at the same time

Below code describes how to read a file when a particular file is actively being written. Here is a full example. For the below example the mentioned file should be existed in the mentioned path else it will throw FileNotFoundException.

import; import; import; import; public class ReadingFileWhileWrite extends Thread { boolean running = true; BufferedInputStream reader = null; public static void main(String[] args) throws FileNotFoundException { ReadingFileWhileWrite tw = new ReadingFileWhileWrite(); tw.reader = new BufferedInputStream(new FileInputStream("TestFile.txt")); tw.start(); } public void run() { while (running) { try { if (reader.available() > 0) { System.out.print((char); } else { try { …