dm.jdbc.driver.DMException: 违反表[ACT_RU_EXECUTION]唯一性约束条件[SYS_C0083460]

于 2025-02-28 10:51:18 发布
阅读量1k 收藏 11
点赞数 18
分类专栏： java 文章标签： activiti
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/weixin_44077141/article/details/145495064
版权

提示这个报错，dm数据库 activiti 提交流程报错，

dm.jdbc.driver.DMException: 违反表[ACT_RU_EXECUTION]唯一性约束条件[SYS_C0083460]
	at dm.jdbc.driver.DBError.throwException(DBError.java:684)
	at dm.jdbc.b.b.o.G(MSG.java:554)
	at dm.jdbc.b.b.o.D(MSG.java:514)
	at dm.jdbc.b.b.o.C(MSG.java:495)
	at dm.jdbc.b.a.a(DBAccess.java:219)
	at dm.jdbc.b.a.b(DBAccess.java:825)
	at dm.jdbc.b.a.a(DBAccess.java:696)
	at dm.jdbc.driver.DmdbPreparedStatement.executeInner(DmdbPreparedStatement.java:378)
	at dm.jdbc.driver.DmdbPreparedStatement.do_execute(DmdbPreparedStatement.java:466)
	at dm.jdbc.driver.DmdbPreparedStatement.execute(DmdbPreparedStatement.java:1812)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
	at com.sun.proxy.$Proxy56.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	at org.activiti.engine.impl.db.DbSqlSession.flushRegularInsert(DbSqlSession.java:827)
	at org.activiti.engine.impl.db.DbSqlSession.flushPersistentObjects(DbSqlSession.java:808)
	at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:791)
	at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:612)
	at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:212)
	at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:138)
	at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)
	at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
	at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
	at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
	at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
	at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
	at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceById(RuntimeServiceImpl.java:118)
	at cn.chinaunicom.sdsi.frm.workflow.component.impl.WorkflowManagerImpl.startProcess(WorkflowManagerImpl.java:428)
	at cn.chinaunicom.sdsi.frm.workflow.component.impl.WorkflowManagerImpl$$FastClassBySpringCGLIB$$3c350575.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
	at cn.chinaunicom.sdsi.frm.workflow.component.impl.WorkflowManagerImpl$$EnhancerBySpringCGLIB$$f4f4242b.startProcess(<generated>)
	at unicom.ams.flow.intraDepAssetTranfer.service.impl.IntraDepAssetTranferServiceImpl.startProcess(IntraDepAssetTranferServiceImpl.java:1756)
	at unicom.ams.flow.intraDepAssetTranfer.service.impl.IntraDepAssetTranferServiceImpl$$FastClassBySpringCGLIB$$d26f3320.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
	at unicom.ams.flow.intraDepAssetTranfer.service.impl.IntraDepAssetTranferServiceImpl$$EnhancerBySpringCGLIB$$dbcb100c.startProcess(<generated>)
	at unicom.ams.flow.intraDepAssetTranfer.controller.IntraDepAssetTranferController.startProcess(IntraDepAssetTranferController.java:573)
	at unicom.ams.flow.intraDepAssetTranfer.controller.IntraDepAssetTranferController$$FastClassBySpringCGLIB$$d272e90e.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
	at cn.chinaunicom.sdsi.frm.spring.OperationLog.doOperationLog(OperationLog.java:161)
	at sun.reflect.GeneratedMethodAccessor216.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:620)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:609)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
	at unicom.ams.flow.intraDepAssetTranfer.controller.IntraDepAssetTranferController$$EnhancerBySpringCGLIB$$e004fa0.startProcess(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:515)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:583)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:212)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:129)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at cn.chinaunicom.sdsi.frm.xss.XssFilter.doFilter(XssFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:679)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:617)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:934)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1698)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)

在这里插入图片描述
然后跟着报错，
在这里插入图片描述
然后我就不知道该去干什么了，我上网上去搜，然后没得办法，又因为是在源码里面的。
自己看了一下午，又看了一上午了没得办法，我一直想的是处理数据，然后处理数据被限制了数据外键，数据我都删除不过来。

处理

然后开始摇人，大佬来了看了一眼，给了一个sql

 select  AMS.ACT_NEXT_DBID.nextval from dual

我也不知道这个是啥sql，然后这个是activiti的初始化的值的，然后大佬说只要是修改了这个值，就没啥问题了，

ALTER SEQUENCE AMS.ACT_NEXT_DBID INCREMENT BY 1;

这个sql是干啥呢，我上午找了找，没得改初始值的问题，这个sql是oracle里面抄过来的，然后还有一个初始化的sql，失败了，不承认dm数据库，然后处理这个问题该如何干呢。

ALTER SEQUENCE AMS.ACT_NEXT_DBID INCREMENT BY 1000;

这个sql执行了之后呢，每次执行这个sql

 select  AMS.ACT_NEXT_DBID.nextval from dual

都会增加1000
等数据正常了，然后在

ALTER SEQUENCE AMS.ACT_NEXT_DBID INCREMENT BY 1;

将每次更新的数+1

