mysql的连接一直很2B，以前是过段时间会中断连接。
现在是一启动就报错。
主要的解决办法就是在连接池（我用的是Druid）上下功夫。
在连接时，它会有一个检测的配置：
大致如下：
testValiation=select 1
testOnBorrow=true
refurl:http://nkcoder.github.io/blog/20140712/mysql-reconnect-packet-lost/
wandejun1012
- 浏览: 2689902 次
- 性别:
- 来自: 上海
-
文章分类
- 全部博客 (1313)
- JS (65)
- CSS (6)
- html (30)
- dweamweaver工具相关 (2)
- Spry (1)
- DB (103)
- p2p (1)
- java (405)
- .net (3)
- oracle (24)
- struts (18)
- myeclipse (15)
- linux (49)
- SQL SERVER2008 (101)
- jsp (21)
- resume (1)
- other (1)
- ajax (3)
- 云计算 (2)
- excel (32)
- vss (1)
- 警戒 (1)
- eclipse (21)
- c (1)
- dialog designer (7)
- axis1.4 (4)
- webservice (11)
- CTI (1)
- svn (8)
- spring (27)
- tomcat (13)
- log4j (14)
- 网络应用 (7)
- mysql (59)
- bat (4)
- jdbc (1)
- 正式表达式 (1)
- hibernate (27)
- iphone (2)
- 系统应用 (107)
- servlet (3)
- vmware (2)
- php (12)
- JQuery (30)
- avaya (5)
- postgresql (19)
- java面试 (1)
- rose (1)
- Socket (1)
- xml (2)
- PowerDesign (3)
- visio (1)
- jstl (4)
- informix (2)
- assemble (2)
- English Study (2)
- IOS (9)
- CMMI (1)
- outlook (4)
- poi (1)
- hadoop (5)
- SAE (3)
- jor (1)
- jquery mobile (1)
- git (11)
- mina (1)
- ibatis (2)
- wordpress (2)
- 支付宝 (1)
- struts2 (14)
- apns (1)
- html5 (1)
- xampp (2)
- uml (2)
- 项目管理 (1)
- 敏捷开发 (1)
- 设计模式 (2)
- spark (1)
- maven (9)
- 微信公众平台 (1)
- json (2)
- junit (1)
- quartz (2)
- redis (2)
- memcache (1)
- android (3)
- 红杏 (1)
- postman (1)
- mybatis (5)
- iplat4j (1)
- windows (1)
- logback (1)
- Netty (1)
- wiki (1)
- dubbo (1)
- sonar (2)
- jenkins (2)
- mac (10)
- office (4)
- groovy (1)
- intellij (6)
- zookeeper (2)
- 诛仙 (1)
- MQ (2)
- docker (1)
- 2222 (0)
最新评论
-
代码改变生活：
虽然代码敲的头疼的要命,但是依然要感谢你,感谢您共享!!!!开 ...
jxl读取excel日期相差8小时 -
www3837：
org.slf4j.Logger 下载 -
hyztty：
wait_timeout = 86400 interacti ...
druid连接池 -
niaodanwangzi：
连接池可不是给你检测连接状态用的。是为了连接复用，减少连接数。 ...
druid连接池 -
supermine0903：
学习了 啦啦啦
多个路由器同时上网
分享到：
发表评论
-
MySQL中有唯一性约束的列能否为null
2017-01-16 14:55 1356唯一索引中允许有null. 参考链接 ... -
Error : Invalid ON UPDATE clause for 'update_time' column
2017-01-16 14:53 7989这是因为mysql版本低导致的，只有5.5的会有这个问 ... -
mysql read innitial packet
2016-12-10 12:05 1012这是mysql PXC集群垮了的原因 我 ... -
druid连接池
2016-09-14 16:00 5103环境：Ubuntu+Mysql5.5 近期一直报 ... -
mysql 用户设置/取消权限
2016-08-30 10:10 1196#设置权限 grant select,ins ... -
ubuntu MySQL搭建全过程
2016-03-09 21:33 759环境：ubuntu 步骤： 1、利用sudo - ... -
mysql date_sub函数
2016-01-10 16:08 1518DATE_SUB(date,INTERVAL expr ... -
mysql 截串 判断字段包含
2015-10-29 10:05 10201、mysql截串用substring就行。 ... -
Data truncation: Incorrect dateti me value: '' for column
2015-08-02 01:08 2017原因是mysql从5.0版本升级到5.6造成的。 ... -
mysql 高可用架构 MHA
2015-07-26 23:33 1079http://51power.blog.51ct ... -
数据库隔离级别
2015-02-08 21:49 0事务（transaction）是数据库管理系统的执行单 ... -
ibatis # $ 区别
2015-02-08 21:07 0#是用来变量替换的，相当于sql中的?. $ ... -
分布式事务
2015-02-08 20:40 970当我们在生产线上用一台服务器来提供数据服务的时候，我会 ... -
mysql 存储过程
2015-01-28 12:02 8531、要想查看存储过程，用如下命令： show cr ... -
xampp Access denied for user 'root'@'localhost'
2015-01-27 14:25 1199这个原因就是mysql的密码被更改的原因所致。 ... -
You can't specify target table 'tb_car_profile' for update in FROM clause
2014-12-15 11:09 1215mysql中You can't specify ta ... -
mysql修改字段名
2014-10-08 01:55 767修改字段名 alter table testtab ... -
mysql快速删除数据
2014-09-05 22:55 866truncate table 表名，同sqlserve ... -
column count doesn't match value count at row 1
2014-09-03 10:10 741开发中运行mysql脚本，发现提示mysql提示Col ... -
mysql varchar 中文
2014-08-28 00:11 1007在mysql中，如果是UTF8编码，那么varchar ...
相关推荐
@[Android studio通过jdbc连接mysql基本步骤 以及 遇到的坑“The last packet sent successfully to the server was 0 milliseconds ago”哈哈] 小白第一次发博客哈哈，记录一下这三个晚上来我的悲惨经历以及我成功...
2.查看数据库表创建完成后，我们可以查看数据库表show tables 2.修改表记录2.1 不带条件的update 表名 set 字段名=值, 字段名=值,
Cause com.mysql.jdbc.exceptions.jdbc4.CommunicationsException The last packet successfully received from the server was 47,795,922 milliseconds ago. The last packet sent successfully to the server was...
融合多个面上光强信息的混合迭代相位恢复算法
The last packet successfully received from the server was 56,201,339 milliseconds ago. The last packet sent successfully to the server was 56,201,339 milliseconds ago. is longer than the server ...
An ISP earns its money by charging each of the the ISPs that connect to the IXP a relatively small fee, which may depend on the amount of traffic sent to or received from the IXP. 15. Google's ...
BPF
一本介绍linux协议栈数据包处理过程的很好的文档
PF: The OpenBSD Packet Filter 官方 PF FAQ
Predictable 802.11 Packet Delivery from Wireless Channel Measurements
compose up 请注意，第一次运行时，您可能会看到： mvw_flyway | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. (Caused by...
The OpenBSD Packet Filter.pdf The OpenBSD Packet Filter.pdf
It’s easy to capture packets with Wireshark, the world’s most popular network sniffer, whether off the wire or from the air. But how do you use those packets to understand what’s happening on your ...
• Does the interface prevent a rogue application from "hijacking" the tablet, or causing dead¬locks? • Does the sharing architecture promote efficiency? 2.4 Tablet Feature Support The interface ...
The Practical Packet Analysis course is perfect for beginners to intermediate analysts, but seasoned pros will probably learn a few useful techniques too. Whether you’ve never capture packets before ...
The "ptsaplayer.dll" in the .zip package is the patch to fix the issue that Packet Tracer 7.2.2's PTSAPlayer plugin does not work on Windows 7. Apply the patch will fix the issue. Only users using...
Cisco Packet Tracer 7.2.2 removes the Java dependence and makes it easier to use Packet Tracer Skills Assessment (PTSA) and Packet Tracer Media Objects (PTMO) : After installing Packet Tracer 7.2.2...
This is the release notice for the PCnet Magic Packet(TM) Utility Revision 1.00 software. All files are in DOS FAT format. AMD抯 Magic Packet utility is a convenient tool for system administrators ...
The "ptsaplayer.dll" in the .zip package is the patch to fix the issue that Packet Tracer 7.2.2's PTSAPlayer plugin does not work on Windows 7. Apply the patch will fix the issue. Only users using...
Standard file transfer protocols simply chop a file up into K packetsized pieces, then repeatedly transmit each packet until it is successfully received. A back channel is required for the ...