Bin; Looks like you may have given up.. but here's another thought: say : if (conn != null) conn.close(); instead of simply: conn.close();
Geeta bin cai wrote: > Hi, Geeta, > I tried to close connection within doGet(). but it > give me nullpointexception due to the connection > close. > I declare connection as instance variable and create > it in init method. > I changed back. Thanks for you help, geeta > Have a good night > bin > --- Geeta Ramani <[EMAIL PROTECTED]> wrote: > > 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 > > > === 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
