topic java.sql.SQLException in activiti -5.10 when delete process in Alfresco Archive

java.sql.SQLException in activiti -5.10 when delete process

santharamselva — Tue, 12 Feb 2013 06:27:05 GMT

Hi, I am getting the problem when I am deleting process using activiti delete API with activiti-engine 5.10. my code is like below. processEngine.getRuntimeService().deleteProcessInstance(historicProcessInstance.getId(), deleteReason);‍ When I deleting this I am getting following error,12:46:4

Re: java.sql.SQLException in activiti -5.10 when delete process

frederikherema1 — Tue, 12 Feb 2013 15:31:11 GMT

I see this in your stack trace:
org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext

There is a property "transactionsExternallyManagers" in the ProcessEngineCOnfigurationImpl class, that allows you to disable committing in activiti, but rather rely on the container to do transaction-management.

Re: java.sql.SQLException in activiti -5.10 when delete process

santharamselva — Tue, 12 Feb 2013 16:57:24 GMT

Hi,

Thanks for your reply.

Could you tell me. What should I do now? how do I resolve it? What should I set "transactionsExternallyManagers" properties? if I set what will be my impact?

Thanks,
s.selvakumar

Re: java.sql.SQLException in activiti -5.10 when delete process

frederikherema1 — Wed, 13 Feb 2013 06:38:46 GMT

If you set this property on the ProcessEngineConfiguration:


 public ProcessEngineConfiguration setTransactionsExternallyManaged(boolean transactionsExternallyManaged) {
    this.transactionsExternallyManaged = transactionsExternallyManaged;
    return this;
  }

You're indicating that the transactions are not managed by iBatis but rather by your container (as appears from your stack trace).