title: Can I change the max-pool-size for connections, and what determines what I should set it to?
body: <p>Encountering the following error with our J2EE application:</p>
  
  <blockquote>
    <p>java.sql.SQLException: Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections. </p>
  </blockquote>
  
  <p>How do I know how many connections the application is currently using and what should be the optimal connection pool settings for a heavily traffic application? Can I change it, and how can I determine what I should set it to (is it a memory issue, bandwidth, etc.)?</p>