org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exce

最新推荐文章于 2022-07-20 09:23:48 发布

原创最新推荐文章于 2022-07-20 09:23:48 发布 · 7.1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#exception #nested #query #hibernate #数据库 #mysql

Oracle 10g 专栏收录该内容

33 篇文章

订阅专栏

本文针对出现的InvalidDataAccessResourceUsageException异常，提供了详细的排查步骤，包括检查.hbm.xml文件中的属性与数据库名称是否一致，以及确认hibernate配置文件中的dialect属性是否正确设置。

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
Caused by: java.sql.SQLException: ORA-00933: SQL 命令未正确结束

解决办法：

1. 查看配置 .hbm.xml文件中的属性和数据库中名称是否对应

2. 查看hibernate配置文件，或者application.xml文件中 sessionFactory 属性,或者初始化配置文件中 hibernate.dialect是否和数据库对应

方言是否配置正确。

比如 :

连接 mysql

               <prop key="hibernate.dialect">
                    org.hibernate.dialect.MySQLDialect
                </prop>

连接 oralcle

               <prop key="hibernate.dialect">
                    org.hibernate.dialect.Oracle9Dialect
                </prop>

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

kitajima--

关注关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

SpringBoot,测试插入数据时报:org.springframework.dao.InvalidDataAccessResourceUsageException

qq_45473292的博客

04-30

534

完整错误： org.springframework.dao.InvalidDataAccessResourceUsageException: error performing isolated work; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: error performing isol...

SpringBoot整合Elasticsearch报错

wh柒八九的博客

01-02

1685

本文来记录一下SpringBoot整合Elasticsearch报错文章目录概述概述

1 条评论您还未登录，请先登录后发表或查看评论

org.springframework.dao.InvalidDataAccessApiUsageException

08-20

关于spring与hibernate整合后,出现的常见异常

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query

新成同学

11-08

2万+

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select count(*) as col_0_0_ from NOTICES notices0_ where notices0_.SENDUNIT=北京市药品监督管理局大兴分局机关 order by not

Caused by: java.lang.RuntimeException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at com.sinosoft.application.prpall.kernel.service.spring.GuProductServiceSpringImpl.executeProductModule(GuProductServiceSpringImpl.java:800) at com.sinosoft.application.prpall.kernel.service.spring.GuProductServiceSpringImpl.updateProductModule(GuProductServiceSpringImpl.java:179)

06-27

异常堆栈显示：Causedby:java.lang.RuntimeException:org.springframework.dao.InvalidDataAccessResourceUsageException:couldnotexecutequery;nestedexceptionisorg.hibernate.exception.SQLGrammarException:...

2025-04-02 15:12:38.241 ERROR 17628 --- [ad | producer-1] c.ccssoft.service.KafkaProducerService : 状态更新失败 org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:259) ~[spring-orm-5.3.27.jar:5.3.27]为啥呢数据中的字段就叫issgin 代码@Column(name ="issign") private Integer issign; 为什么还会报错呢

04-03

好的，我现在要解决用户在使用Spring Data JPA时遇到的InvalidDataAccessResourceUsageException异常，特别是涉及SQL语法错误的问题。根据用户提供的引用内容，我需要逐步分析可能的原因和解决方案。首先，用户...

17:37:55 [ - ] [localhost-startStop-1] ERROR: CTPBeanFactory: - 初始化Spring失败： 17:37:55 [ - ] [localhost-startStop-1] ERROR: CTPBeanFactory: - *********************************************** 17:37:55 [ - ] [localhost-startStop-1] ERROR: CTPBeanFactory: - Bean name：secretKeyManage 17:37:55 [ - ] [localhost-startStop-1] ERROR: CTPBeanFactory: - 错误原因：Table 'v8x2.ctp_config' doesn't exist 17:37:55 [ - ] [localhost-startStop-1] ERROR: CTPBeanFactory: - Error creating bean with name 'secretKeyManage' defined in URL [file:/home/Seeyon/A8/ApacheJetspeed/webapps/seeyon/WEB-INF/cfgHome/spring/spring-transSecurity-manage.xml]: Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into ctp_config (config_category, config_category_name, config_description, config_item, config_type, config_value, create_date, modify_date, ext_config_value, org_account_id, SORT, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update 17:37:55 [ - ] [localhost-startStop-1] ERROR: CTPBeanFactory: - Error creating bean with name 'secretKeyManage' defined in URL [file:/home/Seeyon/A8/ApacheJetspeed/webapps/seeyon/WEB-INF/cfgHome/spring/spring-transSecurity-manage.xml]: Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into ctp_config (config_category, config_category_name, config_description, config_item, config_type, config_value, create_date, modify_date, ext_config_value, org_account_id, SORT, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update [code : 1879453577] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'secretKeyManage' defined in URL [file:/home/Seeyon/A8/ApacheJetspeed/webapps/seeyon/WEB-INF/cfgHome/spring/spring-transSecurity-manage.xml]: Invocation of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into ctp_config (config_category, config_category_name, config_description, config_item, config_type, config_value, create_date, modify_date, ext_config_value, org_account_id, SORT, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

07-24

在Spring框架初始化过程中，若出现数据库表`ctp_config`不存在的问题，导致Bean `secretKeyManage`无法创建，这通常与以下原因相关： 1. **数据库表缺失或表名错误**：在Spring配置文件或实体类中，可能指定了需要...

context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [SELECT DISTINCT line.* FROM C_LINE line INNER JOIN ( SELECT @a :=- 1, ? optDeptType, ? optid, ? sAreaId, ? eAreaId, ? claTraType, ? lineIds, ? platform ) param LEFT JOIN C_LINE_OPERATING_COMPANY lo ON lo.LINE_ID = line.ID LEFT JOIN R_OPERATING_COMPANY oc ON oc.ID = lo.OC_ID LEFT JOIN OPERATOR_LINE opli ON opli.OPERATOR_ID = param.optid AND opli.LINE_ID = line.ID WHERE ( SELECT ( param.optDeptType = 4 || param.optDeptType = 3 && line.PLATFORM = ext.PLATFORM || ( param.optDeptType = 1 && ( FIND_IN_SET( oc.DEPT_ID, IF ( @a =- 1, @a := FIND_CHILDREN_OF_DEPT ( dept.ID ), @a ) ) && opli.OPERATOR_ID IS NULL || opli.IS_INVERSE = 0 ) ) ) FROM U_OPERATOR opt LEFT JOIN U_DEPT dept ON dept.ID = opt.DEPT_ID LEFT JOIN DEPT_EXTEND ext ON ext.ID = dept.ID WHERE opt.id = param.optid ) AND IF ( param.sAreaId = - 1, TRUE, line.START_AREA_ID = param.sAreaId ) AND IF ( param.eAreaId = - 1, TRUE, line.END_AREA_ID = param.eAreaId ) AND IF ( param.claTraType = - 1, TRUE, param.claTraType = line.type ) AND IF ( param.lineIds = '-1', TRUE, FIND_IN_SET(line.ID, param.lineIds) ) AND IF ( param.platform = - 1, TRUE, param.platform = line.PLATFORM ) ORDER BY line.SORT DESC]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query] with root cause java.sql.SQLException: Column 'LEVEL' not found.