com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException
MESSAGE: Connection resetSTACKTRACE:java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1910)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:501)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:971)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.cdjj.wangcong.unit.BaseDao.getConnection(BaseDao.java:39)
at com.cdjj.wangcong.unit.BaseDao.executeNonQuery(BaseDao.java:76)
at com.cdjj.wangcong.model.UserInfoModel.addUser(UserInfoModel.java:18)
at com.cdjj.wangcong.test.UserInfoTest.main(UserInfoTest.java:12)
** END NESTED EXCEPTION **Last packet sent to the server was 100 ms ago.
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:569)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:971)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.cdjj.wangcong.unit.BaseDao.getConnection(BaseDao.java:39)
at com.cdjj.wangcong.unit.BaseDao.executeNonQuery(BaseDao.java:76)
at com.cdjj.wangcong.model.UserInfoModel.addUser(UserInfoModel.java:18)
at com.cdjj.wangcong.test.UserInfoTest.main(UserInfoTest.java:12)
Exception in thread "main" java.lang.NullPointerException
at com.cdjj.wangcong.unit.BaseDao.executeNonQuery(BaseDao.java:80)
at com.cdjj.wangcong.model.UserInfoModel.addUser(UserInfoModel.java:18)
at com.cdjj.wangcong.test.UserInfoTest.main(UserInfoTest.java:12)
请问这个异常怎么解决?
MESSAGE: Connection resetSTACKTRACE:java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1910)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:501)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:971)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.cdjj.wangcong.unit.BaseDao.getConnection(BaseDao.java:39)
at com.cdjj.wangcong.unit.BaseDao.executeNonQuery(BaseDao.java:76)
at com.cdjj.wangcong.model.UserInfoModel.addUser(UserInfoModel.java:18)
at com.cdjj.wangcong.test.UserInfoTest.main(UserInfoTest.java:12)
** END NESTED EXCEPTION **Last packet sent to the server was 100 ms ago.
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:569)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:971)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2644)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.cdjj.wangcong.unit.BaseDao.getConnection(BaseDao.java:39)
at com.cdjj.wangcong.unit.BaseDao.executeNonQuery(BaseDao.java:76)
at com.cdjj.wangcong.model.UserInfoModel.addUser(UserInfoModel.java:18)
at com.cdjj.wangcong.test.UserInfoTest.main(UserInfoTest.java:12)
Exception in thread "main" java.lang.NullPointerException
at com.cdjj.wangcong.unit.BaseDao.executeNonQuery(BaseDao.java:80)
at com.cdjj.wangcong.model.UserInfoModel.addUser(UserInfoModel.java:18)
at com.cdjj.wangcong.test.UserInfoTest.main(UserInfoTest.java:12)
请问这个异常怎么解决?
解决方案 »
- 怎么用sql语句根据ID逐条替换内容?
- 【不懂就要问】请教一条sql 语句
- mysql同一连接多线程问题
- 请教一个mysql查询语句,在线等,万分感谢!
- mysql错误“multiple-step operation generated error.....”究竟能不能解决啊
- 关于按字母检索有人知道么?
- 登录用户之间可以复用这些内存?
- my.cnf一定要存在c盘根目录下吗?
- 怎样得到一个数据库中的所有表的表结构?--分可以加的.----
- (求mysql高手)如何批量更新n条记录的某一个字段值的和=固定值!
- 装了个php环境套件phpnow,就把mysql一起装上了,可是我不知如何用呀?
- 系统究竟允许存在多少个内存表
建议:获取用户连接后,执行下述两个语句:
set wait_timeout=1073742824
set interactive_timeout=1073742824
以保持长连接。
1. 网络不稳定。
2,MYSQL 漏洞。