AnsweredAssumed Answered

Duplicate Row error on redeploy of BPMN file, Activiti 5.10

Question asked by mindcrime on Mar 22, 2013
Latest reply on Mar 27, 2013 by frederikheremans1
Fellow Aciviti'ers:

I'm seeing some strange behaviour when redeploying a BPMN file through Activiti Explorer.  This only seems
to happen if the BPMN in question has running processes associated with it.   In this case, when you
upload the new BPMN, the following error is encountered.   The DB2 SQLSTATE and SQLCODE numbers
below correspond to "duplicate row".  So it appears that we are somehow trying to insert a duplicate
record into  ACT_RE_DEPLOYMENT.

Any idea why this is happening, and if there is a workaround?



Mar 22, 2013 10:17:38 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource Enrollment_With_Tech_Exception_Path.bpmn20.xml
Mar 22, 2013 10:17:39 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
INFO: XMLSchema currently not supported as typeLanguage
Mar 22, 2013 10:17:39 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
INFO: XPath currently not supported as expressionLanguage
Mar 22, 2013 10:17:39 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseProcessDefinitions
INFO: Process with id='enrollment_With__Tech_Exceptions' hasn't the attribute isExecutable set. Please maintain it, so you are compatible to future activiti versions.
Mar 22, 2013 10:17:46 AM org.activiti.engine.impl.interceptor.CommandContext close
SEVERE: Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
### The error may involve org.activiti.engine.impl.persistence.entity.DeploymentEntity.insertDeployment-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_RE_DEPLOYMENT(ID_, NAME_, DEPLOY_TIME_)     values(?, ?, ?)
### Cause: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)
   at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:459)
   at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:369)
   at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:157)
   at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:109)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:54)
   at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:106)
   at org.activiti.explorer.ui.management.deployment.DeploymentUploadReceiver.deployUploadedFile(DeploymentUploadReceiver.java:83)
   at org.activiti.explorer.ui.management.deployment.DeploymentUploadReceiver.uploadFinished(DeploymentUploadReceiver.java:71)
   at org.activiti.explorer.ui.custom.UploadComponent.uploadFinished(UploadComponent.java:173)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:616)
   at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:490)
   at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:164)
   at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1193)
   at com.vaadin.ui.Upload.fireUploadSuccess(Upload.java:744)
   at com.vaadin.ui.Upload$1.streamingFinished(Upload.java:1022)
   at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.streamToReceiver(AbstractCommunicationManager.java:593)
   at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleSimpleMultipartFileUpload(AbstractCommunicationManager.java:469)
   at com.vaadin.terminal.gwt.server.CommunicationManager.handleFileUpload(CommunicationManager.java:257)
   at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:495)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   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:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Thread.java:679)
Caused by: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
   at com.ibm.db2.jcc.a.wc.a(wc.java:588)
   at com.ibm.db2.jcc.a.wc.a(wc.java:60)
   at com.ibm.db2.jcc.a.wc.a(wc.java:127)
   at com.ibm.db2.jcc.a.fl.b(fl.java:1599)
   at com.ibm.db2.jcc.a.fl.c(fl.java:1582)
   at com.ibm.db2.jcc.t4.db.k(db.java:353)
   at com.ibm.db2.jcc.t4.db.a(db.java:59)
   at com.ibm.db2.jcc.t4.t.a(t.java:50)
   at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
   at com.ibm.db2.jcc.a.gl.Kb(gl.java:2365)
   at com.ibm.db2.jcc.a.gl.e(gl.java:3143)
   at com.ibm.db2.jcc.a.gl.Fb(gl.java:1848)
   at com.ibm.db2.jcc.a.gl.execute(gl.java:1832)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
   at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
   at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
   at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
   … 41 more
Mar 22, 2013 10:17:46 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource Enrollment_With_Tech_Exception_Path.bpmn20.xml
Mar 22, 2013 10:17:47 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
INFO: XMLSchema currently not supported as typeLanguage
Mar 22, 2013 10:17:47 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
INFO: XPath currently not supported as expressionLanguage
Mar 22, 2013 10:17:47 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseProcessDefinitions
INFO: Process with id='enrollment_With__Tech_Exceptions' hasn't the attribute isExecutable set. Please maintain it, so you are compatible to future activiti versions.
Mar 22, 2013 10:17:48 AM org.activiti.engine.impl.interceptor.CommandContext close
SEVERE: Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
### The error may involve org.activiti.engine.impl.persistence.entity.DeploymentEntity.insertDeployment-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_RE_DEPLOYMENT(ID_, NAME_, DEPLOY_TIME_)     values(?, ?, ?)
### Cause: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)
   at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:459)
   at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:369)
   at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:157)
   at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:109)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:54)
   at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:106)
   at org.activiti.explorer.ui.management.deployment.DeploymentUploadReceiver.deployUploadedFile(DeploymentUploadReceiver.java:83)
   at org.activiti.explorer.ui.management.deployment.DeploymentUploadReceiver.uploadFinished(DeploymentUploadReceiver.java:71)
   at org.activiti.explorer.ui.custom.UploadComponent.uploadFinished(UploadComponent.java:173)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:616)
   at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:490)
   at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:164)
   at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1193)
   at com.vaadin.ui.Upload.fireUploadInterrupted(Upload.java:731)
   at com.vaadin.ui.Upload$1.streamingFailed(Upload.java:1037)
   at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.streamToReceiver(AbstractCommunicationManager.java:612)
   at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleSimpleMultipartFileUpload(AbstractCommunicationManager.java:469)
   at com.vaadin.terminal.gwt.server.CommunicationManager.handleFileUpload(CommunicationManager.java:257)
   at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:495)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   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:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Thread.java:679)
