topic Updating the database from JavaDelegate in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/updating-the-database-from-javadelegate/m-p/91420#M62392 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>I don't know if there is a way to do what I want…</SPAN><BR /><SPAN>I have an async service task for executing several commands configured by the user. For example: create new file, copy, or delete a file…</SPAN><BR /><SPAN>If one of the commands fails in execution I throw a exception, but when the task is restarted I need to know what commands were successful because I don want executing them again.</SPAN><BR /><SPAN>I tried to do this setting a variable with my command identifier in my DelegateExecution with boolean value. But I noticed that this variable is not really stored until the execution is ended. So, if the execution is interrupted I never has that variable. </SPAN><BR /><SPAN>So, I tried as well to set it calling a rest service from my JavaDelagate that make it through RuntimeService </SPAN><BR /><BR /><SPAN>runtimeService.setVariable(executionId, variableName, value);</SPAN><BR /><BR /><SPAN>Now I can see that the database is updated but when the service task execution ends I get the error</SPAN><BR /><BR /><SPAN>Exception in thread "pool-2-thread-3" org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN> ### Error updating database.&nbsp; Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: restricci?n de integridad (IBAP8.ACT_FK_VAR_EXE) violada - registro secundario encontrado</SPAN><BR /><BR /><SPAN>And the thread continues alive…</SPAN><BR /><BR /><SPAN>There is a way to do what I want??</SPAN><BR /><BR /><SPAN>Thanks in advance</SPAN></BODY></HTML> Wed, 26 Sep 2012 08:43:07 GMT rodiaz 2012-09-26T08:43:07Z Updating the database from JavaDelegate https://connect.hyland.com/t5/alfresco-archive/updating-the-database-from-javadelegate/m-p/91420#M62392 Hi all,I don't know if there is a way to do what I want…I have an async service task for executing several commands configured by the user. For example: create new file, copy, or delete a file…If one of the commands fails in execution I throw a exception, but when the task is restarted I need to kno Wed, 26 Sep 2012 08:43:07 GMT https://connect.hyland.com/t5/alfresco-archive/updating-the-database-from-javadelegate/m-p/91420#M62392 rodiaz 2012-09-26T08:43:07Z Re: Updating the database from JavaDelegate https://connect.hyland.com/t5/alfresco-archive/updating-the-database-from-javadelegate/m-p/91421#M62393 <HTML><HEAD></HEAD><BODY><SPAN>The transaction is only committed at the end of the command, indeed and variable-updates only flushed at the end of the command. You CANNOT later process state (e.g.. set a variable) from another transaction, when the process is flowing. So setting a variable in the process should be done on the delegate itself. This is the way activiti works. If you want to store stuff that doesn't play with the activiti-transactions (ie. is not rolled back when something goes wrong) you should use a separate db-table with separate transaction…</SPAN></BODY></HTML> Thu, 27 Sep 2012 14:53:27 GMT https://connect.hyland.com/t5/alfresco-archive/updating-the-database-from-javadelegate/m-p/91421#M62393 frederikherema1 2012-09-27T14:53:27Z