In servlet's init method check if your context has attribute databasePool that's
not null. If it is null then you know that the pool hasn't been loaded into
context and it's the first servlet being loaded by the engine so put the pool in
there.
Then have each servlet do that in its init method so that if some servlet has
already put the connection pool into the context the next one won't do it too.
dvae.
Sajesh T wrote:
> Hi all
> Presently i am working on a project which making use of
> Netscape Enetrprise Server 4.0 in which i am making use
> of a static connection pool object to establish connection to an Oracle
> database. My problem is, I am not able to
> share this connection pool object across my servlets.
> Each servlet is loading its own Connection pool object
> and this exhausts my maximum number of connections.
> I tried by including the path of my connection object class in the jre class
> path (in the NES server admin) and jvm12.conf file of NES, but nothig is
> found to be working.
> When I did this, i was getting a 'no suitable driver' message. If I put the
> connection pool object in my servlet dir, everything works fine, but each
> servlet loads its own copy of connection pool.
> Please someone out there help me,
> thanks in advance
> sajesh
>
> ________________________________________________________________
> Get FREE voicemail, fax and email at http://voicemail.excite.com
> Talk online at http://voicechat.excite.com
>
> ___________________________________________________________________________
> 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
--
David Mossakowski [EMAIL PROTECTED]
Programmer 212.310.7275
Instinet Corporation
"I don't sit idly by, I'm planning a big surprise"
___________________________________________________________________________
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
