I give you as well my connection configuration : <jdbc-connection-descriptor dbalias="//localhost:3306/housebooking?autoReconnect=true" default-connection="true" driver="org.gjt.mm.mysql.Driver" jcd-alias="myConnection" jdbc-level="2.0" password="<password>" platform="MySQL" protocol="jdbc" subprotocol="mysql" useAutoCommit="1" username="christophe"> <connection-pool logAbandoned="false" maxActive="100" maxIdle="30" maxWait="10000" removeAbandoned="true" removeAbandonedTimeout="60"/> <sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerInMemoryImpl"/ > </jdbc-connection-descriptor>
cheers. Christophe ----- Original Message ----- From: "Christophe Marcourt" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]>; "Armin Waibel" <[EMAIL PROTECTED]> Sent: Thursday, July 03, 2003 11:20 PM Subject: Re: Borrow broker from pool failed > Here you go : > > org.apache.ojb.broker.PBFactoryException: Borrow broker from pool failed > 2003-07-03 22:39:51,125 FATAL [Thread-5] - > org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersist > enceBroker(Unknown Source) > 2003-07-03 22:39:51,125 FATAL [Thread-5] - > org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.defaultPersis > tenceBroker(Unknown Source) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > org.apache.ojb.broker.PersistenceBrokerFactory.defaultPersistenceBroker(Unkn > own Source) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > com.hbk.admin.form.RoomParameter.doDefault(RoomParameter.java:152) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > com.celeno.mandarino.form.AbstractFormDispatch.process(AbstractFormDispatch. > java:175) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > com.celeno.mandarino.Controller.handleRequest(Controller.java:117) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > org.apache.velocity.servlet.VelocityServlet.doRequest(VelocityServlet.java:3 > 72) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > org.apache.velocity.servlet.VelocityServlet.doGet(VelocityServlet.java:333) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > javax.servlet.http.HttpServlet.service(HttpServlet.java:740) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > FilterChain.java:247) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:193) > 2003-07-03 22:39:51,126 FATAL [Thread-5] - > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > va:256) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > va:191) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase > .java:494) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:641) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > 2003-07-03 22:39:51,127 FATAL [Thread-5] - > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 > ) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. > java:171) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:641) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 > ) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:641) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > :174) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok > eNext(StandardPipeline.java:643) > 2003-07-03 22:39:51,128 FATAL [Thread-5] - > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > 2003-07-03 22:39:51,129 FATAL [Thread-5] - > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > 2003-07-03 22:39:51,129 FATAL [Thread-5] - > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) > 2003-07-03 22:39:51,129 FATAL [Thread-5] - > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594) > 2003-07-03 22:39:51,129 FATAL [Thread-5] - > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne > ction(Http11Protocol.java:392) > 2003-07-03 22:39:51,129 FATAL [Thread-5] - > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) > 2003-07-03 22:39:51,129 FATAL [Thread-5] - > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav > a:619) > 2003-07-03 22:39:51,129 FATAL [Thread-5] - > java.lang.Thread.run(Thread.java:536) > > By the way I do close() my broker every time I use it. > > Christophe > > ----- Original Message ----- > From: "Armin Waibel" <[EMAIL PROTECTED]> > To: "OJB Users List" <[EMAIL PROTECTED]> > Sent: Thursday, July 03, 2003 11:18 PM > Subject: Re: Borrow broker from pool failed > > > > Can you post the whole stack trace, please? > > > > regards, > > Armin > > > > ----- Original Message ----- > > From: "Christophe Marcourt" <[EMAIL PROTECTED]> > > To: "OJB Users List" <[EMAIL PROTECTED]> > > Sent: Thursday, July 03, 2003 10:52 PM > > Subject: Borrow broker from pool failed > > > > > > > Hi, > > > > > > after a couple of hours of inactivity I get a "Borrow broker from pool > > > failed" when I request a page on my site where's OJB make a simple > > SELECT > > > query. > > > I'm using MySQL 4 and OJB 1.0 rc3. > > > > > > Any idea ? > > > > > > Christophe > > > > > > > > > --- > > > Ce message Envoi est certifié sans virus connu. > > > Protégé par l'antivirus AVG Deluxe. > > > Version: 6.0.492 / Base de données virus: 291 - Date: 24/06/2003 > > > > > > > > > --------------------------------------------------------------------- > > > 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] > > > > > --- > Ce message Envoi est certifié sans virus connu. > Protégé par l'antivirus AVG Deluxe. > Version: 6.0.492 / Base de données virus: 291 - Date: 24/06/2003 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --- Ce message Envoi est certifié sans virus connu. Protégé par l'antivirus AVG Deluxe. Version: 6.0.492 / Base de données virus: 291 - Date: 24/06/2003 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]