topic Re: How to write code with transactions in Alfresco Archive

How to write code with transactions

hbf — Tue, 24 Jun 2008 09:41:11 GMT

Dear list,I need advice on how to use Alfresco transactions in my custom code. As far as I understand the Alfresco APIs, there are two ways to use transactions:1. Create the transaction, begin() it, do the work, and eventually call commit() or rollback().2. Do the work within a RetryingTransactionHe

Re: How to write code with transactions

cbosdonnat — Thu, 26 Jun 2008 06:28:41 GMT

Hi Kaspar,

I don't know of any other way to create transactions. Don't you have a way to call all your code for the transaction in one method ?

Regards,

Re: How to write code with transactions

hbf — Thu, 31 Jul 2008 19:22:09 GMT

I can write my code to do all the work in a RetryingTransactionHelper callback. However, this overcomplicates the code in my web layer: Ideally, I'd like to start a transaction at the beginning of a form submit, the web framework (Wicket in my case) will transparently update the properties of my nodes, render the new values to HTML, and at the end of the request, the transaction's commit() will save the changes to the repository. You see: the begin(), the changes, and the commit() occur at very different positions in the code, with many more actions performed by the Web framework in between for the presentation of the data…

Therefore I am wondering: Isn't there a way to tell Alfresco's UserTransaction to use a stricter locking protocol in order to avoid (most) such concurrency issues?

Many thanks,
Kaspar

Re: How to write code with transactions

dranakan — Fri, 31 Jul 2009 09:32:07 GMT

Hello,

Can anyone tell me how to use multiple transactions ? If I want to use the code below, I receive an error if first transaction start a rollback : javax.transaction.RollbackException: The transaction has already been marked for rollback)

Code in my action:


   UserTransaction trx_A = serviceRegistry.getTransactionService()
            .getUserTransaction();
   try
   {
     trx_A.begin()
     nodeService.createNode(…);
     nodeService.createNode(…);
     trx_A.commit();
   }
   catch(Throwable e)
   {
     try
     {
       if (trx_A.getStatus() == Status.STATUS_ACTIVE)
       {
          trx_A.rollback();
       }
     }
     catch(Throwable ee)
     {
       // Handle double exception in whatever way is appropriate eg. log it
     }

     throw e;
   }


….

   UserTransaction trx_B = serviceRegistry.getTransactionService()
            .getUserTransaction();
   try
   {
     trx_B.begin()
     nodeService.createNode(…);
     nodeService.createNode(…);
     trx_B.commit();
   }
   catch(Throwable e)
   {
     try
     {
       if (trx_B.getStatus() == Status.STATUS_ACTIVE)
       {
          trx_B.rollback();
       }
     }
     catch(Throwable ee)
     {
       // Handle double exception in whatever way is appropriate eg. log it
     }

     throw e;
   }

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

From http://wiki.alfresco.com/wiki/Java_Foundation_API#Handling_UserTransaction_Directly

The error :


11:08:14,080 ERROR [ch.custom.manageoffice.actions.SplittPDFFromERP] Error during the transaction
javax.transaction.RollbackException: The transaction has already been marked for rollback
   at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:450)
   at ch.custom.manageoffice.actions.SplittPDFFromERP.createErrorFile(SplittPDFFromERP.java:271)
   at ch.custom.manageoffice.actions.SplittPDFFromERP.executeImpl(SplittPDFFromERP.java:229)
   at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:127)
   at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:592)
   at org.alfresco.repo.action.executer.CompositeActionExecuter.executeImpl(CompositeActionExecuter.java:72)
   at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:127)
   at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:592)
   at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:529)
   at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1$1.execute(AsynchronousActionExecutionQueueImpl.java:369)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)
   at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1.doWork(AsynchronousActionExecutionQueueImpl.java:378)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:437)
   at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:381)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
   at java.lang.Thread.run(Thread.java:619)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I would like in a action start some work in transaction A. And after that start a transaction B.

Thanks

Re: How to write code with transactions

cheffilet — Fri, 31 Jul 2009 13:24:44 GMT

Why you dont take use of the Retrying-Transactionhandler-API?


Boolean result = transactionService.getRetryingTransactionHelper().doInTransaction(new RetryingTransactionHelper.RetryingTransactionCallback<Boolean>(){
    public Boolean execute() throws Throwable {
           //your code should be right here dropped
      return true;
    }   
});
‍‍‍‍‍‍‍‍

Re: How to write code with transactions

dranakan — Mon, 03 Aug 2009 13:58:41 GMT

Thank you Cheffilet

I think return true = commit() and false = rollback(). I have tested, but when I return false… there is no rollback() started…
If I add files and return false… the files are in Alfresco…
What I'm doing wrong ?

Re: How to write code with transactions

