m.pasquini

Thanks for the useful hints. I'm checking the JDBC connections and they seem to be released. We're not using Jasper Server: reports (jasper files) are deployed on JBoss and opened programmatically. Other ideas?

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