I think I found the problem. I made a mistake when I post my jdbc connection configuration. When this error occurs, there was no autoReconnect=true in the dbalias attribute. Now that I set again this parameter in the dbalias, there is no problem. The connection between MySQL and OJB is correct.
Christophe. > Message du 04/07/03 13:52 > De : Jo�o Luz <[EMAIL PROTECTED]> > A : OJB Users List <[EMAIL PROTECTED]> > Copie � : > Objet : RE: Borrow broker from pool failed > Try to add validationQuery="select 1" to connection-pool. > > -----Original Message----- > From: Christophe Marcourt [mailto:[EMAIL PROTECTED] > Sent: quinta-feira, 3 de Julho de 2003 22:29 > To: OJB Users List > Subject: Re: Borrow broker from pool failed > > > 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] > > > --------------------------------------------------------------------- > 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]
