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]
