org.hibernate.exception.JDBCConnectionException: could not execute query

最新推荐文章于 2021-03-17 02:26:51 发布
最新推荐文章于 2021-03-17 02:26:51 发布
阅读量2.8k 收藏
点赞数
文章标签： query hibernate server mysql application 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xwdengjie/article/details/2604200
版权

数据库为mysql，客户端使用hibernate进行连接，结果长时间没有数据访问的话，重新访问数据库就会报错：

javax.servlet.ServletException: org.hibernate.exception.JDBCConnectionException: could not execute query
	org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1858)
	com.monet.common.servlet.ExtendActionServlet.process(ExtendActionServlet.java:85)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:459)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

 

root cause 

org.hibernate.exception.JDBCConnectionException: could not execute query
	org.hibernate.exception.SQLStateConverter.convert(Unknown Source)
	org.hibernate.exception.JDBCExceptionHelper.convert(Unknown Source)
	org.hibernate.loader.Loader.doList(Unknown Source)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Unknown Source)
	org.hibernate.loader.Loader.list(Unknown Source)
	org.hibernate.loader.hql.QueryLoader.list(Unknown Source)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(Unknown Source)
	org.hibernate.engine.query.HQLQueryPlan.performList(Unknown Source)
	org.hibernate.impl.SessionImpl.list(Unknown Source)
	org.hibernate.impl.QueryImpl.list(Unknown Source)
	com.monet.ecai.bean.MemberDAO.getUserName(MemberDAO.java:42)
	com.monet.lottery.user.UserAction.doUserReg(UserAction.java:154)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	com.monet.common.servlet.ActionExtend.callActionMethod(ActionExtend.java:214)
	com.monet.common.servlet.ActionExtend.execute(ActionExtend.java:144)
	org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:53)
	org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:64)
	org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:48)
	org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
	org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:280)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1858)
	com.monet.common.servlet.ExtendActionServlet.process(ExtendActionServlet.java:85)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:459)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

 

root cause 

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was55512 seconds ago.The last packet sent successfully to the server was 55512 seconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	java.lang.reflect.Constructor.newInstance(Unknown Source)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
	com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3246)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
	org.hibernate.jdbc.AbstractBatcher.getResultSet(Unknown Source)
	org.hibernate.loader.Loader.getResultSet(Unknown Source)
	org.hibernate.loader.Loader.doQuery(Unknown Source)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Unknown Source)
	org.hibernate.loader.Loader.doList(Unknown Source)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Unknown Source)
	org.hibernate.loader.Loader.list(Unknown Source)
	org.hibernate.loader.hql.QueryLoader.list(Unknown Source)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(Unknown Source)
	org.hibernate.engine.query.HQLQueryPlan.performList(Unknown Source)
	org.hibernate.impl.SessionImpl.list(Unknown Source)
	org.hibernate.impl.QueryImpl.list(Unknown Source)
	com.monet.ecai.bean.MemberDAO.getUserName(MemberDAO.java:42)
	com.monet.lottery.user.UserAction.doUserReg(UserAction.java:154)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	com.monet.common.servlet.ActionExtend.callActionMethod(ActionExtend.java:214)
	com.monet.common.servlet.ActionExtend.execute(ActionExtend.java:144)
	org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:53)
	org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:64)
	org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:48)
	org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
	org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:280)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1858)
	com.monet.common.servlet.ExtendActionServlet.process(ExtendActionServlet.java:85)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:459)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

 

root cause 

