业务逻辑
在原有数据源是mysql的基础上适配达梦时,使用Hibernate的save方法进行保存,save保存后会返回自增主键id的数值,再根据这个返回值来进行updateorsave更新操作(某字段为主键id值+固定字符组成)。
问题
返回的id值与数据库中save保存后的主键id值数值不符。导致后续操作报错。
Batch update returned unexpected row count from update[0]; actual row count: 0; expected: 1
ang.springframework.orm.hibernate4.HibernateOptimisticlockingfailureexception: Batch update returned unexpected row count from update [0f actual row count: 0; expected: 1: nested exception is org.hibernate.stalestateexception: Batch update returned unexpected row count from update fol: actual row count: 0: expected:1
at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:181) at org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException
(HibernateTransactionManager.java:594)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:476) 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.iava:392)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org,springframework.aop.framework.CglibAopProxv$DvnamicAdvisedInterceptor.intercept(CglibAopProxy,iava:631)
at com.beidasoft.zfjd.department.service.TblDepartmentService$$EnhancerByCGLIB$$6b16cdfd.batchExamine(<generated>) at com.beidasoft.zfjd.department.service.TblDepartmentService$$FastClassByCGLIB$$abbf2e60.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aon.framework.CglibAonProxv$CglibMethodInvocation,invokeloinpoint(CalibAonProxy,iava:698
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.tianee.webframe.interceptor.TeeServiceLoggingInterceptor.invoke(TeeServiceLoggingInterceptor.java:44) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.CglibAopProxv$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631)
at com.beidasoft.zfid.department.service.TblDepartmentService$$EnhancerBvCGLIB$$84ca43d2. batchExamine(<generated> at com.beidasoft.zfid.department.controller.TblDepartmentController.examine(TblDepartmentController.java:162) at sun.reflect.NativeMethodAccessorImpl.invokee Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
解决方法
后来在咨询后得知,在使用DM时,jdbc中的jar包一定要对应jdk版本。
1.先确认项目使用的jdk版本
2.引入和jdk版本相符的DM_jdbc驱动jar包