title: DB connection pool in Standalone Axis2?
body: <p>For my services in production environment I always set up DB connections pool in Tomcat's <code>context.xml</code>:</p>
  
  <pre><code>&lt;Resource name="jdbc/MyDB" auth="Container" type="javax.sql.DataSource"
      maxActive="256" maxIdle="5" maxWait="10000"
      removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"
      username="xxx" password="xxx" driverClassName="com.mysql.jdbc.Driver"
      url="jdbc:mysql://host:3306/dbname?autoReconnect=true"
      validationQuery="SELECT 1"
  /&gt;
  </code></pre>
  
  <p>Then later in my service I use:</p>
  
  <pre><code>InitialContext ctx = new InitialContext();
  DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/MyDB");
  Connection db = ds.getConnection(); 
  </code></pre>
  
  <p>For development I want to run Axis2 standalone - is there a way how I could set up somewhere DB connections pool in Axis as well so I would not need to modify service code and use it the same way as with Tomcat?</p>