One recommendation would be to put the connection pool logic in a servlet of its own,
for example, ConnectionPoolServlet. Create the connection pool in the init(). And
create a session object in the global context "CONNECTION_POOL". Make sure to preload
the ConnectionPoolServlet in your java server. Access the connection pool by directly
accessing the global session context for "CONNECTION_POOL".
This will ensure that the initial number is 20. And also the connection pool will be
accessible to all subsequent servlets that would utilize the database.
--
sabir semerkant | [EMAIL PROTECTED] | founder & CTO | rare minds
-----Original Message-----
From: Srinivasan S (Systems Engineering Group)
Sent: Wed, 18 Aug 1999 01:11:24 +0530
To: [EMAIL PROTECTED]
Subject: Init Method
Hi all,
If we store a connection pool for nearly 20 connections for a
servlet in the init() for each and every access of servlet a 20
connections wil be created or else will 20 connections will be created at
the first instance and shall be shared between 20 sessions.
thanks
srini
#-----------------------------------------------------------------------#
# #
# "ARISE AWAKE and stop not till the GOAL is reached" #
# #
# [EMAIL PROTECTED] #
#-----------------------------------------------------------------------#
___________________________________________________________________________
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
_______________________________________________________
Get Visto! Groups, event calendars, email, and more...
Check it out @ http://www.visto.com/info
___________________________________________________________________________
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