JDBC Connections

[Mathew Clark]

Hi,

We have implemented a simple JDBC connection pool for our servlet - do you
think it is better to grab a connection once when a request is received and
use that connection throughout the processing or should the connection be
used only when necessary and released as soon as possible??

Regards,

Matthew.