Change ... <value>jdbc:mysql://127.0.0.1:3306/otrosservicios?autoReconect=true</value>
to <value>jdbc:mysql://127.0.0.1:3306:/otrosservicios?autoReconnect=true</value> On Wed, 2003-03-12 at 16:35, Dionisio Ruiz de Zarate wrote: > 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] -- p niemandt <[EMAIL PROTECTED]> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
