Hello, is it possible to decompose your extension activity into a process, which will wait for few hours and invoke only quick parts of code?
On 12 May 2010 23:51, Waruna Ranasinghe <waruna...@gmail.com> wrote: > Hi devs, > > I have been writing a bpel extension activity which does an external service > call and waits for the response. > The activity itself is a blocking activity. It may have to wait for hours to > get the response, so that it may take hours to complete the activity. > > Problem is, If I create few instances from this process, after sometime it > will complain about getting database connections saying that "No > ManagedConnections available within configured blocking timeout ( 30000 [ms] > ) for pool > org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor" > > I think this happens due to the Extension activity which takes hours to get > completed, so that the db connection also holds on to it until the activity > get completed > > Therefore, If we can close the connection after external service call, I > think we can fix this issue. > > Any body aware of how to close the db connection within an extension > activity or any other work around?? > > > Thanks, > Waruna > > > -- > ----------------------------------------------------- > Regards, > Waruna Ranasinghe > BLOG: http://warunapw.blogspot.com > -- Regards, RafaĆ Rusin http://rrusin.blogspot.com