We are using the new version of the inegration and we have at the end of the day many open connections.
We need a fix for this.
Cf. Thread #20 on Github. https://github.com/daust/JasperReportsIntegration/issues/20
Hi, I have the same problem here at a customer site and reported this to Dietmar on Oct. 22nd of '18. Before the update of JRI 2.4.x.x to 18.104.22.168 everything was fine. Since Dietmar was very busy at this time, I wrote a database "cron job" that killed all inactive JasperReport sessions from time to time (once every hour). This is a workaround, but far better than crashing the database. Still the prob needs to be fixed reasonably.