apache_tomcat thread: Tomcat 4.1: IE6 web-bases SQL servlet connection timeout error
Hi. I got a HTML form that allows a user to enter freehand SQL statements
and send them to a DB2 database via a SQL Java servlet via standalone
Tomcat version 4.1.18. After the query executes, it returns an Excel file
containing the resultset of my query. Unfortunately, I got a query that
when executed, my browser returns an error:
------begin error statement--------------
"The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be
displayed.
Please try the following:
Click the Refresh <javascript:location.reload()> button, or try again
later.
Open the anonymous home page, and then look for links to the information
you want.
If you believe you should be able to view this directory or page, please
contact the Web site administrator by using the e-mail address or phone
number listed on the anonymous home page.
10060 - Connection timeout
Internet Security and Acceleration Server
Technical Information (for support personnel)
Background:
The gateway could not receive a timely response from the Web site you are
trying to access. This might indicate that the network is congested, or
that the Web site is experiencing technical difficulties.
ISA Server: MMPINF17
Via:
Time: 1/27/2003 1:04:11 PM GMT"
---end error statement-------------
With another query with different set of criteria, it runs fine-so my
Tomcat is running fine. I've executed the same exact query in Excel via
JDBC-ODBC bridge Java application and it ran fine and also executed the
same query in QMF for Windows, and it ran fine also. So it's not an issue
of my query pulling in too much data and I'm also using the table
indices. So this lends me to believe I need to configure my Tomcat
somehow or my browser, I presume the connection timeout limit.
In the server.xml file in the conf folder, I set the connection timeout
to "-1", but still got the error. So now I'm wondering if perhaps my
company's firewall adminstrator has set a connection timeout or does
Internet Explorer have a connection timeout option? I did a search
on "10060 connection timeout" and found links that talk about changing my
registery or installing a service pack, but most were in reference to IE
verion 4, I'm using version 6. Also, my regedit is disabled in my
computer at work and I noticed my IE at work has the options in
the "Connections" tab disabled. Can anyone tell what I can do to get
around this. Thanks in advance.
-Dan