and where does Tomcat fit into this?
sounds like a design issue, try making a search in google.com for java
connection pools. that should take care of you
Filip
~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net
>-----Original Message-----
>From: A.L. [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, August 22, 2001 2:57 PM
>To: [EMAIL PROTECTED]
>Subject: Connection pooling Question
>
>
>I have created a servlet class (using
>DBConenctionbroker from javaexchange) which upon
>initialization creates a number of database
>conenctions. The init method is the only method
>defined.
>
>My plan now is to create a number of servlets which
>extend this class by defining doGet methods, which
>will also return specific information from a database.
> My question is if each of these classes are child
>classes of my connection broker class, how connection
>brokers will be created. In other words:
>Lets say I hae my connection broker and three child
>classes. If upon initialization my connectionBroker
>class actually creates 3 database connections. How
>many database conenctions will there be once all the
>servlets are initialized?
>
>Will there simply be 3 for the connectionBroker,
>9 for each of the child servlets,
>or twelve for all the servlets?
>
>Again I will probably have all 4 servlets intialize
>upon tomcat startup.
>
>Thanks,
> -Amos
>
>__________________________________________________
>Do You Yahoo!?
>Make international calls for as low as $.04/minute with Yahoo! Messenger
>http://phonecard.yahoo.com/
>
