Data
...
source profiles
With release 6.6, a new parameter is available on Data Source Profiles data source profiles called maxActive which can be used to limit the number of actively executing SQL queries for a specific data source. Once the maximum active limit is reached, the next requested render of a sql SQL macro using the specific data source returns an error message instead of trying to connect to the database. The message is something like:
...
This gives administrators a way to help manage database connections. This provides control over data source profiles similar to what is available for application server based data sources configured in server.xml.
Application
...
server based data sources
Application server based data sources have various management parameters including maxActive and maxWait. See The Tomcat JDBC Connection Pool.
If you need to further limit the number of connections used by sql SQL macros, then you can use the use maxActive data source profile setting to also control the application data source by referencing the application data source in the data source profile. For example, if myDS is an application defined data source, then the following data source profile would further restrict sql SQL macro connections.
| Name | Value |
|---|---|
| myDS | dataSource=myDS | maxActive = 10 |