Hi. I got a HTML form that allows a user to enter freehand SQL statements into a textfield and send them to a DB2 database via a SQL Java servlet. 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:
"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:
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)
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
Time: 1/27/2003 1:04:11 PM GMT"
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 this lends me to believe I need to configure my Tomcat somehow, 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? Can anyone tell me what's setting or enforcing my connection timeout? Thanks in advance. I've increased my session timeout, but still the same problem.