Data Source Profiles

With release 7.0, a new parameter is available on 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 macro using the specific data source will return an error message instead of trying to connect to the database. The message will be something like:

Unable to process your request at this time. Try again later. The connection limit was reached for this data source.

This gives administrators a way to help manage database connections. This provides control over data source profiles similar to what is available for application-based data sources configured in server.xml.

Application Data Sources

Application 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 macros, then you can use the 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 macro connections.

...