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

緣由:java

這個問題的解決方案很簡單,主要是由於數據庫中不存在相關的表或者列。spring

 

 

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 queryui

.TransactionRequiredException: Executing an update/delete queryspa

我想寫update語句,可是一直報錯因而加了三個兩個東西hibernate

@Transactional @Modifying我那個帳號沒有權限,我把表drop掉從新建也沒仔細看哎,查了一個多小時