java.net.SocketException: Software caused connection abort: socket write error
来源:互联网 发布:四柱汉诺塔 python 编辑:程序博客网 时间:2024/05/18 00:43
项目的后台数据库是Mysql,最近出现了java.net.SocketException: Software causedconnection abort: socket write error 这个异常。
在网上google了一下,都说是因为Mysql服务器默认的“wait_timeout”是8小时,也就是说一个connection空闲如果超过8个小时,Mysql将自动断开该connection。这样就出现了上面这个问题。
网上的解决方法有几种:
第一种:在mysql安装目录下找到my.ini文件中添加超时限制:在该文件最后添加一行:wait_timeout=2880000。这样把之前的超时限制把8小时(28800)扩大为20天(20*24*60*60=1728000)。这样重启了mysql后,再在其中输入命令:show global variables like "wait_timeout"; ,查看超时是否已修改为:1728000。实际操作中,我修改的是C:\WINDOWS目录下的my.ini,这是我的Mysql数据库所使用的描述文件,在该文件的[mysqld]一节中,添加了wait_timeout=1728000。重启mysql后,执行上面的查询,返回的查询结果如下:
mysql> show global variables like "wait_timeout";+---------------+-------------+| Variable_name | Value |+---------------+-------------+| wait_timeout | 1728000 |+---------------+-------------+1 row in set (0.00 sec)
最后,重启tomcat,OK,服务器能正常访问。
第二种,通过c3p0的idleConnectionTestPeriod来控制:可以将它的值设定的比Mysql的默认wait_timeout小就行了。
<property name="idleConnectionTestPeriod" value="18000"/>
使用连接池可以解决这个问题,这里使用c3p0:
修改hibernate.cfg.xml文件
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property><property name="hibernate.c3p0.min_size">8</property><property name="hibernate.c3p0.max_size">200</property><property name="hibernate.c3p0.timeout">600</property><property name="hibernate.c3p0.max_statements">0</property><property name="hibernate.c3p0.idle_test_period">60</property><property name="hibernate.c3p0.acquire_increment">2</property><property name="hibernate.c3p0.validate">true</property>
- java.net.SocketException: Software caused connection abort: socket write error
- java.net.SocketException: Software caused connection abort: socket write error
- java.net.SocketException: Software caused connection abort: socket write error
- java.net.SocketException: Software caused connection abort: socket write error
- Caused by: java.net.SocketException: Software caused connection abort: socket write error。
- Caused by: java.net.SocketException: Software caused connection abort: socket write error
- Caused by: java.net.SocketException: Software caused connection abort: socket write error
- Caused by: java.net.SocketException: Software caused connection abort: socket write error
- 解决Hibernate报java.net.SocketException:Software caused connection abort:socket write error
- testng报错"java.net.SocketException: Software caused connection abort: socket write error"
- testng报错"java.net.SocketException: Software caused connection abort: socket write error"
- 【eclipse_bug_002】java.net.SocketException: Software caused connection abort: socket write error
- testng报错"java.net.SocketException: Software caused connection abort: socket write error"
- [求助]关于java的心跳包程序出现java.net.SocketException: Software caused connection abort: socket write error
- ClientAbortException: java.net.SocketException: Software caused connection abort: socket write erro
- java.net.SocketException: Software caused connection abort
- Software caused connection abort: socket write error
- Software caused connection abort: socket write error
- python基础之元组、列表、集合
- 如何高效、快捷、投入少地学习新的知识
- ReactiveCocoa入门教程:第一部分
- 【Unity】协程原理与线程的区别
- PHP大整数求和
- java.net.SocketException: Software caused connection abort: socket write error
- Result API
- UML类图与类的关系详解
- 选择排序
- SpringMVC源码(八)HandlerInterceptor拦截器
- js判断undefined类型,undefined,null, 的区别详细解析
- 使用chroot搭建Barrelfish应用程序的编译环境
- androidstudio之延时跳转
- HDU 1846 Brave Game 【巴什博奕】