topic Servcietask‘s Transaction Problem in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/servcietask-s-transaction-problem/m-p/144257#M100888 <HTML><HEAD></HEAD><BODY><SPAN>I use a Servicetask to complete some work.</SPAN><BR /><SPAN>but when the task takes too long time to end,there happened some exception:connection had been closed !</SPAN><BR /><SPAN>I found that because of transation,so i use a thread to finish the work</SPAN><BR /><SPAN> I write MyServiceServiceeTask extends TaskActivityBehavior ,such as</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @Override</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public void signal(ActivityExecution execution, String signalName,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Object signalData) throws Exception {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;leave(execution);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @Override</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public void execute(ActivityExecution execution) throws Exception {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//this is need</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;execution.getVariables();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thread t = new AsynRunThread(execution);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;t.start();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><BR /><SPAN>and at the end of thread,I call signal method to leave this task.</SPAN><BR /><SPAN>there some times happened that task finished but table act_hi_actinst's end_time_ is null</SPAN><BR /><SPAN>because Thread sometime finished before the Main class(MyServiceServiceeTask)'s transaction end</SPAN><BR /><BR /><SPAN>who encoutered this problem or give me some advices</SPAN></BODY></HTML> Thu, 13 Jun 2013 09:00:56 GMT yuhu84 2013-06-13T09:00:56Z Servcietask‘s Transaction Problem https://connect.hyland.com/t5/alfresco-archive/servcietask-s-transaction-problem/m-p/144257#M100888 I use a Servicetask to complete some work.but when the task takes too long time to end,there happened some exception:connection had been closed !I found that because of transation,so i use a thread to finish the work I write MyServiceServiceeTask extends TaskActivityBehavior ,such as&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @Overrid Thu, 13 Jun 2013 09:00:56 GMT https://connect.hyland.com/t5/alfresco-archive/servcietask-s-transaction-problem/m-p/144257#M100888 yuhu84 2013-06-13T09:00:56Z Re: Servcietask‘s Transaction Problem https://connect.hyland.com/t5/alfresco-archive/servcietask-s-transaction-problem/m-p/144258#M100889 <HTML><HEAD></HEAD><BODY><SPAN>When you get an exception is this circumstances, it's due to your database closing the connecting because it has been open for too long. So you can change your database settings to allow a longer period of time for your connections. How much time are we talking about?</SPAN><BR /><SPAN>For the issue of the end time, can you create a unit test showing this issue?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Fri, 14 Jun 2013 08:05:47 GMT https://connect.hyland.com/t5/alfresco-archive/servcietask-s-transaction-problem/m-p/144258#M100889 trademak 2013-06-14T08:05:47Z