Sure, that can be contributed back as an extension. If you can create a JPA query that do what your store procedure is doing we can provide a way to execute that, or let the user defines when and how he/she wants to do the clean ups.<div>
<br><br><div class="gmail_quote">On Mon, Mar 12, 2012 at 3:26 PM, Giovanni Marigi <span dir="ltr"><<a href="mailto:gmarigi@redhat.com">gmarigi@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I created a stored procedure scheduled with a job that delete all tasks data related to a non existing process instance (it runs once a day)<br>
I think anyway the problem must be faced because when you handle many process instances every day your JBPM database will grow fast and it becomes an issue in production.<br>
<br>
Thanks,<br>
Giovanni<br>
<div class="HOEnZb"><div class="h5"><br>
----- Original Message -----<br>
From: "Mauricio Salatino" <<a href="mailto:salaboy@gmail.com">salaboy@gmail.com</a>><br>
To: "Giovanni Marigi" <<a href="mailto:gmarigi@redhat.com">gmarigi@redhat.com</a>><br>
Cc: <a href="mailto:jbpm-dev@lists.jboss.org">jbpm-dev@lists.jboss.org</a><br>
Sent: Monday, March 12, 2012 4:21:50 PM<br>
Subject: Re: [jbpm-dev] [jbpm 5.2] delete task rows when a process ends<br>
<br>
Not really. usually BPMS are good to keep track about that the work that has being done. The human task server will keep track and record all your human activities.<br>
If you want to do some clean ups you will need to write the right sql queries against the human task server schemas<br>
<br>
<br>
On Mon, Mar 12, 2012 at 2:43 PM, Giovanni Marigi < <a href="mailto:gmarigi@redhat.com">gmarigi@redhat.com</a> > wrote:<br>
<br>
<br>
Hi,<br>
currently when a process instance ends, every task linked to this process (even if in state Completed) is not deleted from DBMS.<br>
Is there a way to change this behaviour and delete all task data persisted on DBMS when a process ends?<br>
<br>
Thanks,<br>
Giovanni<br>
<br>
--<br>
Giovanni Marigi<br>
Red Hat - JBoss Consultant -<br>
email: <a href="mailto:gmarigi@redhat.com">gmarigi@redhat.com</a><br>
Mobile: <a href="tel:%2B39%203423175986" value="+393423175986">+39 3423175986</a><br>
Office: <a href="tel:%2B39%200687502315" value="+390687502315">+39 0687502315</a><br>
<br>
Red Hat Italy<br>
Via Andrea Doria 41m<br>
00192 Roma - Italy<br>
<a href="http://www.redhat.com" target="_blank">www.redhat.com</a><br>
<br>
Prima di stampare, pensa all'ambiente ** Think about the environment before printing<br>
_______________________________________________<br>
jbpm-dev mailing list<br>
<a href="mailto:jbpm-dev@lists.jboss.org">jbpm-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/jbpm-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/jbpm-dev</a><br>
<br>
<br>
<br>
<br>
--<br>
- MyJourney @ <a href="http://salaboy.wordpress.com" target="_blank">http://salaboy.wordpress.com</a><br>
- Co-Founder @ <a href="http://www.jugargentina.org" target="_blank">http://www.jugargentina.org</a><br>
- Co-Founder @ <a href="http://www.jbug.com.ar" target="_blank">http://www.jbug.com.ar</a><br>
<br>
- Salatino "Salaboy" Mauricio -<br>
<br>
--<br>
Giovanni Marigi<br>
Red Hat - JBoss Consultant -<br>
email: <a href="mailto:gmarigi@redhat.com">gmarigi@redhat.com</a><br>
Mobile: <a href="tel:%2B39%203423175986" value="+393423175986">+39 3423175986</a><br>
Office: <a href="tel:%2B39%200687502315" value="+390687502315">+39 0687502315</a><br>
<br>
Red Hat Italy<br>
Via Andrea Doria 41m<br>
00192 Roma - Italy<br>
<a href="http://www.redhat.com" target="_blank">www.redhat.com</a><br>
<br>
Prima di stampare, pensa all'ambiente ** Think about the environment before printing<br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br> - MyJourney @ <a href="http://salaboy.wordpress.com" target="_blank">http://salaboy.wordpress.com</a><div> - Co-Founder @ <a href="http://www.jugargentina.org" target="_blank">http://www.jugargentina.org</a><br>
- Co-Founder @ <a href="http://www.jbug.com.ar" target="_blank">http://www.jbug.com.ar</a><br> <br> - Salatino "Salaboy" Mauricio -</div><br>
</div>