情曩:
在WAS7.0里配置好Mysql数据源之后,测试正常。在服务刚启动时,数据均是可用。
隔10来分钟或者以上时间之后,就会出现:
[5/18/15 22:58:34:789 CST] 0000001f ConnectionEve W J2CA0206W: A connection error occurred. To help determine the problem, enable the Diagnose Connection Usage option on the Connection Factory or Data Source. This is the multithreaded access detection option. Alternatively check that the Database or MessageProvider is available.
[5/18/15 22:58:34:800 CST] 0000001f ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adapter for resource MySQLForCloud. The exception is: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 2,307,073 milliseconds ago. The last packet sent successfully to the server was 926,645 milliseconds ago.:java.net.SocketException: Connection timed out
[5/18/15 22:58:36:706 CST] 0000001f ThreadMonitor W WSVR0606W: Thread "SIBJMSRAThreadPool : 0" (0000001f) was previously reported to be hung but has completed. It was active for approximately 928620 milliseconds. There is/are 0 thread(s) in total in the server that still may be hung.
然后就……没有然后了。
关于重连的几个参数都设置True:
autoReconnect true
autoReconnectForConnectionPools true
autoReconnectForPools true
如果不改变Mysql端的配置情况下,请教大伙们还有其它办法吗?谢谢