Could not execute JDBC batch update; SQL [delete from role where roleId=?]; constraint [null]; neste

た入场券 2021-09-17 06:56 173阅读 0赞

今天在写多个删除功能的时候出现了这么一个错误：**意思是删除操作的时候，没有找到对应的外键。**

Cannot delete or update a parent row: a foreign key constraint fails (`ssh03`.`role_privilege`, CONSTRAINT `FK45FBD628F05C38CB` FOREIGN KEY (`role_id`) REFERENCES `role` (`roleId`)) Cannot delete or update a parent row: a foreign key constraint fails (`ssh03`.`role_privilege`, CONSTRAINT `FK45FBD628F05C38CB` FOREIGN KEY (`role_id`) REFERENCES `role` (`roleId`)) Could not execute JDBC batch update Could not execute JDBC batch update; SQL [delete from role where roleId=?]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [delete from role where roleId=?]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

在网上找了很久，都没有找到对应的错误。。**我的删除操作是先查找Role对象，再通过删除它**。

后来debug起来又是匪夷所思的：**后台能够得到外界传递过来的id**

![这里写图片描述][SouthEast]

**在查询对象的时候，就死活查不了外键的数据【让我搞了很久很久】。。**

![这里写图片描述][SouthEast 1]

**最后发现id上多了一个空格**？？？？？？？至于为什么多了一个空格，，我现在还不知道。。。**于是把空格去掉，就解决这个bug了**。。。

/*批量删除*/
        public String deleteSelect() {
            for (String s : selectedRow) {
    
                roleServiceImpl.delete(s.trim());
            }
            return "list";
        }

….**如果知道为什么会多出一个空格的，请在评论下告诉我**….

[SouthEast]: /images/20210827/d5f160615dd545aa8260a20763ee9900.png
[SouthEast 1]: /images/20210827/d4c073a369554a3399fb4c19669848f0.png

Could not execute JDBC batch update; SQL [delete from role where roleId=?]; constraint [null]; neste

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Could not open JDBC Connection for transaction； nested exception is java.sql.SQLNonTransientConnecti

相关 org.hibernate.exception.SQLGrammarException:Could not execute JDBC batch update异常的解决

相关 Could not execute SQL statement.

相关 “could not execute statement； SQL [n/a]； nested exception is org.hibernate.exception.SQLGrammarExce

相关 nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

相关 Exception executing batch: org.hibernate.StaleStateException: Batch update returned unexpected row

相关 could not execute JDBC batch update;

相关 Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not

相关 org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested

相关 Could not execute JDBC batch update; SQL [delete from role where roleId=?]; constraint [null]; neste