java.net.SocketException: Software caused connection abort: socket write error
	java.net.SocketOutputStream.socketWrite0(Native Method)
	java.net.SocketOutputStream.socketWrite(Unknown Source)
	java.net.SocketOutputStream.write(Unknown Source)
	java.io.BufferedOutputStream.flushBuffer(Unknown Source)
	java.io.BufferedOutputStream.flush(Unknown Source)
	com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3227)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
	org.hibernate.jdbc.AbstractBatcher.getResultSet(Unknown Source)
	org.hibernate.loader.Loader.getResultSet(Unknown Source)
	org.hibernate.loader.Loader.doQuery(Unknown Source)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Unknown Source)
	org.hibernate.loader.Loader.doList(Unknown Source)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Unknown Source)
	org.hibernate.loader.Loader.list(Unknown Source)
	org.hibernate.loader.hql.QueryLoader.list(Unknown Source)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(Unknown Source)
	org.hibernate.engine.query.HQLQueryPlan.performList(Unknown Source)
	org.hibernate.impl.SessionImpl.list(Unknown Source)
	org.hibernate.impl.QueryImpl.list(Unknown Source)
	com.monet.ecai.bean.MemberDAO.getUserName(MemberDAO.java:42)
	com.monet.lottery.user.UserAction.doUserReg(UserAction.java:154)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	com.monet.common.servlet.ActionExtend.callActionMethod(ActionExtend.java:214)
	com.monet.common.servlet.ActionExtend.execute(ActionExtend.java:144)
	org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:53)
	org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:64)
	org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:48)
	org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
	org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
	org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:280)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1858)
	com.monet.common.servlet.ExtendActionServlet.process(ExtendActionServlet.java:85)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:459)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
查阅相关文档，造成报错的原因在于：Mysql服务器默认的“wait_timeout”是8小时，也就是说一个connection空闲超过8个小时，Mysql将自动断开该connection。
 
hibernate 配置如下
<property name="hibernate.connection.provider_class">
   org.hibernate.connection.C3P0ConnectionProvider
  </property>
  <property name="hibernate.c3p0.min_size">10</property>
  <property name="hibernate.c3p0.max_size">100</property>
  <property name="hibernate.c3p0.timeout">10</property>
  <property name="hibernate.c3p0.max_statements">100</property>
  <property name="hibernate.c3p0.idle_test_period">300</property>
  <property name="hibernate.c3p0.acquire_increment">5</property>
  <property name="hibernate.c3p0.validate">true</property>
