If you want a quick and dirty solution, just declare (<--this is important!), initialise, and close your connection object within your doPost/doGet methods. You should be ok then. Geeta
bin cai wrote: > 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 ___________________________________________________________________________ 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
