tomcat mysql dbcp Communications link failure

[Chetouani]

Hello guys,

If you can help with this problem.

I have an application deployed on tomcat V6.18. It uses a mysql database.
The problem is that after some hours the applicatiion throws an exception when 
trying to connect to the data base.

com.mysql.jdbc.CommunicationsException: Communications link failure due to 
underlying exception

I cofigured a data source using dbcp :

<Resource name="jdbc/${database.datasource}" 
        auth="Container"
        type="javax.sql.DataSource" 
        factory="org.apache.commons.dbcp.BasicDataSourceFactory" 
        driverClassName="${database.driver}" 
        url="${database.url}" 
        username="${database.user}"
        password="${database.password}" 
        removeAbandoned="true"
        removeAbandonedTimeout="300"
        logAbandoned="true"
        maxActive="20"
        maxIdle="20"
        maxWait="10000"
        validationQuery="SELECT 1"
        testOnBorrow="true"
        testOnReturn="true"
        testWhileIdle="true"/>

I did some searches and it seems that the problem is that the connection pool 
keeps the connections for a long time even if they are considered dead by mysql

So if you can help

Thanks