<p>Hi,</p>
<p> </p>
<p>I am creating a report with some statistics presented as tables and charts. There are some 20 data sets connected to a data source.</p>
<p> </p>
<p>The problem is that when the report executes, it makes (seemingly) a new connections to the database for each dataset and keeps the connection open while the report is running. E.g. 20 connections are made to the database rather than only one.</p>
<p> </p>
<p>This result in that the maximum number of database connection is reached and the database refuses additional connections.</p>
<p> </p>
<p>Is there a way to limit the number of concurrent connection to a JDBC data source? </p>
<p> </p>
<p>Any suggestions would be greatly appreciated.</p>
<p> </p>
<p> </p>
<p>Thanks!</p>
<p> </p>
<p> </p>
<p> </p>
