Hi, Geeta and Frank, Thanks you guys. Maybe i will think using connection pool later. however my intership ends this month. probably there is new intership student can do that. before i leave, i really hope i will works. the test will go tomorrow. so i think i have no time to switch to connection pool option. I am trying to find way around this problem. do you think i should write function to close the connection in my servlet application? --- FRANK WELCH <[EMAIL PROTECTED]> wrote: > I have had success using a global Connection > Manager. > > See > http://www.servlets.net/support/downloads/samplecode/dbpooling/index.html > > Frank > > ----- Original Message ----- > From: "Geeta Ramani" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, August 12, 2002 3:53 PM > Subject: Re: connection reset by peer, system slow > down > > > > Hi there: i think your problem is right there: you > should not define your > > connection object as an instance vaiable. Since > servlets are not > inherantly > > thread safe, this means that if multiple users > access your servlet > > simultaneously, you will run into trouble (unless > you synchronize access > to the > > connection object). You can test this theory out > by declaring and > initialising > > your connection in the doGet/dopost methods. You > will not then have > problems > > with simultaneous access.. Of course the best > soultion is to declare a > > connection pool as an instance variable in your > servlet, initialise it in > the > > init method and then pick up connections and > release them as you need them > > within your doGet/doPost methods. > > > > Hope this helps, > > Geeta > > > > bin cai wrote: > > > > > 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 > > > > > > > > > > > ______________________________________________________________________ > === message truncated ===
______________________________________________________________________ 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
