Well, I think we're all in agreement here. :)
Basically, the Servlet container is a poor substitute
for a good connection pool. I think the tag design
should assume either a) you have a good connection
pool, or b) performance isn't an issue.
- Morgan
--- Wong Kok Wai <[EMAIL PROTECTED]> wrote:
> I totally agree. Connection should be open as short
> as possible. I would
> think in the release() method of the tag, the
> connection.close() has to be
> call.
>
> Glenn Nielsen wrote:
>
> > Connections should be short lived at the page
> level, only instantiated
> > as long as needed. The underlying container,
> datasource, or driver
> > should be left to manage the connections by using
> such things as dB
> > connection pooling etc. Holding on to a
> connection in the session scope
> > would severely limit scaling of db connections.
> >
> > Regards,
> >
> > Glenn
> >
>
=====
Morgan Delagrange
Britannica.com
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
