title: Too few connections from Tomcat Application
body: <p>I have a mysql database configured with a max_connections value of 150.  I also have a Java 6 web application running in Tomcat 5.5 configured with the following setup:</p>
  
  <pre><code>&lt;Resource name="jdbc/myDB"
  type="javax.sql.DataSource"
  driver="com.mysql.jdbc.Driver"
  username="username"
  password="password"
  maxActive="100"
  maxIdle="100"
  maxWait="-1"
  removeAbandoned="true"
  removeAbandonedTimeout="300"
  logAbandoned="true"
  url="jdbc:mysql://localhost:3306/myDB?autoreconnect=true"
  validationQuery="SELECT 1" /&gt;
  </code></pre>
  
  <p>This application is not using any 3rd party framework just basic java servlets.  I have a bug in some code in the java app that is not properly releasing opened mysql connections from the pool.  I am working on identifying and fixing these.  But in the meantime I need to figure out why at most there is only 25 connections being allowed to mysql.  After these 25 connections are used up, the application becomes unresponsive.</p>
  
  <p>Can someone please help me figure out why both mysql and tomcat are configured for 100+ connections but it is only allowing 25 at a time?</p>