[jbpm-dev] [jbpm 5.2] delete task rows when a process ends

[Mauricio Salatino]

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.


On Mon, Mar 12, 2012 at 3:26 PM, Giovanni Marigi <gmarigi at redhat.com> wrote:

> 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)
> 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.
>
> Thanks,
> Giovanni
>
> ----- Original Message -----
> From: "Mauricio Salatino" <salaboy at gmail.com>
> To: "Giovanni Marigi" <gmarigi at redhat.com>
> Cc: jbpm-dev at lists.jboss.org
> Sent: Monday, March 12, 2012 4:21:50 PM
> Subject: Re: [jbpm-dev] [jbpm 5.2] delete task rows when a process ends
>
> 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.
> If you want to do some clean ups you will need to write the right sql
> queries against the human task server schemas
>
>
> On Mon, Mar 12, 2012 at 2:43 PM, Giovanni Marigi < gmarigi at redhat.com >
> wrote:
>
>
> Hi,
> currently when a process instance ends, every task linked to this process
> (even if in state Completed) is not deleted from DBMS.
> Is there a way to change this behaviour and delete all task data persisted
> on DBMS when a process ends?
>
> Thanks,
> Giovanni
>
> --
> Giovanni Marigi
> Red Hat - JBoss Consultant -
> email: gmarigi at redhat.com
> Mobile: +39 3423175986
> Office: +39 0687502315
>
> Red Hat Italy
> Via Andrea Doria 41m
> 00192 Roma - Italy
> www.redhat.com
>
> Prima di stampare, pensa all'ambiente ** Think about the environment
> before printing
> _______________________________________________
> jbpm-dev mailing list
> jbpm-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jbpm-dev
>
>
>
>
> --
> - MyJourney @ http://salaboy.wordpress.com
> - Co-Founder @ http://www.jugargentina.org
> - Co-Founder @ http://www.jbug.com.ar
>
> - Salatino "Salaboy" Mauricio -
>
> --
> Giovanni Marigi
> Red Hat - JBoss Consultant -
> email: gmarigi at redhat.com
> Mobile: +39 3423175986
> Office: +39 0687502315
>
> Red Hat Italy
> Via Andrea Doria 41m
> 00192 Roma - Italy
> www.redhat.com
>
> Prima di stampare, pensa all'ambiente ** Think about the environment
> before printing
>



-- 
 - MyJourney @ http://salaboy.wordpress.com
 - Co-Founder @ http://www.jugargentina.org
 - Co-Founder @ http://www.jbug.com.ar

 - Salatino "Salaboy" Mauricio -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jbpm-dev/attachments/20120312/f144f056/attachment.html