JasperReports Server manages a pool of connections for each Java Database Connectivity (JDBC) data source. By default, twenty connections are provided. If many reports are being run concurrently against a single data source, the connection limit may be reached which can cause a slowdown in service.
The pool of connections has a limited size to prevent having too much memory being permanently allocated to connections. However, users who need more concurrent connections on a regular basis can increase the limit.
To increase the amount of connections:
Navigate to C:\ReportServer\ReportServer\apache-tomcat\webapps\jasperserver-pro\WEB-INF.
Open the applicationContext.xml file.
Change the constructor argument number of the
dataSourceObjectPoolFactorybean to the desired amount. The optimal amount varies depending on the setup and number of users in the system. Experimentation is encouraged.
