what must i to put? reconnect or Reconnect o reconect or reconnect? can you help me? thanks ----- Original Message ----- From: "Gerlinde Fischer" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 2:22 PM Subject: AW: great problem with dbcp conn pool
> hi, > in your orginial server.xml, > is there also "reconect" instead of "reconnect". > > Regards Gerlinde > > > -----Ursprüngliche Nachricht----- > > Von: Dionisio Ruiz de Zarate [mailto:[EMAIL PROTECTED] > > Gesendet: Mittwoch, 12. März 2003 14:10 > > An: [EMAIL PROTECTED] > > Betreff: great problem with dbcp conn pool > > > > > > hello y ahave the next conf in my server.xml file but appears the bellow > > error, not always, only if i not acess to the page in several hours. > > can you help me? > > thanks > > > > CONF (server.xml): > > <Resource name="jdbc/otrosservicios" auth="Container" > > type="javax.sql.DataSource"/> > > <ResourceParams name="jdbc/otrosservicios"> > > <parameter> > > <name>factory</name> > > > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > > </parameter> > > <parameter> > > <name>maxActive</name> > > <value>100</value> > > </parameter> > > <parameter> > > <name>maxIdle</name> > > <value>30</value> > > </parameter> > > <parameter> > > <name>maxWait</name> > > <value>-1</value> > > </parameter> > > <parameter> > > <name>username</name> > > <value>user</value> > > </parameter> > > <parameter> > > <name>password</name> > > <value>passwd</value> > > </parameter> > > <parameter> > > <name>driverClassName</name> > > <value>com.mysql.jdbc.Driver</value> > > </parameter> > > <parameter> > > <name>url</name> > > > > <value>jdbc:mysql://127.0.0.1:3306/otrosservicios?autoReconect=tru > > e</value> > > </parameter> > > <parameter> > > <name>removeAbandoned</name> > > <value>true</value> > > </parameter> > > <parameter> > > <name>removeAbandonedTimeout</name> > > <value>120</value> > > </parameter> > > <parameter> > > <name>logAbandoned</name> > > <value>true</value> > > </parameter> > > </ResourceParams> > > > > > > > > > > ERROR: > > org.apache.jasper.JasperException: Communication link failure: > > java.net.SocketException > > at > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrap > > per.java:2 > > 48) > > at > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > > at > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A > > pplication > > FilterChain.java:247) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati > > onFilterCh > > ain.java:193) > > at utils.filtroSessiones.doFilter(filtroSessiones.java:141) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A > > pplication > > FilterChain.java:213) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati > > onFilterCh > > ain.java:193) > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > > erValve.ja > > va:260) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon > > text.invok > > eNext(StandardPipeline.java:643) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardConte > > xtValve.ja > > va:191) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon > > text.invok > > eNext(StandardPipeline.java:643) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValv > > e.java:180 > > ) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon > > text.invok > > eNext(StandardPipeline.java:643) > > at > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat > > cherValve. > > java:170) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon > > text.invok > > eNext(StandardPipeline.java:641) > > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv > > e.java:172 > > ) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon > > text.invok > > eNext(StandardPipeline.java:641) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngine > > Valve.java > > :174) > > at > > org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon > > text.invok > > eNext(StandardPipeline.java:643) > > at > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > java:480) > > at > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at > > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) > > at > > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:261) > > at > > org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360) > > at > > org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:632) > > at > > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket > > .java:590) > > at > > org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:707) > > at > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Thre > > adPool.jav > > a:530) > > at java.lang.Thread.run(Thread.java:536) > > > > > > > > --------------------------------------------------------------------- > > 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]
