CK's Developer Blog

My friend was using Tomcat and MySQL database. He had configured a datasource and as his web application was relatively new, users to his website were very less. As a result the connections were timed out after the default timeout period and exceptions were thrown.

One of the solution to avoid this scenario is to add attributes to validate the connection when borrowing.

<Context path="" reloadable="false" docBase="/home/pathtoapp">
 <Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
 maxActive="30" maxIdle="10" maxWait="4000"
 username="username" password="password" driverClassName="com.mysql.jdbc.Driver"
 url="jdbc:mysql://localhost:portnum/dbname" validationQuery="SELECT 1" testOnBorrow="true" />
 </Context>

In web.xml under TOMCAT_HOME/conf edit the configuration for org.apache.catalina.servlets.DefaultServlet as below

<servlet>
<servlet-name>default</servlet-name>
<servlet-class>org.apache.catalina.servlets.DefaultServlet</servlet-class>
<init-param>
<param-name>debug</param-name>
<param-value>0</param-value>
</init-param>
<init-param>
<param-name>listings</param-name>
<param-value>false</param-value>
</init-param>
<init-param>
<param-name>readonly</param-name>
<param-value>true</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>