Hi David,
Our system user want to let the display show the data from MySQL and refresh every 10milliseconds, and display some data for 100 targets.
The system connects the MySQL and works well for he first days, but over that will show error window and information on Log file:
-------
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 68,681,684 milliseconds ago. The last packet sent successfully to the server was 68,681,685 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.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3661)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2417)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4846)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
at tersus.runtime.RuntimeContext.getConnection(RuntimeContext.java:1056)
... 35 more
Caused by: java.net.SocketException: Software caused connection abort: socket write error
-------------
As checked online that the connection stoped so we added "autoReconnect=true&failOverReadOnly=false" in the Tomcat xml file:
...
url="jdbc:mysql://127.0.0.1:3306/n160?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false"/>
but still have the errors, any problems with my setting information?
Thanks.
Best Regards.
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign
