hi,

check out in the server if the connection has got close. In general,
the data and ack. is sent from one side and come to the close-wait at the
one end. and it waits for the other end to send the data and ack. if that
end doesn't send a ack. then the state will be like that. check out in the
other side you have anything like that or you have any logs for the
database transaction and any fault in that. please reply..

-muthu.


    I am working on Apache Jserv1.0, Apache Server and Mysql database on  redhat 6.0 
linux machine. I am using mm_mysql_jdbc-1_0_tar driver (type 4) for database 
connection. Problem that i facing is that
when i run servlets that make jdbc connection to mysql database it does not closes the 
database connection although i have closed both the statement object and database 
connection when i see tcp connection information on system it shows the following 
message


64 tcp 1 0 db.isb.sdnpk.org:1047   db.isb.sdnpk.org:mysql  CLOSE_WAIT 389/java

these messages increases with the passage of time till system haults  in after two or 
three days . can any body please help me out. whats the reason for this.

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to