I am trying to export large data(6000 rows and 120 columns) to excel but Tomcat(4.1.27) is throwing java.lang.OutOfMemory Exception. I use a custom servlet for this purpose. I tried to increase the heap adding the below line in the "catalina.sh"
but no Success.
Could you plz help me to resolving this problem???
If you're only exporting this data and don't need it to persist in your web app, make sure you're releasing all objects in your servlet (you don't have a reference to it somewhere and GC isn't removing it) Do you get all the data in one buffer and then export to Excel? is there an exception happening somewhere prior to successfully exporting it?