异常之 - java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign

最新推荐文章于 2024-04-17 13:00:00 发布
最新推荐文章于 2024-04-17 13:00:00 发布
阅读量2.4k 收藏
点赞数
分类专栏： spring 异常 mysql 文章标签： java sql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/caijibaindashen/article/details/124852104
版权

异常原因：

java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign

外键不存在，而添加到表当中

2022-05-18 11:17:57.910 ERROR 3936 --- [nio-8080-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: 
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`videowebsite`.`video_actors_table`, CONSTRAINT `video_actors_table_ibfk_1` FOREIGN KEY (`v_id`) REFERENCES `videodetails` (`id`) ON DELETE CASCADE)
### The error may exist in com/ll/videowebsite/mapper/VideoDetailsMapper.java (best guess)
### The error may involve com.ll.videowebsite.mapper.VideoDetailsMapper.insertActor-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO video_actors_table VALUES(NULL, ?, ?)
### Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`videowebsite`.`video_actors_table`, CONSTRAINT `video_actors_table_ibfk_1` FOREIGN KEY (`v_id`) REFERENCES `videodetails` (`id`) ON DELETE CASCADE)
; Cannot add or update a child row: a foreign key constraint fails (`videowebsite`.`video_actors_table`, CONSTRAINT `video_actors_table_ibfk_1` FOREIGN KEY (`v_id`) REFERENCES `videodetails` (`id`) ON DELETE CASCADE); nested exception is java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`videowebsite`.`video_actors_table`, CONSTRAINT `video_actors_table_ibfk_1` FOREIGN KEY (`v_id`) REFERENCES `videodetails` (`id`) ON DELETE CASCADE)] with root cause

java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`videowebsite`.`video_actors_table`, CONSTRAINT `video_actors_table_ibfk_1` FOREIGN KEY (`v_id`) REFERENCES `videodetails` (`id`) ON DELETE CASCADE)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) ~[mysql-connector-java-8.0.28.jar:8.0.28]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.28.jar:8.0.28]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.28.jar:8.0.28]
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371) ~[mysql-connector-java-8.0.28.jar:8.0.28]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-4.0.3.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) ~[mybatis-3.5.9.jar:3.5.9]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_101]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_101]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_101]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar:2.0.7]
	at com.sun.proxy.$Proxy61.insert(Unknown Source) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) ~[mybatis-spring-2.0.7.jar:2.0.7]
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) ~[mybatis-3.5.9.jar:3.5.9]
	at com.sun.proxy.$Proxy77.insertActor(Unknown Source) ~[na:na]
	at com.ll.videowebsite.service.impl.VideoDetailsServiceImpl.insert(VideoDetailsServiceImpl.java:47) ~[classes/:na]
	at com.ll.videowebsite.service.impl.VideoDetailsServiceImpl$$FastClassBySpringCGLIB$$c4a3d826.invoke(<generated>) ~[classes/:na]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.16.jar:5.3.16]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783) ~[spring-aop-5.3.16.jar:5.3.16]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.16.jar:5.3.16]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753) ~[spring-aop-5.3.16.jar:5.3.16]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.16.jar:5.3.16]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.16.jar:5.3.16]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.16.jar:5.3.16]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.16.jar:5.3.16]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753) ~[spring-aop-5.3.16.jar:5.3.16]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698) ~[spring-aop-5.3.16.jar:5.3.16]
	at com.ll.videowebsite.service.impl.VideoDetailsServiceImpl$$EnhancerBySpringCGLIB$$cb9b085.insert(<generated>) ~[classes/:na]
	at com.ll.videowebsite.controller.VideoDetailsController.insert(VideoDetailsController.java:56) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_101]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_101]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_101]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-5.3.16.jar:5.3.16]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) ~[spring-web-5.3.16.jar:5.3.16]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) ~[spring-webmvc-5.3.16.jar:5.3.16]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.16.jar:5.3.16]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.16.jar:5.3.16]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.16.jar:5.3.16]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067) ~[spring-webmvc-5.3.16.jar:5.3.16]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) ~[spring-webmvc-5.3.16.jar:5.3.16]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.16.jar:5.3.16]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.3.16.jar:5.3.16]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) ~[tomcat-embed-core-9.0.58.jar:4.0.FR]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.16.jar:5.3.16]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) ~[tomcat-embed-core-9.0.58.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.3.16.jar:5.3.16]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.16.jar:5.3.16]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.3.16.jar:5.3.16]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.16.jar:5.3.16]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.16.jar:5.3.16]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.16.jar:5.3.16]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) ~[tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1735) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.58.jar:9.0.58]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101]

解决方法：

  1. 修改数据库信息，添加必要的数据
