[opencms-dev] java.sql.SQLException: Communication link failure

[Andras Balogh]

Hello,

Try to set the option "autoReconnect=true" on the connection  URL,
see more details here:
http://dev.mysql.com/doc/connector/j/en/cj-configuration-properties.html

Best regards,
Andras.

Lopez Jarillo, Cesar wrote:

> Hello all,
>  
> I'm having randomly a problem whe the jsp pages try to connect with 
> the mysql database.
>  
> I see this error at the log file
>  
> com.opencms.core.CmsException: 4 Sql exception. Detailed error: 
> [com.opencms.file.mySql.CmsDbAccess] Communication link failure: 
> java.net.SocketException.
> root cause was java.sql.SQLException: Communication link failure: 
> java.net.SocketException.
> root cause was com.opencms.core.CmsException: 4 Sql exception. 
> Detailed error: [com.opencms.file.mySql.CmsDbAccess] Communication 
> link failure: java.net.SocketException.
> root cause was java.sql.SQLException: Communication link failure: 
> java.net.SocketException
>  
> I'm using opencms 5.0.1 with Tomcat 4.1.30 and MySQL 4.0.23
>  
> I've tried to increase the timeout at the mysql connection-pool 
> (opencms.properties), but the problem persist randomly