NutzCN Logo
问答 NutDaoRunner - SAVEPOINT does not exist
发布于 3334天前 作者 qq_710cab78 2409 次浏览 复制 上一个帖子 下一个帖子
标签: dao

一、异常信息
2015-11-06 15:46:32,998 [http-6888-8] ERROR org.nutz.dao.impl.sql.run.NutDaoRunner - SAVEPOINT 192c669f_150d60dfd58_59e7 does not exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SAVEPOINT 192c669f_150d60dfd58_59e7 does not exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1755)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1679)
at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:5147)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:829)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:43)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:204)
at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:50)
at org.nutz.dao.impl.NutDao.insert(NutDao.java:134)
at org.fireflow.engine.modules.persistence.nutz.AbsPersisterNutzImpl.saveOrUpdate(AbsPersisterNutzImpl.java:172)
at org.fireflow.pdl.fpdl.enginemodules.workitem.WorkItemManagerFpdl20Impl.createWorkItem(WorkItemManagerFpdl20Impl.java:200)
at com.erp.workflow.ext.OkWorkItemManager.createWorkItem(OkWorkItemManager.java:66)
at org.fireflow.engine.invocation.impl.AbsAssignmentHandler.assign(AbsAssignmentHandler.java:121)
at org.fireflow.engine.modules.workitem.impl.AbsWorkItemManager.invoke(AbsWorkItemManager.java:113)
at org.fireflow.pdl.fpdl.enginemodules.instancemanager.ActivityInstanceManagerFpdl20Impl.runActivityInstance(ActivityInstanceManagerFpdl20Impl.java:152)
at org.fireflow.pdl.fpdl.behavior.ActivityBehavior.execute(ActivityBehavior.java:158)
at org.fireflow.pvm.kernel.impl.AbstractPObject.executeBusinessLogicLogic(AbstractPObject.java:238)
at org.fireflow.pvm.kernel.impl.AbstractPObject.takeToken(AbstractPObject.java:225)
at org.fireflow.pvm.kernel.impl.KernelManagerImpl.execute(KernelManagerImpl.java:216)
at org.fireflow.engine.modules.instancemanager.impl.AbsActivityInstanceManager.onServiceCompleted(AbsActivityInstanceManager.java:93)
at org.fireflow.engine.modules.workitem.impl.AbsWorkItemManager.completeWorkItem(AbsWorkItemManager.java:530)
at org.fireflow.client.impl.WorkflowStatementLocalImpl.completeWorkItem(WorkflowStatementLocalImpl.java:742)
at com.okideaad.erp.workflow.WorkflowModule$1.run(WorkflowModule.java:390)
at org.nutz.trans.Trans.exec(Trans.java:165)
at org.nutz.trans.Trans.exec(Trans.java:123)
at com.okideaad.erp.workflow.WorkflowModule.completeWorkItem(WorkflowModule.java:387)
at FASTCLASS$$12._invoke(Unknown Source)
at org.nutz.lang.reflect.AbstractFastClass.invoke(AbstractFastClass.java:107)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:27)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:40)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:99)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:40)
at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:64)
at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:175)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at com.okideaad.erp.security.MenuUrlFilter.doFilter(MenuUrlFilter.java:66)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at com.erp.security.MustChangePwdFilter.doFilter(MustChangePwdFilter.java:31)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
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 com.okideaad.erp.security.EmailSSOFilter.doFilter(EmailSSOFilter.java:62)
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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.okideaad.erp.filter.EncodingFilter.doFilter(EncodingFilter.java:34)
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:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
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:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)

业务员截图:
 ![QQ截图20151106173514_jpg](/yvr/upload/4e/dsoc87o0h78o38ltfcvvk3h2)

二、代码段
代码:
QQ截图20151106173215_jpg

三、疑问
为什么会报这个错误呢?是nutz自动加了事务 保存点以便回滚,但是为什么找不到SAVEPOINT ,业务员截图里面是锁的问题,
但日志,没有记录锁的异常,只记录了上面的异常。

2 回复

业务员截图:
QQ截图20151106173514_jpg

那个表不支持事务?

nutz,mysql,驱动,版本分别是多少

来自炫酷的 NutzCN

添加回复
请先登陆
回到顶部