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

原因:

这个问题的解决方案很简单,主要是因为数据库中不存在相关的表或者列。

org.springframework.dao.InvalidDataAccessApiUsageException: Parameter with that position [1] did not exist; nested exception is java.lang.IllegalArgumentException: Parameter with that position [1] did not exist

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select * from xxx]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Caused by: javax.persistence.TransactionRequiredException: Executing an update/delete query

.TransactionRequiredException: Executing an update/delete query

我想写update语句,但是一直报错于是加了三个两个东西

@Transactional
@Modifying 我那个账号没有权限,我把表drop掉重新建也没仔细看
哎,查了一个多小时
上一篇:报错:org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement


下一篇:android删除无用资源文件的python脚本