2 Replies Latest reply on Dec 27, 2011 8:28 AM by twizansk

Best practices for cleaning the jBPM database

twizansk Dec 26, 2011 9:20 AM

Hi,

What are the best practices for cleaning old processes, tasks and sessions from the database?

So far I've only managed to remove process instances using StatefulKnowledgeSession.abortProcessInstance but I still can't clean sessions, tasks, etc.

I can always do a direct DELETE on the database ables but I would rather use the jBPM API if it provides the functionality.

I imagine there is a correct way to do this that I'm simply not aware of.

Thanks

Tommer

1. Re: Best practices for cleaning the jBPM database

calca Dec 27, 2011 8:25 AM (in response to twizansk)

Hi Tommer,
Do you want to delete all jbpm5 data for your local (dev) environment? You can use

hibernate.hbm2ddl.auto=create

It will drop tbales and re create then at application startup.

Demian
Actions
2. Re: Best practices for cleaning the jBPM database

twizansk Dec 27, 2011 8:28 AM (in response to calca)

Hi Demian,

No, I want to perform regular maintenance where I delete tasks that are completed, sessions that are no longer active, human tasks that have expired, etc. I don't want to drop the entire database.

Thanks
Actions

Go to original post