Yes, I had the same problem before. I did the follwoing things to fix the
problem:
1) add "autoReconeet=true" in the url like:
<data-sources>
<data-source autoCommit="false"
description="My App Data"
driverClass="com.mysql.jdbc.Driver"
maxCount="4"
minCount="2"
user="myUser"
password="foobar"
url="jdbc:mysql://localhost:3306/myAppDB?autoReconnect=true"/>
</data-sources>
2) I noticed the free memory was going down every time a user hit the site.
Finally, I found there was memory leak that caused my app failed over time.
One more thing, you may try the Connect/J mysql driver, it takes less
memory.
Hope this help!
Billy Ng
>From: Alex McLintock <[EMAIL PROTECTED]>
>Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Hanging Struts
>Date: Tue, 03 Sep 2002 17:44:29 +0100
>
>Hi folks,
>
>I have a simple Struts application which decides to hang and not serve
>pages after some time. It seems to be database related because the index
>pages which don't require the database still work, whereas the ones which
>require the database don't respond.
>
>The database appears to be still working since other things can access it
>fine. A restart of tomcat fixes the problem - but that of course is hardly
>a permanent solution.
>
>I am using a fairly recent version of struts, Tomcat 4.13b, a farily recent
>MySQL, RedHat 7.2, mm.jdbc driver,
>
>I see on this mailing list that other people have had problems with hanging
>if left "overnight". I have tried to use a "refresh" setting in my
>struts-config.xml but that doesn;t seem to have cured the problem.
>
>Alex
>
>
>
>
>
>
>Openweb Analysts Ltd, London.
>Software For Complex Websites http://www.OWAL.co.uk/
>Open Source Software Companies please register here
>http://www.OWAL.co.uk/oss_support/
>
>
>--
>To unsubscribe, e-mail:
><mailto:[EMAIL PROTECTED]>
>For additional commands, e-mail:
><mailto:[EMAIL PROTECTED]>
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
