| 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 <2016> 2017 2018 2019 2020 2021 2022 2023 2024 2025 | Index | 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 <2016> 2017 2018 2019 2020 2021 2022 2023 2024 2025 |
| <== Date ==> | <== Thread ==> |
|---|
| Subject: | Question about Archive Engine |
| From: | lzfneu <[email protected]> |
| To: | "[email protected]" <[email protected]> |
| Date: | Fri, 13 May 2016 05:11:01 +0000 |
|
hi,
I encounter a problem when archive engine takes the data from ioc via channel access and place the data to mysql database. Here is the details in termintor window: ... Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 65,099,938 milliseconds ago. The last packet sent successfully to the server was 65,099,971 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. ... It seems the connection is timeout. I have downloaded the mysql-connector-java-5.1.39.tar.gz, unzip it and add CLASSPATH to the mysql-connector-java-5.1.39-bin.jar in the .bashrc file. I am not quite familar with JAVA and my question is, according to the tips in terminal window, where to set the Connector/J connection property 'autoReconnect=true' to avoid this problem. Any help will be appreciate and thanks in advance ! Zhefu |