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]