I have a little problem with my Pentaho (server) and MySQL. I'm following the Pentaho documentation for change the repository a MySQL.
I'm trying to use a C3PO but the behavior is the same.
The principal error is :
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 71,926,795 milliseconds ago. The last packet se nt successfully to the server was 71,926,796 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testin g connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect =true' to avoid this problem.