Well, ok, I guess you mean *explicitly* calling the init() in the code as
opposed to automatically/implicitly calling it when the servlet is
initialized.. I stand corrected. But I think the initial poster may still not
want to declare/create a connection object in the init() method *unless* he
means to share it amongst all requests.. I think i am right in this. As another
poster (Pierre-Yves) said, the best thing would be to create the pool in the
init(), and then create and release connection within the doGet()/doPost. This
will ensure both that each request receives its own connection object and that
things are reasonably fast. (I was not thinking straight when I said the
connection object should be stored in a session variable.. long Monday with
meeting after meeting after.....(;-)..)
Geeta
"Christopher K. St. John" wrote:
> Geeta Ramani wrote:
> >
> > Since code in the init() method is executed *exactly* once at
> > servlet initialization time (*not* once per request)
> > ...
> > Instead you want to initialize the ConnectionPool in the init
> > method ...
> >
>
> A servlet's init() method can get called lots of times, as
> long as there is a destroy() in between. It's actually legal
> (although a little silly) for the container to call init(),
> service(), destroy() on every single request, so you'e got
> to make sure to release the connection pool in the servlet's
> destroy() method.
>
> --
> Christopher St. John [EMAIL PROTECTED]
> DistribuTopia http://www.distributopia.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
___________________________________________________________________________
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
