Thanks once again.

-Nanda


-----Original Message-----
From: Tobias Meyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 30, 2005 2:51 PM
To: 'Tomcat Users List'
Subject: Re: Error: Io exception: Connection reset 


ValidationQuery does an additional query before the connection is returned
from the pool.
If the Validation fails, the pooled connection is dropped and a new
connection is initiated.

see:
http://jakarta.apache.org/commons/dbcp/configuration.html

Cheers,
Tobias

-----Ursprüngliche Nachricht-----
Von: KUMAR, NANDA [AG-Contractor/1000] [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 30. November 2005 16:29
An: 'Tomcat Users List'
Betreff: 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]


---------------------------------------------------------------------------------------------------------
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]

Reply via email to