Tomcat Config: Increase *maxActive* database pool connection limit

Tomcat defaults the maximum number of DB connections in the pool - maxActive - to 8.

This should be increased in our included server.xml file to allow for more concurrent connections to the DB - perhaps 20.

Lack of connections can result in various problems:

• system hangs - if JIRA locks waiting for another connection to become available

Further documentation on this setting is available at:

http://jakarta.apache.org/commons/dbcp/configuration.html

Example server.xml entry:

<Resource url="jdbc:jtds:sqlserver://192.168.0.89:1433/polycom" 
password="jira" 
name="jdbc/JiraDS" 
driverClassName="net.sourceforge.jtds.jdbc.Driver" 
type="javax.sql.DataSource" 
auth="Container"
username="jira"
maxActive="20">
</Resource>