Thanks a lot Martin. Nanda
-----Original Message----- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 10:13 AM To: Tomcat Users List Subject: Re: Error: Io exception: Connection reset This is Straight from the Tomcat 5.0 docs located at http://tomcat.apache.org/tomcat-5.0-doc/jndi-resources-howto.html validationQuery - SQL query that can be used by the pool to validate connections before they are returned to the application. If specified, this query MUST be an SQL SELECT statement that returns at least one row. Viel Gluck, Martin Gainty ----- Original Message ----- From: "KUMAR, NANDA [AG-Contractor/1000]" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <users@tomcat.apache.org> Sent: Wednesday, November 30, 2005 10:29 AM Subject: RE: Error: Io exception: Connection reset Thanks Tobias, I will try as you mentioned below. Could you please let me know what "validationQuery" parameter does and where I can find these information on tomcat documentation. -Nanda -----Original Message----- From: Tobias Meyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 12:38 AM To: 'Tomcat Users List' Subject: AW: Error: Io exception: Connection reset Maybe the user hit the "stop" button on the browser while downloading a page or binary. IIRC this will give you IOExceptions in your servlet when trying to push more data in the "dead" connection. It could also be your firewall, that times out connections which have not been used for some time. If you use tomcat connection pooling, try using <parameter> <name>validationQuery</name> <value>select 1</value> </parameter> in the ResourceParams of your jdbc connection definition in server.xml (see tomcat documentation for details) Hth, Tobias > -----Ursprüngliche Nachricht----- > Von: KUMAR, NANDA [AG-Contractor/1000] > [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 30. November 2005 00:54 > An: users@tomcat.apache.org > Betreff: Error: Io exception: Connection reset > > > Very often we are getting Io Exception: Connection reset > error. There is a > firewall between tomcat app server and DB server. > I wonder whether firewall is closing the connection or what > could be the > reason. Please let me know how to get rid of this error. > > Thanks in advance. > > > > -------------------------------------------------------------- > ------------------------------------------- > This e-mail message may contain privileged and/or > confidential information, and is intended to be received only > by persons entitled to receive such information. If you have > received this e-mail in error, please notify the sender > immediately. Please delete it and all attachments from any > servers, hard drives or any other media. Other use of this > e-mail by you is strictly prohibited. > > > All e-mails and attachments sent and received are subject to > monitoring, reading and archival by Monsanto. The recipient > of this e-mail is solely responsible for checking for the > presence of "Viruses" or other "Malware". Monsanto accepts no > liability for any damage caused by any such code transmitted > by or accompanying this e-mail or any attachment. > -------------------------------------------------------------- > ------------------------------------------- > > > --------------------------------------------------------------------- > 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] ---------------------------------------------------------------------------- ----------------------------- This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited. All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto. The recipient of this e-mail is solely responsible for checking for the presence of "Viruses" or other "Malware". Monsanto accepts no liability for any damage caused by any such code transmitted by or accompanying this e-mail or any attachment. ---------------------------------------------------------------------------- ----------------------------- --------------------------------------------------------------------- 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]
