One thing to consider. Take a look at the database and find out how many licenses you have. When I was an OJB/DBCP noob I had set the maxActive higher than the number of available connections in the database.
- Eric -----Original Message----- From: Dennis Bekkering [mailto:[EMAIL PROTECTED] Sent: Thursday, October 26, 2006 3:11 PM To: OJB Users List Subject: Re: Borrow broker from pool failed. in production server 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.createPer sistenceBroker(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerFactoryBaseImpl.defaultPersi stenceBroker(Unknown > Source) > at > org.apache.ojb.broker.PersistenceBrokerFactory.defaultPersistenceBroker( Unknown > Source) > at > ma.co.omnidata.framework.services.dao.ojb.OJBPersistenceService.getBroke r( > OJBPersistenceService.java:156) > at > ma.co.omnidata.framework.services.dao.ojb.OJBPersistenceService.newSessi on( > OJBPersistenceService.java:250) > at > ma.co.omnidata.framework.services.transaction.impl.TransactionManagerImp l.getTransaction > (TransactionManagerImpl.java:39) > at > ma.co.omnidata.framework.services.businessInterface.OMNIFacade.invokeSer vice > (OMNIFacade.java:55) > at > ma.co.omnidata.framework.services.ihm.struts.core.OMNIBaseAction.invokeB usiness > (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.handleDiscriminatio n( > HttpInboundLink.java:422) > at > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformatio n( > HttpInboundLink.java:319) > at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready( > HttpInboundLink.java:288) > at > com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscr iminaters > (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.createPer sistenceBroker(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerFactoryBaseImpl.defaultPersi stenceBroker(Unknown > Source) > at > org.apache.ojb.broker.PersistenceBrokerFactory.defaultPersistenceBroker( Unknown > Source) > at > ma.co.omnidata.framework.services.dao.ojb.OJBPersistenceService.getBroke r( > OJBPersistenceService.java:156) > at > ma.co.omnidata.framework.services.dao.ojb.OJBPersistenceService.newSessi on( > OJBPersistenceService.java:250) > at > ma.co.omnidata.framework.services.transaction.impl.TransactionManagerImp l.getTransaction > (TransactionManagerImpl.java:39) > at > ma.co.omnidata.framework.services.businessInterface.OMNIFacade.invokeSer vice > (OMNIFacade.java:55) > at > ma.co.omnidata.framework.services.ihm.struts.core.OMNIBaseAction.invokeB usiness > (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.handleDiscriminatio n( > HttpInboundLink.java:422) > at > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformatio n( > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]