Re: Borrow broker from pool failed. in production server

thx for your reply.
so we use only the maxActive declared in OJB.properties. in the
repository.xml we dont use
the connection-pool elements.

regards.

On 10/26/06, Dennis Bekkering <[email protected]> wrote:
>
> when i have a quick look it seems to be about the broker pool and not
> the connection pool. Check your OJB.properties and set maxActive to
> the same value as maxActive of the connection pool settings in
> repository_database.xml. I am not sure about it but your problem
> happened to me once this way and it was solved by doing as i suggest.
>
> regards,
> Dennis
>
> 2006/10/26, Marwane <[email protected]>:
> > hi
> > we have a web application on production used about 500 users.
> > we use default value of ojb parameters (maxActif: 100 ....).
> > we are getting frequently the message indicating that we can't borrow
> > connection from pool. even if
> > we use maxActif in 1000 the problem persist.
> > we need your help and give us some leads.
> >
> > stack trace :
> >
> > org.apache.ojb.broker.PBFactoryException: Borrow broker from pool
> failed,
> > using PBKey org.apache.ojb.broker.PBKey: jcdAlias=default, user=db2bmce,
> > password=*****
> >     at java.lang.Throwable.<init>(Throwable.java:195)
> >     at java.lang.Exception.<init>(Exception.java:41)
> >     at java.lang.RuntimeException.<init>(RuntimeException.java:43)
> >     at org.apache.commons.lang.exception.NestableRuntimeException
> .<init>(
> > NestableRuntimeException.java:86)
> >     at org.apache.ojb.broker.OJBRuntimeException.<init>(Unknown Source)
> >     at org.apache.ojb.broker.PBFactoryException.<init>(Unknown Source)
> >     at
> >
> org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker
> (Unknown
> > Source)
> >     at
> >
> org.apache.ojb.broker.core.PersistenceBrokerFactoryBaseImpl.defaultPersistenceBroker
> (Unknown
> > Source)
> >     at
> > org.apache.ojb.broker.PersistenceBrokerFactory.defaultPersistenceBroker
> (Unknown
> > Source)
> >     at
> >
> ma.co.omnidata.framework.services.dao.ojb.OJBPersistenceService.getBroker(
> > OJBPersistenceService.java:156)
> >     at
> >
> ma.co.omnidata.framework.services.dao.ojb.OJBPersistenceService.newSession
> (
> > OJBPersistenceService.java:250)
> >     at
> >
> ma.co.omnidata.framework.services.transaction.impl.TransactionManagerImpl.getTransaction
> > (TransactionManagerImpl.java:39)
> >     at
> >
> ma.co.omnidata.framework.services.businessInterface.OMNIFacade.invokeService
> > (OMNIFacade.java:55)
> >     at
> >
> ma.co.omnidata.framework.services.ihm.struts.core.OMNIBaseAction.invokeBusiness
> > (OMNIBaseAction.java:120)
> >     at
> >
> com.rmawatanya.convergence.application.technique.habilitation.ihm.action.HabLogonAction.doExecute
> > (HabLogonAction.java:47)
> >     at
> >
> com.rmawatanya.convergence.application.technique.habilitation.ihm.action.HabLogonAction.execute
> > (HabLogonAction.java:35)
> >     at org.apache.struts.action.RequestProcessor.processActionPerform(
> > RequestProcessor.java:421)
> >     at org.apache.struts.action.RequestProcessor.process(
> > RequestProcessor.java:226)
> >     at org.apache.struts.action.ActionServlet.process(ActionServlet.java
> > :1164)
> >     at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java
> :415)
> >     at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
> >     at javax.servlet.http.HttpServlet.service(HttpServlet.java:851)
> >     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java:1246)
> >     at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(
> > ServletWrapper.java:380)
> >     at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest
> (
> > CacheServletWrapper.java:80)
> >     at com.ibm.ws.webcontainer.WebContainer.handleRequest(
> WebContainer.java
> > :1724)
> >     at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(
> > WCChannelLink.java:79)
> >     at
> >
> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(
> > HttpInboundLink.java:422)
> >     at
> >
> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(
> > HttpInboundLink.java:319)
> >     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(
> > HttpInboundLink.java:288)
> >     at
> >
> com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminaters
> > (NewConnectionInitialReadCallback.java:207)
> >     at
> com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete
> > (NewConnectionInitialReadCallback.java:109)
> >     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(
> > WorkQueueManager.java:537)
> >     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(
> > WorkQueueManager.java:593)
> >     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(
> > WorkQueueManager.java:946)
> >     at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(
> > WorkQueueManager.java:1038)
> >     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1446)
> > Caused by: java.util.NoSuchElementException
> >     at java.lang.Throwable.<init>(Throwable.java:180)
> >     at java.lang.Exception.<init>(Exception.java:29)
> >     at java.lang.RuntimeException.<init>(RuntimeException.java:32)
> >     at java.util.NoSuchElementException.<init>(
> NoSuchElementException.java
> > :28)
> >     at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(
> > GenericKeyedObjectPool.java:760)
> >     ... 31 more
> > [18/10/06 11:59:53:253 TUC] 00000379 SystemErr     R
> > org.apache.ojb.broker.PBFactoryException: Borrow broker from pool
> failed,
> > using PBKey org.apache.ojb.broker.PBKey: jcdAlias=default, user=db2bmce,
> > password=*****
> >     at java.lang.Throwable.<init>(Throwable.java:195)
> >     at java.lang.Exception.<init>(Exception.java:41)
> >     at java.lang.RuntimeException.<init>(RuntimeException.java:43)
> >     at org.apache.commons.lang.exception.NestableRuntimeException
> .<init>(
> > NestableRuntimeException.java:86)
> >     at org.apache.ojb.broker.OJBRuntimeException.<init>(Unknown Source)
> >     at org.apache.ojb.broker.PBFactoryException.<init>(Unknown Source)
> >     at
> >
> org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker
> (Unknown
> > Source)
> >     at
> >
> org.apache.ojb.broker.core.PersistenceBrokerFactoryBaseImpl.defaultPersistenceBroker
> (Unknown
> > Source)
> >     at
> > org.apache.ojb.broker.PersistenceBrokerFactory.defaultPersistenceBroker
> (Unknown
> > Source)
> >     at
> >
> ma.co.omnidata.framework.services.dao.ojb.OJBPersistenceService.getBroker(
> > OJBPersistenceService.java:156)
> >     at
> >
> ma.co.omnidata.framework.services.dao.ojb.OJBPersistenceService.newSession
> (
> > OJBPersistenceService.java:250)
> >     at
> >
> ma.co.omnidata.framework.services.transaction.impl.TransactionManagerImpl.getTransaction
> > (TransactionManagerImpl.java:39)
> >     at
> >
> ma.co.omnidata.framework.services.businessInterface.OMNIFacade.invokeService
> > (OMNIFacade.java:55)
> >     at
> >
> ma.co.omnidata.framework.services.ihm.struts.core.OMNIBaseAction.invokeBusiness
> > (OMNIBaseAction.java:120)
> >     at
> >
> com.rmawatanya.convergence.application.technique.habilitation.ihm.action.HabLogonAction.doExecute
> > (HabLogonAction.java:47)
> >     at
> >
> com.rmawatanya.convergence.application.technique.habilitation.ihm.action.HabLogonAction.execute
> > (HabLogonAction.java:35)
> >     at org.apache.struts.action.RequestProcessor.processActionPerform(
> > RequestProcessor.java:421)
> >     at org.apache.struts.action.RequestProcessor.process(
> > RequestProcessor.java:226)
> >     at org.apache.struts.action.ActionServlet.process(ActionServlet.java
> > :1164)
> >     at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java
> :415)
> >     at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
> >     at javax.servlet.http.HttpServlet.service(HttpServlet.java:851)
> >     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java:1246)
> >     at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(
> > ServletWrapper.java:380)
> >     at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest
> (
> > CacheServletWrapper.java:80)
> >     at com.ibm.ws.webcontainer.WebContainer.handleRequest(
> WebContainer.java
> > :1724)
> >     at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(
> > WCChannelLink.java:79)
> >     at
> >
> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(
> > HttpInboundLink.java:422)
> >     at
> >
> com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(
> > HttpInboundLink.java:319)
> >     at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete
> (
> > HttpICLReadCallback.java:84)
> >     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(
> > WorkQueueManager.java:537)
> >     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(
> > WorkQueueManager.java:593)
> >     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(
> > WorkQueueManager.java:946)
> >     at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(
> > WorkQueueManager.java:1038)
> >     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1446)
> > Caused by: java.util.NoSuchElementException
> >     at java.lang.Throwable.<init>(Throwable.java:180)
> >     at java.lang.Exception.<init>(Exception.java:29)
> >     at java.lang.RuntimeException.<init>(RuntimeException.java:32)
> >     at java.util.NoSuchElementException.<init>(
> NoSuchElementException.java
> > :28)
> >     at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(
> > GenericKeyedObjectPool.java:760)
> >     ... 29 more
> > [18/10/06 12:00:00:846 TUC] 00000379 SystemErr     R
> > org.apache.ojb.broker.PBFactoryException: Borrow broker from pool
> failed,
> > using PBKey org.apache.ojb.broker.PBKey: jcdAlias=default, user=db2bmce,
> > password=*****
> >     at java.lang.Throwable.<init>(Throwable.java:195)
> >     at java.lang.Exception.<init>(Exception.java:41)
> >     at java.lang.RuntimeException.<init>(RuntimeException.java:43)
> >     at
> >
> >
>
>
> --
> mvg,
> Dennis
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>