title: IBM WAS : Maximum Parallel DB Connections
body: <p>I have a web application developed in Java/Java EE connecting to a warehouse at the back end.
  We have IBM WAS as the application server and there is a data source defined in it for database connections.
  The connection pool has is set to a maximum pool size of 30.
  There are several times when the DB queries can take upto 1-2 minutes and hence user waits at the front end.</p>
  
  <p>What will happen in a scenario when 40 different concurrent users access a screen that is running a query at the back end taking 1-2 minutes.</p>
  
  <ol>
  <li>As per the WAS setting, there can be a maximum of 30 connections to
  DB, right?</li>
  <li>WAS will wait until a DB connection finishes
  processing and returns the connection to pool; so it can be assigned
  to next request in queue?</li>
  </ol>