Caused by: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
   at com.ibm.db2.jcc.a.wc.a(wc.java:588)
   at com.ibm.db2.jcc.a.wc.a(wc.java:60)
   at com.ibm.db2.jcc.a.wc.a(wc.java:127)
   at com.ibm.db2.jcc.a.fl.b(fl.java:1599)
   at com.ibm.db2.jcc.a.fl.c(fl.java:1582)
   at com.ibm.db2.jcc.t4.db.k(db.java:353)
   at com.ibm.db2.jcc.t4.db.a(db.java:59)
   at com.ibm.db2.jcc.t4.t.a(t.java:50)
   at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
   at com.ibm.db2.jcc.a.gl.Kb(gl.java:2365)
   at com.ibm.db2.jcc.a.gl.e(gl.java:3143)
   at com.ibm.db2.jcc.a.gl.Fb(gl.java:1848)
   at com.ibm.db2.jcc.a.gl.execute(gl.java:1832)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
   at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
   at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
   at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
   … 41 more
Mar 22, 2013 10:17:48 AM com.vaadin.Application terminalError
SEVERE: Terminal error:
com.vaadin.event.ListenerMethod$MethodException
Cause: org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
### The error may involve org.activiti.engine.impl.persistence.entity.DeploymentEntity.insertDeployment-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_RE_DEPLOYMENT(ID_, NAME_, DEPLOY_TIME_)     values(?, ?, ?)
### Cause: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
   at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510)
   at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:164)
   at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1193)
   at com.vaadin.ui.Upload.fireUploadInterrupted(Upload.java:731)
   at com.vaadin.ui.Upload$1.streamingFailed(Upload.java:1037)
   at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.streamToReceiver(AbstractCommunicationManager.java:612)
   at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleSimpleMultipartFileUpload(AbstractCommunicationManager.java:469)
   at com.vaadin.terminal.gwt.server.CommunicationManager.handleFileUpload(CommunicationManager.java:257)
   at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:495)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   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:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Thread.java:679)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
### The error may involve org.activiti.engine.impl.persistence.entity.DeploymentEntity.insertDeployment-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_RE_DEPLOYMENT(ID_, NAME_, DEPLOY_TIME_)     values(?, ?, ?)
### Cause: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)
   at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:459)
   at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:369)
   at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:157)
   at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:109)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:54)
   at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:106)
   at org.activiti.explorer.ui.management.deployment.DeploymentUploadReceiver.deployUploadedFile(DeploymentUploadReceiver.java:83)
   at org.activiti.explorer.ui.management.deployment.DeploymentUploadReceiver.uploadFinished(DeploymentUploadReceiver.java:71)
   at org.activiti.explorer.ui.custom.UploadComponent.uploadFinished(UploadComponent.java:173)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:616)
   at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:490)
   … 21 more
Caused by: com.ibm.db2.jcc.a.ym: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;ACTDB01.ACT_RE_DEPLOYMENT, DRIVER=3.51.90
   at com.ibm.db2.jcc.a.wc.a(wc.java:588)
   at com.ibm.db2.jcc.a.wc.a(wc.java:60)
   at com.ibm.db2.jcc.a.wc.a(wc.java:127)
   at com.ibm.db2.jcc.a.fl.b(fl.java:1599)
   at com.ibm.db2.jcc.a.fl.c(fl.java:1582)
   at com.ibm.db2.jcc.t4.db.k(db.java:353)
   at com.ibm.db2.jcc.t4.db.a(db.java:59)
   at com.ibm.db2.jcc.t4.t.a(t.java:50)
   at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
   at com.ibm.db2.jcc.a.gl.Kb(gl.java:2365)
   at com.ibm.db2.jcc.a.gl.e(gl.java:3143)
   at com.ibm.db2.jcc.a.gl.Fb(gl.java:1848)
   at com.ibm.db2.jcc.a.gl.execute(gl.java:1832)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
   at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
   at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
   at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
   … 41 more

Outcomes