首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >分库分表sharding-jdbc更新数据?

分库分表sharding-jdbc更新数据?

提问于 2023-04-24 16:43:48
回答 0关注 0查看 141

org.springframework.dao.DataIntegrityViolationException: ### Error updating database. Cause: java.sql.SQLException: Can not update sharding value for table `biz_purchase_data`. ### The error may exist in 文件路径 ### The error may involve 文件路径.update-Inline ### The error occurred while setting parameters ### SQL: UPDATE biz_purchase_data SET company_id = ?, shop_id = ?, purchase_id = ?, code = ?, size_group_id = ?, size_group_name = ?, brand_id = ?, brand_name = ?, attribute = ?, barcode = ?, color_id = ?, color_name = ?, size_id = ?, size_name = ?, price = ?, num = ?, amount = ?, create_id = ?, create_name = ?, create_time = ?, update_id = ?, update_name = ?, update_time = ? WHERE (id = ? AND company_id = ?) ### Cause: java.sql.SQLException: Can not update sharding value for table `biz_purchase_data`. ; Can not update sharding value for table `biz_purchase_data`.; nested exception is java.sql.SQLException: Can not update sharding value for table `biz_purchase_data`. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy124.update(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy168.update(Unknown Source) at com.baomidou.mybatisplus.extension.service.IService.update(IService.java:177)

使用mybatis-plus的updateById更新数据(分库分表),库的分片字段是company_id,表的分片字段是id,尝试过各种方法都报出该错误,希望各位大佬能够指点一下,提供思路和方向也好!!!!

回答

和开发者交流更多问题细节吧,去 写回答
相关文章

相似问题

相关问答用户
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档