[Heap overflow in Jasperreports Server (Apache Tomcat)]

The problem is still unsolved but the reason might be "CMS Old Gen" Memory Pool. If anybody has ideas, I will be thankful for hint because this case is urgent.

[Passing SQL query from parent report to subreport]

Hello, I am facing a following problem:
performance is very important in my application. Reports contains 5 subreports, each of them uses the same sql query and JDBC.

Is it possible to query database only once instead of six times (one from parent master + 5 subreports)?

[Heap overflow in Jasperreports Server (Apache Tomcat)]

Thank you for answer but unfortunately, this is not a solution of my problem: after increasing heap size (Approx. 16 GB), heap plot look like below and server gets stuck.

[Heap overflow in Jasperreports Server (Apache Tomcat)]

Hello,

 I have Jasperreports server on Tomcat (REST v2 web service) and when I generate report for approx. 500 records, server get stuck. Reason of this is  heap overflow  (I attach plot obtained by Visual VM). 

After using  Eclipse Memory Analyzer,  I have two problems  suspect:

1.  One instance of "org.apache.catalina.session.StandardManager" loaded by "java.net.URLClassLoader @ 0xb720c558" occupies 953 430 520 (74,78%) bytes. The memory is accumulated in one instance of "java.util.concurrent.ConcurrentHashMap$Node[]" loaded by "<system class loader>".

2. 1143 instances of "net.sf.jasperreports.renderers.SimpleDataRenderer", loaded by "org.apache.catalina.loader.WebappClassLoader @ 0xb79a3710" occupy 135 271 064 (10,61%) bytes. These instances are referenced from one instance of "java.util.concurrent.ConcurrentHashMap$Node[]", loaded by "<system class loader>"

Where the first one is much more serious (it occupy 7 times more heap).

Do you have any ideas how to solve it?
 

[Efficiency during generating huge reports]

Hi all,

my questions is: how long approximately will it take for a big company to generate 1 million of 1-page pdf reports? They are going to be filled with 20 various data field from Oracle database and generated with using REST Webservice API. Obviously, I know it depends on a lot of factors (i.e. hardware, configuration) but I need to estimate that time. Sorry if my question is silly, that's because of my lack of experience.

Thank you in advance :-)

Przemysław