xwdengjie
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
org.hibernate.exception.GenericJDBCException: Cannot open connection解决
qq_45650714的博客
05-17 4926
第二次踩坑了，记录一下 连接数据库的相关配置（jdk1.8连接mysql8.0）： <hibernate-configuration> <session-factory> <!-- 指定方言 --> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <!--数据库驱动 --> <property nam
异常排查 PersistenceException：org.hibernate.exception.GenericJDBCException: could not execute statement
猴戏浅滩的博客
05-28 5372
具体异常信息如下： Unhandled exception: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) at org.hib.
用数据库连接池解决org.hibernate.exception.JDBCConnectionException:could not execute query
bulote
01-28 854
嘚啵嘚嘚啵嘚. ---幸运皮 我想来想去,还是要说一下问题出现的情景,吼吼~ 本来运行不错,后来老师跟我说,每次早上去上班访问网站的时候就会出现这个问题,重启一下tomcat就好了,等第二天就又出现这样的问题. 后来我查了一下,原来是数据库连接超时的问题,但是,第一次改好后,我以为改好了,因为要等一天的时间(至少是8个小时)去验证呢,结果,过了两天,老师来邮件说,不行,还是那样. 后...
从数据库方面解决org.hibernate.exception.JDBCConnectionException:could not execute query
bulote
01-27 856
世界很美好,感谢身边的一切. ---幸运皮 或者是报错:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communicationslink failure 网站部署好之后是可以好好运行的,但是,总是隔一段时间就会报org.hibernate.exception.JDBCConnectionException:could n...
mysql could not execute query,org.hibernate.exception.JDBCConnectionException: could not execute que...
weixin_39609953的博客
03-17 313
最近的一个项目在Hibernate使用C3P0的连接池，数据库为Mysql。开发测试没有问题，在运行中每个一段长的空闲时间就出现异常:org.hibernate.exception.JDBCConnectionException:couldnotexecutequeryatorg.hibernate.exception.SQLStateConverter.convert(SQLStat...
MySQL+Hibernate下连接空闲8小时自动断开问题解决方案.docx
09-13
在本文中，出现了一个javax.servlet.ServletException: org.hibernate.exception.JDBCConnectionException 异常，这是由于连接idle时间太长导致的。这个异常是 Hibernate 在试图执行查询时抛出的，表示JDBC 连接已经...
MySQL数据库服务器下C3P0连接池的配置.pdf
10-10
项目的应用程序部署好后，每过一段时间（比如一个晚上），应用程序没有被调用，然后一旦程序访问MySQL数据库就会抛出异常：java代码org.hibernation.exception.JDBCConnectionException：could not execute query。...
Hibernate配置常见错误
08-13
错误表现：如“org.hibernate.exception.JDBCConnectionException: Cannot open connection”，表明Hibernate无法建立与数据库的连接。 解决方案：检查数据库URL、用户名和密码是否正确。此外，还需确认数据库服务...
Oracle：org.hibernate.exception.JDBCConnectionException: could not execute query
zhanqizi的专栏
01-12 780
前段时间做省市区街道的导入，用的Oracle数据库，批量添加然后就时不时的报org.hibernate.exception.JDBCConnectionException: could not execute query这个错，特别的郁闷，代码没有任何问题，数据量过多就会一直报错，找了很多资料都说跟Spring的配置有关。最后在 添加了  此行就好了。   记录下。
服务器开发之MySQL（JAVA）could not execute query
oneym
11-05 4164
作者:oneym 本文地址：一、前言数据库是服务器开发必不可少的一个基本环节，可是数据开发遇到了问题怎么办？这里就是记一个MySQL错误的解决方案。MySQL的wait_timeout默认值是8小时，这次就错在了这。二、问题回顾项目写成，测试运行正常，在运行的过程中会随机时间出现如下报错:org.springframework.dao.DataAccessResourceFailureExcept
org.hibernate.exception.SQLGrammarException: could not execute query
davidtps的专栏
11-04 1万+
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) at org.hibernate.excep
org.hibernate.exception.JDBCConnectionException: could not execute queryMySQL数据库连接超时
云淡风轻的博客
04-30 7699
最近写了一个报名的小页面放在了服务器上，早上访问的时候竟然发现又出现了错误： 1.org.hibernate.exception.JDBCConnectionException: could not execute query 2.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet success 3.java.net.SocketException: Software caused connection abor
org.hibernate.exception.GenericJDBCException: could not execute statement
热门推荐
墨笙弘一
05-08 1万+
在用hibernate的时候，可能会存在错误的用法，导致报下面的这种错误：org.hibernate.exception.GenericJDBCException: could not execute statement错误信息如下：org.hibernate.exception.GenericJDBCException: could not execute statement at org.hib
GenericJDBCException: could not execute statement 错误解决
dinghaoxiao5125的博客
09-19 6755
"message":"could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement","status":"500" 1.数据库表主键未设置自增 2.数据库表类型与代码中的数据类型不相同 转...
could not prepare statement; nested exception is org.hibernate.exception.JDBCConnectionException: could not prepare statement
最新发布
07-28
引用\[1\]:根据您提供的引用内容，报错信息显示为"could not prepare statement; nested exception is org.hibernate.exception.JDBCConnectionException: could not prepare statement"。这个错误通常与SQL语句执行时的问题有关。\[3\]根据官方文档的解释，@Modifying和@Transactional注解可以用于修改查询方法，而不是将其注释到域类上。@Modifying注解只在与@Query注解结合使用时才相关。这个错误可能是由于SQL语句的问题导致的。您可以检查SQL语句是否正确，并确保使用了正确的注解来执行查询。如果问题仍然存在，您可能需要进一步排查数据库连接的问题。 #### 引用[.reference_title] - *1* *3* [jpa语句：nested exception is org.hibernate.exception.GenericJDBCException: could not extract ...](https://blog.csdn.net/qq_42818496/article/details/107608978)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item] - *2* [org.hibernate.exception.JDBCConnectionException:could not execute query原因及解决方法](https://blog.csdn.net/liuyingan/article/details/84364289)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control_2,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值