cheffilet — Wed, 05 Aug 2009 14:21:43 GMT

No, the transaction will be reseted if an exception will be raised:



Boolean result = transactionService.getRetryingTransactionHelper().doInTransaction(new RetryingTransactionHelper.RetryingTransactionCallback<Boolean>(){
    public Boolean execute() throws Throwable {
              
      …
      if(val == null)
         throw new IllegalStateException("Val must not be null");
   
      return true;
    }   
});

‍‍‍‍‍‍‍‍‍‍‍‍‍‍

You can use the returned value to go on with that result as its normaly that a transaction-scoped API like this above can return other values as only true or false.

Re: How to write code with transactions

dranakan — Thu, 06 Aug 2009 07:29:20 GMT

Thank you Cheffilet.

I have done like this :


final String var = …;
boolean resultAddFiles = transactionService.getRetryingTransactionHelper()
   .doInTransaction(
         new RetryingTransactionHelper.RetryingTransactionCallback<Boolean>() {
            public Boolean execute()
                  throws Throwable {

               boolean success= method(var);
               if (!success){
                  // Retry and rollback if always problem
                  throw  new IllegalStateException("Problem during moveFilesAndAddMeta");
               }
               return true;
            }
         });
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

If method return false, the exception is started and the execution continue (it not retry to execute). It is ok like this but the problem is that the rollback is not done. method will add some files, and if it return false, all files are always in Alfreso.

Has someone an idea ?

Thanks.

Re: How to write code with transactions

cheffilet — Thu, 06 Aug 2009 08:36:04 GMT

Sry, may fault:


Boolean result = transactionService.getRetryingTransactionHelper().doInTransaction(new RetryingTransactionHelper.RetryingTransactionCallback<Boolean>(){
    public Boolean execute() throws Throwable {
             
      …
      if(val == null)
         throw new IllegalStateException("Val must not be null");
   
      return true;
    }   
//we need to setup a new transaction for this 
}, false, true);
‍‍‍‍‍‍‍‍‍‍‍‍‍

As if you dont provide a new transaction the still existing transaction will be taken… so if you throw away the result to alfresco (to the transaction-interceptor) a rollback will be taken (PROPAGATION_REQUIRES).

Re: How to write code with transactions

dranakan — Thu, 06 Aug 2009 11:31:11 GMT

Thank you Cheffilet !!! It works like I want !

If the method inside generate error, all is rollback.

I am just surprise because it doesn't restart the action. In my case, it is not a problem… I want that it doesn't restart But…Shouldn't it ?

/**
     * Execute a callback in a transaction until it succeeds, fails
     * because of an error not the result of an optimistic locking failure,
     * or a deadlock loser failure, or until a maximum number of retries have
     * been attempted.
     *
     * It is possible to force a new transaction to be created or to partake in
     * any existing transaction.
     *
     * @param cb                The callback containing the unit of work.
     * @param readOnly          Whether this is a read only transaction.
     * @param requiresNew       <tt>true</tt> to force a new transaction or
     *                          <tt>false</tt> to partake in any existing transaction.
     * @return                  Returns the result of the unit of work.
     * @throws                  RuntimeException all checked exceptions are converted
     */
    public <R> R doInTransaction(RetryingTransactionCallback<R> cb, boolean readOnly, boolean requiresNew)

From : http://wiki.alfresco.com/wiki/Java_Foundation_API#Using_RetryingTransactionHelper_.28V2.1_and_later.29

And by default :

    * maxRetries: 20
    * minRetryWaitMs: 100
    * maxRetryWaitMs: 2000
    * retryWaitIncrementMs: 100

From http://dev.alfresco.com/resource/docs/java/repository/org/alfresco/repo/transaction/RetryingTransactionHelper.html

Re: How to write code with transactions

cheffilet — Thu, 06 Aug 2009 15:17:55 GMT

It depends on your usecase what you want to achieve with a retrying-operation.

To start a retrying-process you have to throw a exception that implements and/or derives from following interfaces/classes (Alfresco 3.2 CE):

class org.springframework.dao.ConcurrencyFailureException

class org.springframework.dao.DeadlockLoserDataAccessException

class org.hibernate.StaleObjectStateException

class org.springframework.jdbc.JdbcUpdateAffectedIncorrectNumberOfRowsException

class org.hibernate.exception.LockAcquisitionException

class org.hibernate.exception.ConstraintViolationException

class org.springframework.jdbc.UncategorizedSQLException

class java.sql.SQLException

class java.sql.BatchUpdateException

class org.springframework.dao.DataIntegrityViolationException

class org.hibernate.StaleStateException

class org.hibernate.ObjectNotFoundException

class org.hibernate.cache.CacheException

class net.sf.ehcache.distribution.RemoteCacheException

