C3P0 тестовое соединение при оформлении не работает ⇐ MySql

[Anonymous]

Есть идеи, почему я получаю «недействительные» соединения из бассейна? < /p>
Использование: < /p>
mysql-connector-java-5.1.49.jar
c3p0-0.11.2.jar
Java 8
< /code>
c3p0 config: < /p>
pool.setJdbcUrl(url);
pool.setUser(user);
pool.setPassword(password);
pool.setTestConnectionOnCheckout(true);
< /code>
Тем не менее, после периода бездействия соединение MySQL, возвращаемое из пула, является недействительным!Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 44.587.068 milliseconds ago. The last packet sent successfully to the server was 44.587.069 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing 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.
jul 23 14:54:19 dev-server services[811]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
jul 23 14:54:19 dev-server services[811]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
jul 23 14:54:19 dev-server services[811]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
jul 23 14:54:19 dev-server services[811]: at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
jul 23 14:54:19 dev-server services[811]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
jul 23 14:54:19 dev-server services[811]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
jul 23 14:54:19 dev-server services[811]: at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3706)
jul 23 14:54:19 dev-server services[811]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2506)
jul 23 14:54:19 dev-server services[811]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
jul 23 14:54:19 dev-server services[811]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
jul 23 14:54:19 dev-server services[811]: at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4776)
jul 23 14:54:19 dev-server services[811]: ... 6 more
jul 23 14:54:19 dev-server services[811]: Caused by: java.net.SocketException: Túnel quebrado (Write failed)
jul 23 14:54:19 dev-server services[811]: at java.net.SocketOutputStream.socketWrite0(Native Method)
jul 23 14:54:19 dev-server services[811]: at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
jul 23 14:54:19 dev-server services[811]: at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
jul 23 14:54:19 dev-server services[811]: at sun.security.ssl.SSLSocketOutputRecord.deliver(SSLSocketOutputRecord.java:341)
jul 23 14:54:19 dev-server services[811]: at sun.security.ssl.SSLSocketImpl$AppOutputStream.write(SSLSocketImpl.java:1106)
jul 23 14:54:19 dev-server services[811]: at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
jul 23 14:54:19 dev-server services[811]: at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
jul 23 14:54:19 dev-server services[811]: at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3688)


Подробнее здесь: https://stackoverflow.com/questions/797 ... ot-working