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 returns an error message instead of trying to connect to the database. The message is 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 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 Tomcat JDBC Connection Pool.
...