软件开发WASMySQL

WAS配置MySQL数据源,经常出现Connection timed out

情曩:
在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   

QQ截图20150519143940.jpg



如果不改变Mysql端的配置情况下,请教大伙们还有其它办法吗?谢谢
参与2

1同行回答

fantasy_2099fantasy_2099系统工程师asiainfo
出问题后在控制台测试一把数据源连接看看是否有报错。显示全部
出问题后在控制台测试一把数据源连接看看是否有报错。收起
软件开发 · 2015-05-20
浏览1576

提问者

yydmusic
网站架构师sd
擅长领域: portal中间件

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2015-05-19
  • 关注会员:1 人
  • 问题浏览:3410
  • 最近回答:2015-05-20
  • X社区推广