class org.hibernate.exception.SQLGrammarException

You can review the list of possible classes in the static member field org.alfresco.repo.transaction.RetryingTransactionHelper.RETRY_EXCEPTIONS


Boolean result = transactionService.getRetryingTransactionHelper().doInTransaction(new RetryingTransactionHelper.RetryingTransactionCallback<Boolean>(){
    public Boolean execute() throws Throwable {
             
      …
      if(val == null)
         throw new java.sql.SQLException("Val must not be null");
   
      return true;
    }   
//we need to setup a new transaction for this
}, false, true);
‍‍‍‍‍‍‍‍‍‍‍‍‍

Regards
Sebastian

Re: How to write code with transactions

dranakan — Fri, 23 Oct 2009 11:20:54 GMT

Thank you Cheffilet. Create this kind of errors do the retrying-process.

I have a problem to modify a nodeReference. For exemple, if I want to change a property (add 33 to the property FirmNb), this create error :

BAD CODE (not working)


         …
         final int firmNbF=33;
         final NodeRef actionedUponNodeRefF = actionedUponNodeRef;
         boolean success = transactionService
               .getRetryingTransactionHelper()
               .doInTransaction(
                     new RetryingTransactionHelper.RetryingTransactionCallback<Boolean>() {
                        public Boolean execute() throws Throwable {
                           
                           // Change property
                           nodeService.setProperty(
                                 actionedUponNodeRefF, QNAME_SC_FIRMNB, firmNbF);
                           return true;
                        }
                     }, false, true);

      } catch (Exception e) {
         logger.error(e);
      }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

There is no error in log, with after doing this, the file is removed and a new file is created with this :

Le contenu de l'élément est manquant : 
élément : workspace://SpacesStore/0d213852-7fc6-4392-a733-ab5216a5746b 
lecteur : null 
Veuillez contacter votre administrateur système.‍‍‍‍

How do I access to the actionedUponNodeRef (nodeRef) correctly ?

Thanks 🙂

Re: How to write code with transactions

wesse — Wed, 04 Nov 2009 22:18:27 GMT

How can I execute code in a transaction that is read only that needs to be able to write data ?

My specific problem is that I wnat to update a property on the event onReadContent

/Micke

Re: How to write code with transactions

cheffilet — Mon, 09 Nov 2009 06:55:47 GMT

@dranakan please post the whole strack-trace - in english

@Weese

Well you could open a new transaction within the current transaction - this should working. But after all, i´l prefer to dont to this approach as there exist numerous reasons why the transactions is marked as read-only. The worst thing we can do is, to "compell" alfresco for doing things it is not desinged to. So there are other chances on the table to solve your problem?

Re: How to write code with transactions

dranakan — Tue, 17 Nov 2009 15:12:41 GMT

Thanks for your help Cheffilet

logger.error(e); :

org.alfresco.service.cmr.repository.InvalidNodeRefException: Node does not exist: workspace://SpacesStore/3ce67710-4e6c-4f36-8401-87b0496812fa‍

This arrives only when the rule is setted with : Not running in background ("Run rule in Background" Disable). If this option is enable… all is working fine 🙂

I don't know why (certainly new updates) but I have no more the problem that I said : "There is no error in log, with after doing this, the file is removed and a new file is created with this :" in my last post.

Some ideas ?

Thanks

Re: How to write code with transactions

dranakan — Wed, 25 Nov 2009 09:00:59 GMT

I isolated the problem… this is with nodeService (same with FileFolderService, …) in the transaction :

…
logger.debug("A : " + nodeService.getProperty(actionedUponNodeRef,ContentModel.PROP_NAME));  
final NodeRef actionedUponNodeRefF = actionedUponNodeRef;
final NodeManager nodeManagerF = nodeManager;
final Action actionF = action;
logger.debug("B : "+ nodeService.getProperty(actionedUponNodeRefF,ContentModel.PROP_NAME));

