Seems that my file didn't go through, I've committed it so you can find it here:
http://svn.apache.org/repos/asf/ode/trunk/dao-hibernate/etc/terminated_processes_cleanup.sql Cheers, Matthieu On Thu, May 22, 2008 at 4:55 PM, Matthieu Riou <[EMAIL PROTECTED]> wrote: > Hi, > > I attached a little SQL script to this e-mail that does just that. It's > rather aggressive, cleaning up everything related to a completed instance > and more, but you can tweak it to your will. What most people do is > customize the script to remove only what they want to and run it regularly > (using a cron job or similar). > > Cheers, > Matthieu > > > On Thu, May 22, 2008 at 4:33 PM, Alex Boisvert <[EMAIL PROTECTED]> > wrote: > >> Hi Vipul, >> >> In your case, you can run the process "in-memory" >> http://ode.apache.org/user-guide.html#UserGuide-Inmemoryexecution >> >> Otherwise, you have to issue SQL statements to remove the process data >> from >> the database... >> >> The BPEL <exit> activity just terminates the process. It does not have >> any >> bearing on the persistence of process data. >> >> alex >> >> >> On Thu, May 22, 2008 at 4:15 PM, Vipul Sabhaya <[EMAIL PROTECTED]> >> wrote: >> >> > >> > How do you get ODE to remove state of a Process that finished? The 3 >> > processes I have are pretty simple.. they have the following Sequence: >> > - Receive >> > - Invoke >> > - Reply >> > - Exit >> > >> > I thought Exit would "clean-up" all state associated with a Process -- >> > doesn't seem like this is happening. Is there something in the >> Deployment >> > Descriptor i need to set? >> > >> > >> > <html><P> </P></html> >> > >> > > Date: Thu, 22 May 2008 21:46:47 +0100 >> > > From: [EMAIL PROTECTED] >> > > To: [email protected] >> > > Subject: Re: Database Size >> > > >> > > On Thu, May 22, 2008 at 7:23 PM, Vipul Sabhaya < >> [EMAIL PROTECTED] >> > > >> > > wrote: >> > > >> > > > >> > > > I am running ODE on a Solaris box within Tomcat. Currently there >> are 3 >> > > > BPEL Processes running on this intance which is with each process >> being >> > run >> > > > roughly once per second. >> > > > >> > > > The data folder (jpadb) which contains Derby files keeps increasing >> in >> > size >> > > > (already over 2 Gigs)... My question is why are we seeing this? and >> how >> > much >> > > > disk space should be reserved for ODE? >> > > >> > > Related to this, is it possible to configure ODE to keep only 'so >> much' >> > > data, i.e I don't neccessarily care about processes that >> > > completed(successfully or otherwise) last week, but I do very much >> care >> > > about the last 8 hours or so ? >> > > - Ciaran >> > >> > _________________________________________________________________ >> > Change the world with e-mail. Join the i'm Initiative from Microsoft. >> > >> http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ChangeWorld >> > >
