Hi,
Check out this article on connection pooling at:
http://webdevelopersjournal.com/columns/connection_pool.html
Regards,
Anil
----------------------------------------------
Anil Colin Lobo
Senior Software Engineer
Aztec Software and Technology Services (P) Ltd.
Web: http://www.aztec.soft.net
Office Address:
Aztec Software and Technology Services (P) Ltd
23, 3rd A Cross, 18th Main, 6th Block, Koramangala, Bangalore - 560095
Phone: 091-080-5522892 extn 113
-----Original Message-----
From: Srini Sathya. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 6:41 AM
To: [EMAIL PROTECTED]
Subject: JSP-Servlet-DB
Hi,
We are designing our application as follows:
JSP -> Servlet [to retrieve the form data] -> DBHandle [For hadling
dbrequest ].
Once the user submits the form it will call a servlet which will have all
the form data. My problem is that i need to maintain a CP and to give one
connection for each and every request to the DBHandle which will update the
database. If my servlet is going to be only one then i would have my CP
initialized at the init() and can manipulate my poool, since i have lot of
servlets (one for adding user, one for adding a group etc.,) i am confused
where to create the pool. I fear if i create the pool in the DBHandle class
then since each and every servlet is going to create a instance of DBHandle
there would be lot of connections, is that correct??. If this is a bad
design where would be the best place to instantiante my CP and to create
pool.
Thanks for ur help,
Srini
___________________________________________________________________________
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
