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
