Techie:Techie Main/Java/Tomcat/Connection Pool

Define pool in conf/context.xml

<Resource name="jdbc/FantacyDS"
       auth="Container"
       type="javax.sql.DataSource"
       maxActive="10"
       maxIdle="3"
       maxWait="10000"
       username="xxxx"
       password="yyyy"
       driverClassName="com.mysql.jdbc.Driver"
       validationQuery="SELECT 1"
       url="jdbc:mysql://localhost/fantacy?autoReconnect=true"/>