We are having an issue with processing huge dataset.(It is not that huge, but still, it is huge for us as we never had to pull more than 100k data before with Spring MVC+Oracle).
The requirement is as such, we need to generate reports every month and mail it to client sales team. The Report is generated as Excel file and this is where we are pulling such huge data.
We are using Spring MVC and Oracle as DB. When I run the query in the DB, it pulls the data effortlessly within 2 seconds, consistently. But only when I call it through SimpleJdbcCall or SP in Spring, I'm getting Java Heap Space error. I increased heap space to 2GB but still no use. My system configuration is :
i3-4160 @ 3.6 GHz(Quad Core?) / 8GB RAM / Windows 7 Pro 64bit.
Source Code Link:
No responses yet.