topic Multi-threading and transactions in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/multi-threading-and-transactions/m-p/179378#M132508 <HTML><HEAD></HEAD><BODY><SPAN>Within a repository action, we need to run some CPU-eating code that would benefit well from multi-threading. The main problem is that this code is accessing content from Alfresco (read and write), which means it needs authentication and an active transaction.</SPAN><BR /><BR /><SPAN>I tried several approaches already with no success so far. I think we get two options here:</SPAN><BR /><UL><LI>Start threads within the current transaction and ensure that they are able to re-use the current transaction. I would assume that transaction information is stored in some ThreadLocal facility, which means that using a common ThreadGroup could be a way to let the child threads re-use the transaction.</LI><BR /><LI>Pass a current transaction reference to the child threads and then start a new nested transaction in each thread.</LI></UL><SPAN>In each case, the main objective is to let all work from all threads be commited or rolled back at once.</SPAN><BR /><BR /><SPAN>To illustrate my point, here is small piece of code:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />final NodeRef nodeRef = …<BR /><BR />newTransaction();<BR /><BR />final Thread thread = new Thread(new Runnable()<BR />{<BR />&nbsp;&nbsp;&nbsp;public void run()<BR />&nbsp;&nbsp;&nbsp;{<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;nodeService.addAspect(nodeRef, ContentModel.ASPECT_CLASSIFIABLE, null);<BR />&nbsp;&nbsp;&nbsp;});<BR /><BR />thread.start();<BR />thread.join();<BR /><BR />commit();<BR /><BR />newTransaction();<BR />assert nodeService.hasAspect(nodeRef, ContentModel.ASPECT_CLASSIFIABLE);<BR />commit();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>As you may have guessed already, newTransaction() and commit() are fictional methods.</SPAN><BR /><SPAN>The assertion fails. There is also some error in the console (uncaught exception obviously) regarding the missing active transaction that occurs during the run() method invocation from the child thread.</SPAN><BR /><BR /><SPAN>So, is there a way to run multiple threads within a transaction so that I can have the 3 other lazy CPU cores compute something for a change? <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></SPAN></BODY></HTML> Tue, 23 Sep 2008 16:39:36 GMT herve_quiroz 2008-09-23T16:39:36Z Multi-threading and transactions https://connect.hyland.com/t5/alfresco-archive/multi-threading-and-transactions/m-p/179378#M132508 Within a repository action, we need to run some CPU-eating code that would benefit well from multi-threading. The main problem is that this code is accessing content from Alfresco (read and write), which means it needs authentication and an active transaction.I tried several approaches already with Tue, 23 Sep 2008 16:39:36 GMT https://connect.hyland.com/t5/alfresco-archive/multi-threading-and-transactions/m-p/179378#M132508 herve_quiroz 2008-09-23T16:39:36Z Re: Multi-threading and transactions https://connect.hyland.com/t5/alfresco-archive/multi-threading-and-transactions/m-p/179379#M132509 <HTML><HEAD></HEAD><BODY><SPAN>I don't believe a single Alfresco transaction can be used in more than a single thread, in large part because Hibernate (the ORM tool Alfresco uses internally) doesn't support this mode of operation (Hibernate sessions do not support multi-threading - each thread must have its own Hibernate session).</SPAN><BR /><BR /><SPAN>Cheers,</SPAN><BR /><SPAN>Peter</SPAN></BODY></HTML> Tue, 23 Sep 2008 18:02:49 GMT https://connect.hyland.com/t5/alfresco-archive/multi-threading-and-transactions/m-p/179379#M132509 pmonks 2008-09-23T18:02:49Z Re: Multi-threading and transactions https://connect.hyland.com/t5/alfresco-archive/multi-threading-and-transactions/m-p/179380#M132510 <HTML><HEAD></HEAD><BODY><SPAN>I was more or less expecting such bad news… Since my post, I have read even more pages on the subject (hibernate vs threads).</SPAN><BR /><SPAN>Thanks for your help.</SPAN></BODY></HTML> Tue, 23 Sep 2008 20:53:44 GMT https://connect.hyland.com/t5/alfresco-archive/multi-threading-and-transactions/m-p/179380#M132510 herve_quiroz 2008-09-23T20:53:44Z