Return-Path: 
 <users-return-148367-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 51658 invoked from network); 20 Jul 2006 19:54:31 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 20 Jul 2006 19:54:31 -0000
Received: (qmail 4916 invoked by uid 500); 20 Jul 2006 18:30:35 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 4849 invoked by uid 500); 20 Jul 2006 18:30:35 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 4800 invoked by uid 99); 20 Jul 2006 18:30:35 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Jul 2006 11:30:35 -0700
X-ASF-Spam-Status: No, hits=1.2 required=10.0
	tests=RCVD_IN_SORBS_WEB
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [64.246.16.77] (HELO cpanel3.interactivedns.com) (64.246.16.77)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Jul 2006 11:30:33 -0700
Received: from [61.17.70.182] (helo=seetha)
	by cpanel3.interactivedns.com with esmtpsa (TLSv1:RC4-MD5:128)
	(Exim 4.52)
	id 1G3dHn-0001Dj-0B
	for users@tomcat.apache.org; Fri, 21 Jul 2006 00:00:12 +0530
Reply-To: <srao@vertizone.net>
From: "Seetha Rao" <srao@vertizone.net>
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Tomcat fails to refresh connections when mySQL server on linux is
 shutdown and restarted
Date: Fri, 21 Jul 2006 00:04:34 +0530
Message-ID: <OIEFIPBKHIHEGCAFGNHOCEFOCAAA.srao@vertizone.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
Importance: Normal
X-Antivirus-Scanner: Clean mail though you should still use an Antivirus
X-AntiAbuse: This header was added to track abuse,
 please include it with any abuse report
X-AntiAbuse: Primary Hostname - cpanel3.interactivedns.com
X-AntiAbuse: Original Domain - tomcat.apache.org
X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12]
X-AntiAbuse: Sender Address Domain - vertizone.net
X-Source: 
X-Source-Args: 
X-Source-Dir: 
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Hi,

We are doing a test where mySQL server goes down when user is accessing a
webapplication.
We have setup tomcat with the required parameters for DBCP to handle such a
case.
It works fine in a set up where Tomcat and mySQL are on the same windows
machine.
But in a setup where Tomcat is on Windows machine connecting to mySQL
running on a linux machine, it does not work.

Here are the versions:

Tomcat 5.0
mySQL 4.1
Linux 2.6 Fedora

We have configured Tomcat with the following in our webapp xml file (I'm
pasting a part of it)

<parameter>
<name>validationQuery</name>
<value>select 1</value>
</parameter>

<parameter>
<name>testOnBorrow</name>
<value>true</value>
</parameter>

<parameter>
<name>testWhileIdle</name>
<value>true</value>
</parameter>

<parameter>
<name>timeBetweenEvictionRunsMillis</name>
<value>10000</value>
</parameter>

<parameter>
<name>minEvictableIdleTimeMillis</name>
<value>60000</value>
</parameter>

<parameter>
<name>url</name>
<value>jdbc:mysql://190.162.50.20:3306/xyz_office?autoReconnect=true</value>
</parameter>

Here is the test we are doing;
1. Enter the web application, do something which accesses the database
2. Stop mysql server and restart on linux
3. Try to do something in the web application
4. Tomcat gives the following exception

stdout.log

java.sql.SQLException: No operations allowed after statement closed.
This comes many many times, basically an overflow.

In the browser:

javax.servlet.ServletException: Servlet execution threw an exception

org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670
)
	org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:637)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:46)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
24)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:10
69)

org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProces
sor.java:455)

org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

This comes many many times, basically an overflow.

root cause

java.lang.StackOverflowError

org.apache.coyote.tomcat5.CoyoteRequest.getAttribute(CoyoteRequest.java:909)

org.apache.coyote.tomcat5.CoyoteRequestFacade.getAttribute(CoyoteRequestFaca
de.java:214)

Could anyone please give us some hints?

Thanks
Seetha


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org