struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Billy Ng" <evebi...@hotmail.com>
Subject Re: Hanging Struts
Date Tue, 03 Sep 2002 16:55:01 GMT
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 <alex@OWAL.co.uk>
>Reply-To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
>To: struts-user@jakarta.apache.org
>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:struts-user-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: 
><mailto:struts-user-help@jakarta.apache.org>




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com


--
To unsubscribe, e-mail:   <mailto:struts-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:struts-user-help@jakarta.apache.org>


Mime
View raw message