Staying Connected?

[Carol Murphy]

I am trying to organize my thoughts for JDBC 2, and I would like to know if keeping a connection open for an entire session is better than closing the connection after a statement has been executed. If the connection remains opens the entire time, I'm thinking that the stuff for creating a connection should go in one method and the stuff for closing the connection should go in its own method, but then it seems like they would have to be called from inside doPost() or doWork(), which means they would get called more than once......
Hmmmmm..... This is much trickier than it appears!

[Carol Murphy]

Perhaps I should have looked at the Connection Pooling post by Dirk before I asked this question. I think that is what I was talking about, although my vocabulary does not include Connection Pooling. That water's way over my head at this point!

[Dirk Schreckmann]

my vocabulary does not include Connection Pooling