Re: Tomcat5 not logging me in

[Rajesh <ra...@gkbcinc.com>]

Hai Patel

i kept it as first preference ya

i am clossing and also used = null to all objects which is not used.



Jignesh Patel wrote:

>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: user-unsubscribe@struts.apache.org
>For additional commands, e-mail: user-help@struts.apache.org
>
>
>  
>


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