Hi Muthuswamy
Please help me . I am fed up of this . Each time a new connection is
made to database new port is open and when connection is closed port goes
into CLOSE_WAIT state.
messages increases like this
solaris.33915 solaris.3306 32768 0 32768 0
CLOSE_WAIT
solaris.33917 solaris.3306 32768 0 32768 0
CLOSE_WAIT
solaris.33919 solaris.3306 32768 0 32768 0
CLOSE_WAIT
solaris.33921 solaris.3306 32768 0 32768 0
CLOSE_WAIT
solaris.33923 solaris.3306 32768 0 32768 0
CLOSE_WAIT
solaris.33925 solaris.3306 32768 0 32768 0
CLOSE_WAIT
are you servlets programmer if you have time could i post you sample code.
regards sajida.
----- Original Message -----
From: R MUTHUSWAMY <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 15, 2000 10:38 AM
Subject: Socket connection to database does not close problem with servlets
on linux (fwd)
>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
___________________________________________________________________________
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
