Originally posted by Simon Good:
Anyone agree. Holding onto database connections for the lifetime of a servlet doesn't seem to be a great idea.
how is it different from taking a connection from pool and giving it back? the connection will still be open till the lifetime of the servlet.
You know the servlet 2.4 specification has given the same example where they say that you should create a connection in ServletContextListener.