Could you please add some more log comments on various levels i.e. request received by servlet, connection called from connection pool, connection received, and then print connection object (it will print its reference) before using it and then check the connection, whether it is alive or not.
It should pin point the problem. - regards Raj (+91-11-31261821) -----Original Message----- From: Jignesh Patel [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 3:53 AM To: Struts Users Mailing List Subject: Re: Tomcat5 not logging me in It seems your database connection is not getting close. Your connection pool is not availalble after some time. Put all connection close code in finally block. -Jignesh On Mon, 2004-08-09 at 06:17, Rajesh wrote: > Hai all > > am using l Tomcat5, MySql, Struts 1.1 Linux. > > i had written a web applicaiton in tomcat with the support given above. > > i tested my site theroughly. its really working fine. but after a day or > so, when i try to login first time its not letting me to my home page. > > i think after a concesting access to DB the connection is freezes. > > below are th full diagnosis of my tomcat and db. > > in my DBCP i have given. > > <data-source type="org.apache.commons.dbcp.BasicDataSource"> > <set-property property="driverClassName" > value="com.mysql.jdbc.Driver"/> > <set-property property="url" > value="jdbc:mysql://ip address/contextname"/> > <set-property property="username" > value=""/> > <set-property property="password" > value=""/> > <set-property property="removeAbandoned" > value="true"/> > <set-property property="removeAbandonedTimeout" > value="60"/> > </data-source> > my Server status is > > ------------------------------------------------------------------------ > Server Status > > > Manager > List Applications </manager/html/list> HTML Manager Help > </manager/html-manager-howto.html> Manager Help > </manager/manager-howto.html> Complete Server Status </manager/status/all> > > > Server Information > Tomcat Version JVM Version JVM Vendor OS Name OS Version OS > Architecture > Apache Tomcat/5.0.25 1.4.2_02-b03 Sun Microsystems Inc. Linux > 2.4.20-020stab009.21.777-enterprise i386 > > > JVM > > Free memory: 42.25 MB Total memory: 63.31 MB Max memory: 63.31 MB > > > http-8080 > > Max threads: 15 Min spare threads: 5 Max spare threads: 10 Current > thread count: 5 Current thread busy: 1 > Max processing time: 4 ms Processing time: 0 s Request count: 1 Error > count: 0 Bytes received: 0.00 MB Bytes sent: 0.00 MB > > Stage Time B Sent B Recv Client VHost Request > *R* ? ? ? ? ? ? > *R* ? ? ? ? ? ? > > P: Parse and prepare request S: Service F: Finishing R: Ready K: Keepalive > > > jk8009 > > Max threads: 200 Min spare threads: 4 Max spare threads: 50 Current > thread count: 8 Current thread busy: 3 > > > > after restarting my tomcat its working fine. > > am fasing the problem many times > > can anybody kindly help me > > thankyou > Rajesh --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
