Could not execute JDBC batch update/Duplicate entry '0' for key 1

最新推荐文章于 2022-09-26 00:22:27 发布
最新推荐文章于 2022-09-26 00:22:27 发布
阅读量1.4k 收藏
点赞数
分类专栏： Java 文章标签： jdbc exception nested insert list null
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/five824/article/details/7241677
版权

今天工作遇到的问题，因为用到了ManyToMany，所以出现这个问题的时候一直以为是哪里配置错了
到网上找了一下，发现和自己出现情况都不样，后来终于找到一条有用的信息：http://topic.csdn.net/t/20020622/13/822682.html
出现这样的问题应该是表的关系，于是重新检查表
问题出来了。。。。居然是主键忘了自增长

下面是出错的内容
===============================================================
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into play_gps (gps_setting_id, play_list_id) values (?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:637)
at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:793)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:664)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:394)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:117)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy38.saveGpsSetting(Unknown Source)
at com.cynovo.web.common.system.sysGpsSetting.GpsSettingAction.save(GpsSettingAction.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
at com.cynovo.framework.modules.interceptor.ExceptionHandlerInterceptor.intercept(ExceptionHandlerInterceptor.java:33)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.MessageStoreInterceptor.intercept(MessageStoreInterceptor.java:204)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.spring.interceptor.ActionAutowiringInterceptor.intercept(ActionAutowiringInterceptor.java:107)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:170)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)
... 82 more
Caused by: java.sql.BatchUpdateException: Duplicate entry '0' for key 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 90 more

