> > > considering 180 students take the exam at same > > time they'll have a lot fun using your system if you "synchronozied" doGet/doPost (if that's what you meant)
----- Original Message ----- From: "bin cai" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 27, 2002 6:36 PM Subject: Re: set connection as instance variable ( servlet and mysql) > Thanks Geeta. > How about i using "serializable" or "synchronozied" > when i initialize servlet every time? > Thanks again and have a good day > bin > --- Geeta Ramani <[EMAIL PROTECTED]> wrote: > > Hi Bin: > > > > Defining connections as instance variables in your > > servlet will not work > > because as you rightly guessed you will have > > threading problems. Your solution > > is to create a pool. search among the archives (or > > google) for "Connection > > pool". > > > > Regards, > > Geeta > > > > bin cai wrote: > > > > > Hi, > > > My application is about online exam with java > > servlet > > > as tool, tomcat 3.2.3 as server solution , mysql > > 3.49 > > > as the backend. > > > considering 180 students take the exam at same > > time > > > within 50 minutes, there are a lot of transactions > > > with database. > > > what i did right now is to define connection in > > local > > > variable(within doGet or doPost method), every > > time > > > this servlet is called, new connection is created. > > > after transaction is done, this connection is > > closed. > > > I am worrying the speed.(it will comsume a lot > > > connection and time for open new connection). > > > > > > so I am thinking to define connection as instance > > > variable in every servlet, so it can save sometime > > to > > > open new connection. However, I am not sure if it > > will > > > cause multi-thread problem? How and when i can > > close > > > the connection. > > > > > > Thank you very much > > > bin > > > > > > > > > ______________________________________________________________________ > > > Find, Connect, Date! 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 > > > > > ______________________________________________________________________ > Find, Connect, Date! 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