try {
   success = transactionService.getRetryingTransactionHelper().doInTransaction(
      new RetryingTransactionHelper.RetryingTransactionCallback<Boolean>() {
         public Boolean execute() throws Throwable {
            try{
               logger.debug("C : "+ nodeService.getProperty(actionedUponNodeRefF,ContentModel.PROP_NAME));
            }catch (Exception e){
               logger.error(e);
               e.printStackTrace();
            }
…
         }, false, true);
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Rule setted in background, output is :


A : nameFile
B : nameFile
C : nameFile‍‍‍‍

Rule NOT setted in background, output is :


A : nameFile
B : nameFile
org.alfresco.service.cmr.repository.InvalidNodeRefException: Node does not exist: workspace://SpacesStore/35cf425e-e8db-4664-904a-8a38bc2a44a4
org.alfresco.service.cmr.repository.InvalidNodeRefException: Node does not exist: workspace://SpacesStore/35cf425e-e8db-4664-904a-8a38bc2a44a4
        at org.alfresco.repo.node.db.DbNodeServiceImpl.getNodePairNotNull(DbNodeServiceImpl.java:156)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.hasAspect(DbNodeServiceImpl.java:712)
        at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)
        at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy7.hasAspect(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy7.hasAspect(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy8.hasAspect(Unknown Source)
        at org.alfresco.repo.node.MLPropertyInterceptor.getPivotNodeRef(MLPropertyInterceptor.java:320)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:164)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:203)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:203)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy7.getProperty(Unknown Source)
        at ch.custom.manageoffice.actions.OrganizeFileInDirectory$1.execute(OrganizeFileInDirectory.java:170)
        at ch.custom.manageoffice.actions.OrganizeFileInDirectory$1.execute(OrganizeFileInDirectory.java:1)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)
        at ch.custom.manageoffice.actions.OrganizeFileInDirectory.executeImpl(OrganizeFileInDirectory.java:165)
        at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:127)
        at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:592)
        at org.alfresco.repo.action.executer.CompositeActionExecuter.executeImpl(CompositeActionExecuter.java:72)
        at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:127)
        at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:592)
        at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:529)
        at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:391)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:275)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy22.executeAction(Unknown Source)
        at org.alfresco.repo.rule.RuleServiceImpl.executeRule(RuleServiceImpl.java:928)
        at org.alfresco.repo.rule.RuleServiceImpl.executePendingRule(RuleServiceImpl.java:896)
        at org.alfresco.repo.rule.RuleServiceImpl.executePendingRulesImpl(RuleServiceImpl.java:867)
        at org.alfresco.repo.rule.RuleServiceImpl.executePendingRules(RuleServiceImpl.java:840)
        at org.alfresco.repo.rule.RuleTransactionListener.beforeCommit(RuleTransactionListener.java:63)
        at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:710)
        at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:690)
        at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:650)
        at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:835)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:645)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:466)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:334)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)
        at org.alfresco.web.bean.dialog.BaseDialogBean.finish(BaseDialogBean.java:127)
        at org.alfresco.web.bean.dialog.DialogManager.finish(DialogManager.java:534)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
        at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
        at javax.faces.component.UICommand.broadcast(UICommand.java:109)
        at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
        at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
        at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
        at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
        at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
        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:128)
        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:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

What is the problem ?

Thanks

Re: How to write code with transactions

dranakan — Wed, 02 Dec 2009 12:56:18 GMT

Hello,

Have someone a sample of code to write transactions (in an action) ?
(working with rules in background or not, able to restart if failed)

(http://wiki.alfresco.com/wiki/Java_Foundation_API#Handling_UserTransaction_Directly)
Thanks

Re: How to write code with transactions

vikashkaushik — Fri, 09 Jan 2015 06:59:17 GMT

As mentioned in the first post of this discussion ,
1. Create the transaction, begin() it, do the work, and eventually call commit() or rollback().

I have tried this way to check if rollback() works or not.

My code is typically like this :

UserTransaction userTransaction = jtaTransactionManager.getUserTransaction();

try {

userTransaction.begin();

Alfresco operation1 - using CMIS API ( To create a document )

Alfresco operation2 - using CMIS API ( To create a document)

userTransaction.commit();
}
catch (Exception e)
{
userTransaction.rollback();
}

My Alfresco operation2 throws an exception, then the document inserted by Alfresco operation1 is still there in Alfresco , even though the User Transaction is rolled back.

Can anyone help me how to resolve this.

I am using Spring JTA Transaction manager(XA)

Re: How to write code with transactions

mrogers — Fri, 09 Jan 2015 11:15:00 GMT

Cmis is not a remote transactional Api. It may be in future, but not now. I'm fairly sure it will never work as you laid out, the proposal I've heard about suggests a set of operations could be batched together as a single transaction.

If you want to do this then you need to write an alfresco WebScript and call that instead.

I've heard that it is possible to rewire alfresco's trasaction handling so transactions will distribute. Mostly for J2EE shops that want to wrap alfresco functionality in EJB. However I've not done it myself and suspect there may be limitations.

Re: How to write code with transactions

vikashkaushik — Thu, 15 Jan 2015 09:38:46 GMT

Thank you for the reply.

The scenario that we need currently is :

1. Creation/updation of document in Alfresco from a separate web application.
2. Insertion of the details of document in DB

So when DB insertion fails, we need to rollback the document creation/updation transaction.

Can you please let me know the approach for this. ( I doubt web script would be able to support to tie transactions from one application to Alfresco). I am very much new to this Alfresco.
It will be helpful for me if you provide some good pointers.