mysql重连,连接丢失
来源:互联网 发布:软件类上市公司 编辑:程序博客网 时间:2024/05/16 12:50
报错内容:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure
Last packet sent to the server was 0 msago.
atsun.reflect.GeneratedConstructorAccessor98.newInstance(Unknown Source) ~[na:na]
atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)~[na:1.7.0_80]
atjava.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)~[MySQL-connector-java-5.1.jar:na]
atcom.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)~[MySQL-connector-java-5.1.jar:na]
解决办法:
如果使用Spring的DBCP连接池,在datasource中增加属性validationQuery和testOnBorrow,如:
<bean id="vrsRankDataSource"class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close">
<property name="driverClassName"value="${jdbc.driverClassName}" />
<property name="url" value="${countNew.jdbc.url}"/>
<property name="username"value="${countNew.jdbc.user}" />
<property name="password"value="${countNew.jdbc.pwd}" />
<property name="validationQuery" value="SELECT 1"/>
<property name="testOnBorrow" value="true"/>
</bean>
如果使用Spring的c3p0连接池,在datasource中添加属性testConnectionOnCheckin和testConnectionOnCheckout,如:
<bean name="cacheCloudDB"class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass"value="${jdbc.driver}"/>
<property name="jdbcUrl"value="${cache.url}"/>
<property name="user" value="${cache.user}"/>
<property name="password"value="${cache.password}"/>
<property name="initialPoolSize" value="10"/>
<property name="maxPoolSize"value="${cache.maxPoolSize}"/>
<property name="testConnectionOnCheckin" value="false"/>
<property name="testConnectionOnCheckout"value="true"/>
<property name="preferredTestQuery" value="SELECT1"/>
</bean>
- mysql重连,连接丢失
- MySQL重连,连接丢失问题解决
- mysql重连,连接丢失:The last packet successfully received
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- 【转】mysql重连,连接丢失:The last packet successfully received
- mysql重连,连接丢失:The last packet successfully received from the server
- c3p0数据库连接池死锁问题和mysql重连,连接丢失
- mysql重连,连接丢失:The last packet successfully received from the server--转载
- mysql重连,连接丢失:The last packet successfully received from the server--转载
- MySQL之——重连,连接丢失:The last packet successfully received from the serve
- mysql重连,连接丢失:The last packet successfully received from the server--转载
- mysql重连,连接丢失:The last packet successfully received from the server
- mysql重连,连接丢失:The last packet successfully received from the server
- hibernate连接mysql自动重连
- mysql 连接闪断自动重连的方法
- mysql 自动重连
- if-else 分支预测
- abstract类及其方法
- SolidWorks 部分插件不显示
- C++ Operator Precedence c++运算符优先级列表
- jquery实现的返回顶部+侧边栏功能
- mysql重连,连接丢失
- form下载文件,指向iframe ,如何判断iframe加载完成 form.submit之后的事件问题 监听form表单下载文件是否完成
- Android数据加密之Base64编码算法
- js中replace全部替换的正则表达式
- Android多媒体访问
- caffe相关特殊层解释
- MySQL数据库设计——以学生成绩数据库为例
- [Android]笔记13:改变分割条、基于数据的ListView
- android好用的资源