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