Fanny
关注
专栏目录
maven出现：Failed to execute goal on project …: Could not resolve dependencies for project …
01-20
在使用Maven构建Java项目时，可能会遇到这样一个错误：“Failed to execute goal on project …: Could not resolve dependencies for project …”。这个错误通常表明Maven在构建过程中遇到了依赖解析问题，无法...
Could not execute JDBC batch update错误原因
姚勇龙的博客
01-09 1万+
**报错：Could not execute JDBC batch update org.hibernate.QueryTimeoutException: Could not execute JDBC batch update 错误原因1：将要插入到数据库中的内容长度超过了数据库中字段的实际设置的长度。 措施1：修改数据库中的字段长度 错误原因2：java类里面属性的类型和Hibernate的配...
Could not execute JDBC batch update 错误原因
DreamChaser_gf的博客
10-24 2万+
**Could not execute JDBC batch update 错误原因 ** org.hibernate.QueryTimeoutException: Could not execute JDBC batch update 错误原因1：你将要插入到数据库中的内容长度超过了数据库中字段的实际设置的长度. 修改数据库中的字段长度 错误原因2：java类里面属性的类型和Hiber...
Could not execute JDBC batch update异常的解决办法
碌人乘凉, 黎硕 --> Aerchi.com
07-23 1839
从ERROR] Could not synchronize database state with session org.hibernate.exception.DataException: Could not execute JDBC batch update 设置乐观锁造成的原因，得到数据被改过时就报这错误。。。 原因一：你将要插入到数据库中的字段内容长度超过了数据库中实际设置的长...
报错Could not execute JDBC batch update和java.sql.BatchUpdateException: Duplicate e
nick714的专栏
07-19 729
报错Could not execute JDBC batch update和java.sql.BatchUpdateException: Duplicate e 最近学hibernate,写了一段代码，第一次执行没问题，第二次执行报错了，想了一下，不应该是其他毛病，且报错是更新（update）出错，估计是第二次执行的时候刚好与第一次执行的结果出现了矛盾，于是去数据库将第一次执行的结果（主码）改了...
could not execute
11-07
could not execute:bad executable format(win32 error 193) 下了一个实现MD5的代码,编译时没有错误,但是执行的时候却提示:could not execute:bad executable format(win32 error 193)
解决MySQL安装重装时出现could not start the service mysql error:0问题的方法
12-15
当各位在安装、重装时出现could not start the service mysql error:0 原因: 卸载mysql时并没有完全删除相关文件和服务，需要手动清除。  安装到最后一步execute时不能启动服务的解决方法：  首先，在管理工具->...
JDBC中PreparedStatement接口提供的execute、executeQuery和executeUpdate之间的区别及用法
10-28
JDBC 中 PreparedStatement 接口提供的 execute、executeQuery 和 executeUpdate 之间的区别及用法 JDBC 中的 PreparedStatement 接口提供了三种执行 SQL 语句的方法：executeQuery、executeUpdate 和 execute。...
The remote procedure call failed and did not execute的解决办法
10-29
打开IIS随便访问一个.asp文件，提示The remote procedure call failed and did not execute
MySQL的Could not execute JDBC batch update解决方案，SQL脚本太长导致无法存入MySQL
Leemeea的博客
12-06 1742
mysql sql长度限制解决 错误提示： Could not execute JDBC batch update 通过发现原因是SQL语句长度大于1M，而机器上的mysql是默认配置为1M，也就是说mysql通讯的数据包大小设置是１M，这就造成sql语句执行失败。 将mysql的配置文件（my.ini）中的max_allowed_packet = 6M，就可以解决这样的问题。 ...
could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.excepti
热门推荐
qq_42572245的博客
07-03 2万+
报错内容 org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could...
java.sql.BatchUpdateException: Duplicate entry ‘00000000000001‘ for key ‘unique_meter_code‘
泗水六年的博客
09-26 2971
修改代码在新增数据之前进行唯一性判定，并返回提示给前端。meter_code在表中是唯一性索引。
java常见编程错误解答
jiaostyle的专栏
04-13 1861
一.保存重复时的错误提示（因为是主键，不可以重复保存） Caused by: java.sql.BatchUpdateException: Duplicate entry '2012004' for key 'PRIMARY' at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1693
sparksql建表时java.sql.BatchUpdateException: Duplicate entry ‘‘ for key ‘PRIMARY‘
Lenskit
07-17 8638
此报错大概率是因为列名有问题（中文列名或列名过长） When creating a table in Hive with column names over 128 characters an error like below is raised. Note: "COLUMNS_V2" is a Hive metadata table. 具体链接：https://support.oracle.com/knowledge/Oracle%20Database%20Products/2255940_1.ht.
org.springframework.dao.DataIntegrityViolationException Could not execute JDBC batch update
再小的项目也有它的亮点
12-04 4646
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into weixin_user_infomation (subscribe, openid, nickname, sex, city, country, province, language, headimgurl, subscribe_time, user_id) values (?, ?, ?
java开发中遇到的数据库相关的一些错误
u012971998的博客
02-12 1779
保存数据库异常错误1： org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationExceptio...
ORA-01950: 对表空间 'CDSME_DATASPACE' 无权限 报错解决
l_s_r的博客
12-11 1594
记录一个很简单又很容易忽略的问题，挺烦人的，因为看报错信息根本很难往那个方向想的，所以记录一下以防万一。 报错信息： 1.ORA-01950: 对表空间 'CDSME_DATASPACE' 无权限 2.Could not synchronize database state with session 3.Could not execute JDBC batch update; SQL [...
JDBC执行批量UPDATE的几个坑
若鱼的专栏
12-10 3360
关于allowMultiQueries 上代码： @Test public void testUpdateBatch2Jdbc()throws Exception{ Connection conn = ds.getConnection(); PreparedStatement pstmt = conn.prepareStatement( "update users set gender = 0 where id = 1;" +
could not execute jdbc batch update
最新发布
06-06
"could not execute jdbc batch update" 是一个数据库错误信息，通常表示在执行 JDBC 批量更新操作时出现了问题。这可能是由于多种原因导致的，比如无效的 SQL 语法、数据库连接问题、权限问题等。 要解决这个问题...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值