I'm facing a performance problem with a few reports deployed on JBoss AS 7. The report generation become slow with time.
We noticed that very often, but not always the generation time gets back to normal after a JBoss restart.
The reports are made of nested sub-reports calling an Oracle DB (no XML). What I noticed debugging the SQL calls is that the queries are executed in just a few tenth of seconds but
there is a bounch of seconds lost in between one SQL invocation and the subsequents SQL invocations.
After a JBoss restart, the SQL execution time remains the same and the SQL calls are made one after another with no delay in between the calls.
We are on Jasper 6.2.1 and we run jasper compiled files