Hi, Samuel,
thanks first.
I define connection as instance variable and create
connection in the init method like:
public synchronized void init (ServletConfig config)
throws ServletException {
try {
super.init();
} catch(Exception ex) {
System.out.println(ex.getMessage());
}
// establish connection
try{
conn = getConnected();
} catch(Exception ex) {
System.out.println(ex.getMessage());
as i know the connection will closed automatically
when servlet is unload or stoped. so in my application
i didn't close connection just close statment created
by connection. is this the problem?
and where i can check how many process in mysql?
Very appreciate your help.
--- Samuel Chen <[EMAIL PROTECTED]> wrote:
> You might check out how many mysql processes are
> running.
> If you did not close the database connections
> properly,
> mysql will have to open too many connections and
> eventually
> everything will be slowed down, even your servlet
> engine can be crashed.
>
> Sam.
> --------------------------------------
> Need a Bug Tracking System?
> Try http://www.websina.com/bugzero/
> --------------------------------------
>
>
>
> ----- Original Message -----
> From: "bin cai" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, August 12, 2002 8:58 AM
> Subject: connection reset by peer, system slow down
>
>
> > Hello,
> > I got one serious problem. any help will be
> > appreciated very much. Thanks in advance.
> > my project is about online exam. students take
> exam
> > through internet.This sytem is developed by java
> > servlet, html, mysql and tomcat 3.2.3. Last Friday
> we
> > have a test on my system. some students took the
> exam
> > for half hour.
> > It seemed ok. after exam, we (3 guys) had a
> further
> > tesing on my system. we try to log to system using
> > different login ids at the same machine. or using
> same
> > loin id to log to sytem at different machines. but
> the
> > sytem suddenly slow down. very slow. when i check
> the
> > server, find the waning message like "socket
> > exception....connection reset by peer.
> > I read some documentation about this error. i was
> > informed that the message will happen when client
> send
> > another request before the previous request is
> > returned. it will not hurt the performance. but in
> my
> > case my system has slowed down obviously.
> > any one can give me some hint? i will appreicate
> it
> > very much.
> > bin
> >
> >
>
______________________________________________________________________
> > Post your ad for free now!
> http://personals.yahoo.ca
> >
> >
>
___________________________________________________________________________
> > 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
>
______________________________________________________________________
Post your ad for free now! http://personals.yahoo.ca
___________________________________________________________________________
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