caijibiandashen
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
eureka nacos 多注册中心时ribbon报错
qq_42154996的博客
08-20 463
2021-08-20 21:56:14.012 ERROR 221336 --- [nio-8081-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Handler dispatch failed; nested exception is java.lang.Abstract..
Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row:
12-14
网上查了很多，都说不满足主键约束啥的等等都没解决，我的问题主要是删除记录的时候删不了，最后发现是中间表的外键默认删除时是RESTRICT，   当取值为No Action或者Restrict时，则当在父表（即外键的来源表）中删除对应记录时，首先检查该记录是否有对应外键，如果有则不允许删除。   当取值为Cascade时，则当在父表（即外键的来源表）中删除对应记录时，首先检查该记录是否有对应外键，如果有则也删除外键在子表（即包含外键的表）中的记录。   当取值为Set Null时，则当在父表（即外键的来源表）中删除对应记录时，首先检查该记录是否有对应外键，如果有则设置子表中该外键值为null（不
java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key c
qq_41858479的博客
10-13 2万+
错误原图： 错误分析：外键约束失败导致插入数据有误，也就是说店铺（一级）、商品分类（二级）、商品（三级），我在插入数据的时候，店铺数据和商品分类数据不存在或者数据插入错误，而商品数据正确，最终导致商品插入的时候找不到商品类别与店铺，从而出现错误。 解决问题：检查店铺（一级）、商品类别（二级）的数据（id）是否存在，或者正确。 相关知识：外键约束的使用 对外键约束定义的体现：数据的一致性...
已解决java.sql.SQLIntegrityConstraintViolationException: SQL完整性约束违反异常的正确解决方法，亲测有效！！！
最新发布
小明的Java问道之路
04-17 2018
已解决java.sql.SQLIntegrityConstraintViolationException: SQL完整性约束违反异常的正确解决方法，亲测有效！！！
java.sql.SQLIntegrityConstraintViolationException ORA-00001 违反唯一约束条件
m0_54850825的博客
04-19 1万+
Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 违反唯一约束条件 (JDDS.PK_SHOP_MESSAGE) ### The error may involve com.shop.dao.itf.MessageMapper.insert-Inline ### The error occurred while setting parameters ### SQL: in
java.sql.SQLIntegrityConstraintViolationException
now
02-11 3万+
转载：(130条消息) java.sql.SQLIntegrityConstraintViolationException新发现_心境-CSDN博客 Integrity Constraint Violation Exception完整性约束冲突异常 根据经验首先想到的是主键重复，没错，就是主键重复了。但是我每次都给主键赋新的值，还是会报这个错误。 经过检查发现，原来是数据库设置的唯一主键不是id，而是另外两个字段。但另外两个字段有值的时候，再次插入数据，id的值会被默认为这两个字段值的拼接结果，所以就
Caused by: java.sql.SQLIntegrityConstraintViolationException:
咸花生的博客
07-20 2181
SQLIntegrityConstraintViolationException 中文翻译：SQL 完整性约束违规异常 sys_user_2.user_name 字段插入重复数据导致。 Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '小白起' for key 'sys_user_2.user_name' at com.mysql.cj.jdbc.exceptions.SQLError.create
SQLIntegrityConstraintViolationException
qq_38089824的博客
04-05 2万+
异常现象： 异常原因：违反了数据库的唯一约束条件，插入数据时。具有唯一约束条件的字段值重复。 解决办法：1、删除重复的数据，保证表中的数据不重复。 2、将具有唯一约束性的列取消唯一约束性（不建议采纳） ...
异常java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key
guhui12138的博客
03-09 3319
异常java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`guhui`.`subjects`, C
Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or up
无
11-20 8230
报错描述： Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (zqq.tbl_employee, CONSTRAINT fk_emp_dept FOREIGN KEY (d_id) REFERENCES tbl_dept (id)) 解决方法： 数据库表中的字
MySQL更新日期报错
Nile_Holmes的博客
10-03 620
MySQL更新日期报错 1. 问题描述 ​ 最近在迁移MySQL数据库，版本变化：5.6.26 -> 5.7.28。数据库迁移后，在项目自测中遇到了一个问题，在此记录下。插入一条记录时，报错： org.springframework.dao.DataIntegrityViolationException: ### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data trunc
Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry ‘yuan‘ for key ‘idx_userna
qq_42807952的博客
07-27 1620
发送请求后，后端报错这个错误是意思是在底层你的数据库添加了一个字段不可重复的设置，当你第一次去测试该请求时，由于并没有对该异常进行处理，所以会爆出此错误。修正：查看数据库，看看是不是某个字段值重复了，修改一下字段，重新请求即可；后续要对次异常进行异常的处理机制，在请求页面告知用户，字段重复。
java.sql.SQLIntegrityConstraintViolationException 异常解决
m0_65473615的博客
10-11 4130
java.sql.SQLIntegrityConstraintViolationException 异常解决
java.sql.SQLIntegrityConstraintViolationException异常处理
SLBOSS的博客
09-12 4012
java.sql.SQLIntegrityConstraintViolationException出现这个异常表示在多表查询的时候字段冲突了在xml文件中给冲突的字段添加别名就可以了
java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key c...
weixin_30347335的博客
08-20 1317
HTTP Status 500 - Request processing failed; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement type Exception report message Request proc...
Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry
知识空间
11-16 3万+
最近在调试post方法时遇到SQLIntegrityConstraintViolationException: Duplicate entry xxx for key 这个错误，记录一下，方便后续查看 错误信息如下： { "timestamp": "2019-11-16 13:29:20", "status": 500, "error": "Internal Server ...
SQLIntegrityConstraintViolationException: 异常解决
热门推荐
qq_43842093的博客
01-01 4万+
SQLIntegrityConstraintViolationException: Duplicate entry ‘xxx’ for key 'yyyzzz’异常解决 一. 异常现象 在做Java Web项目操作数据库添加数据的时候，突然发现曝出如下图所示异常： Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry 'test1' for key 'UK_sb8bbouer5wak8vyiiy4pf2b
mysql外键java. sql. SOLIntegrityConstraintViolationException: Cannot add or update a child row: a fore
itScholar001的博客
01-08 390
mysql外键java. sql. SOLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails。act_ru_identitylink新增记录时由于act_ru_identitylink表的task_id在act_ru_task表中找不到关联记录导致报错。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值