dm.jdbc.driver.DMException: 字符串截断，解决达梦数据库执行Insert语句报错
十三月的博客
01-30 6046
当我们使用达梦数据库执行SQL语句时，可能会遇到如下报错：dm.jdbc.driver.DMException: 字符串截断。
20.违反数据库唯一约束Caused by: dm.jdbc.driver.DMException: Violate unique constraint ，解决思路分析
qq_37992410的博客
03-05 854
违反唯一性约束Caused by: dm.jdbc.driver.DMException: Violate unique constraint on [my_table][load_uidxe_idx]
达梦数据库报dm.jdbc.driver.DMException: 网络通信异常
qq_45415736的博客
04-11 1万+
连接达梦数据库报dm.jdbc.driver.DMException: 网络通信异常 一、复制官方文档配置数据库连接信息 1.注意url最后面的下划线"/"要去掉 2.改成 二、如果还是报网络通信异常 1.请仔细检查username、password、driver-class-name、url中IP地址和冒号":"后面的端口号是否正确，特别是IP地址更换环境容易忘记修改。
DM开发遇见的坑 : 违反引用约束
qq_45225756的博客
04-08 1784
查看数据库，是否外键匹配错误导致。需要去dm可视化工具中去改对应表的外键，以上是表AUTH_USER_GROUPS的外键出现问题。错误消息: 违反引用约束[AUTH_USER_GROUPS_USER_ID_*******_FK_AUTH_USER_ID]
jdbc中的日期类型问题
xiueer
09-29 615
package cn.itcast.jdbc;import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Date;public cl
非法的时间日期类型数据
wy071218的专栏
09-15 3469
使用to_date函数报：非法的时间日期类型数据
故障004：非法的时间日期类型数据
ai20110304的专栏
03-24 4128
达梦 to_date 非法的时间日期类型数据
数据库 -- DMDB -- 违反列[SEQUENCE_NUM]非空约束
支棱起来
04-22 5515
当程序后台报错内容为 ERROR org.hibernate.util.JDBCExceptionReporter - 违反列[SEQUENCE_NUM]非空约束 报错原因是我们在 postgres 中为数据库的表字段设置为 "sequence_num" serial8 在 DMDB 中这个字段对应的是 "SEQUENCE_NUM" BIGINT NOT NULL 这种设置方式在 postgre...
dm.jdbc.driver.DMException: 序列号无效 (达梦)
JAVA_LT1224的博客
08-18 6788
报错信息: Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: dm.jdbc.driver.DMException: 序列号无效。
org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: dm.jdbc.driver.DMException: 违反引用约束[ACT_RU_EXECUTION_IBFK_3] ### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.bulkInsertExecution-Inline ### The error occurred while setting parameters ### SQL: insert into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_,IS_EVENT_SCOPE_, IS_MI_ROOT_, PARENT_ID_, SUPER_EXEC_, ROOT_PROC_INST_ID_, SUSPENSION_STATE_, TENANT_ID_, NAME_, START_TIME_, START_USER_ID_, IS_COUNT_ENABLED_, EVT_SUBSCR_COUNT_, TASK_COUNT_, JOB_COUNT_, TIMER_JOB_COUNT_, SUSP_JOB_COUNT_, DEADLETTER_JOB_COUNT_, VAR_COUNT_, ID_LINK_COUNT_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) , (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ### Cause: dm.jdbc.driver.DMException: 违反引用约束[ACT_RU_EXECUTION_IBFK_3]
最新发布
03-24
以下是针对违反引用约束问题（如 `ACT_RU_EXECUTION_IBFK_3`）的具体分析和解决方案。 #### 1. 违反外键约束的原因 当尝试通过 MyBatis 执行更新操作时，如果目标表中的数据依赖于其他表的数据，则可能会触发外键...
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
热门推荐
Eiffel_Wu的博客
06-20 3万+
连接数据库时经常出现的异常就是java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 所以今天我结合自己的经验给大家总结一下，碰到这类的异常要如何处理，首先给大家分享一下我在用MyBatis逆向生成时碰到到的这个异常。 异常信息如下： java.lang.RuntimeException: Exception getting JDBC Dri...
达梦驱动 DmJdbcDriver.jar
06-08
达梦数据库java驱动包DmJdbcDriver.jar
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
风学长的博客
03-17 1万+
. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spr...
dm.jdbc.driver.DMException: 网络通信异常
qq_45685740的博客
11-18 2万+
IDEA中项目启动不成功，达梦数据库连接不上，dbeaverl连接成功。报网络通信异常与连接超时错误 .dm.jdbc.driver.DMException: 网络通信异常 vpn
达梦数据库非空约束错误解决，明明插入空字符串“，但还是触发非空约束
qq_38196449的博客
06-21 3982
今天在做增删改查的时候，发现一个问题，就是我的某字段设置为NOT NULL非空约束，但在插入空字符串的时候还是触发非空约束报错，这令我十分费解，我又没有传null，为什么还会触发非空约束呢？苦思良久找到问题关键，是因为我在往服务器上部署达梦的时候，设置了兼容模式为2，一会再解释这个兼容模式。
dm.jdbc.driver.DMException: 第 1 行, 第 37 列[comment]附近出现错误: 语法分析出错
程序员青戈
10-21 2万+
最近使用国产数据库达梦，遇到一个大坑。 数据库有一个字段名称叫comment，sql是这样的： CREATE TABLE "CFGC"."CFG_LABEL" ( "ID" INT NOT NULL, "COMMENT" VARCHAR(765), "DEF" CHAR(21), "NAME" VARCHAR(96) NOT NULL, PRIMARY KEY("ID")) 可是在使用jpa的时...
日常开发报错
qq_52445173的博客
11-25 848
日常报错处理
dm.jdbc.driver.DMException: 自动提交时不允许对作业进行配置
elephant_xiang的专栏
06-21 1972
java jdbc 执行 达梦数据库 创建job语句报错
Springboot+达梦数据库
zjdCy的博客
10-08 3339
在项目中遇到需要切换成国产化达梦数据库（DM8），在切换过程中遇到较多的问题，记录一下。 1、首先在在pom文件中引入DM8依赖： <dependency> <groupId>com.dameng</groupId> <artifactId>Dm8JdbcDriver18</artifactId> <version>8.1.1.49</version> </dependency> 2、在appli.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

又是重名了

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值