Context.xml example with Connecter J PLugin

context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context>

    <!-- maxActive: Maximum number of dB connections in pool. Make sure you
         configure your mysqld max_connections large enough to handle
         all of your db connections. Set to -1 for no limit.
         -->

    <!-- maxIdle: Maximum number of idle dB connections to retain in pool.
         Set to -1 for no limit.  See also the DBCP documentation on this
         and the minEvictableIdleTimeMillis configuration parameter.
         -->

    <!-- maxWait: Maximum time to wait for a dB connection to become available
         in ms, in this example 10 seconds. An Exception is thrown if
         this timeout is exceeded.  Set to -1 to wait indefinitely.
         -->

    <!-- username and password: MySQL dB username and password for dB connections  -->

    <!-- driverClassName: Class name for the old mm.mysql JDBC driver is
         org.gjt.mm.mysql.Driver - we recommend using Connector/J though.
         Class name for the official MySQL Connector/J driver is com.mysql.jdbc.Driver.
         -->
    
    <!-- url: The JDBC connection url for connecting to your MySQL dB.
         -->
   
  <Resource name="jdbc/myDataSource" auth="Container" type="javax.sql.DataSource"
               maxActive="50" maxIdle="10" maxWait="10000"
               username="java" password="iconjava" driverClassName="com.mysql.jdbc.Driver"
               factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
               url="jdbc:mysql://localhost:3306?logger=Slf4JLogger&amp;statementInterceptors=com.mysql.etools.jdbc.StatementPerformanceCounters&amp;serviceManagerUrl=http://MONITORSERVER:PORT&amp;serviceManagerUser=user&amp;serviceManagerPassword=password" 
               testWhileIdle="true"
               testOnBorrow="true"
               testOnReturn="false"
               validationQuery="SELECT 1"
               validationInterval="30000"
               timeBetweenEvictionRunsMillis="5000"
               />
</Context>