JDBC 2.0 and pooled connections?

Started by Dr. Evilover 24 years ago1 messagesgeneral
Jump to latest
#1Dr. Evil
drevil@sidereal.kz

With PG, there is a fork every time a connection is started. This is
expensive, and my web application will need to have a connection from
every page it serves. The right way to do this is to have the servlet
maintain a connection pool.

What's the right way to do this with PG's JDBC driver? I notice that
there is a class for JDBC 2.0 in PG 7.1.x, and JDBC supports a
DataSource interface which could do pooling. Does anyone know if it
actually does pooling, and if so, do you have any example code of how
this would work in a servlet? This will be a tremendous performance
boost. It will cut page load time by 75% I would imagine.

Thanks for any tips. Btw, this is all with JDK 1.3.1, PG 7.1.2, and
Tomcat 4.0, so it's all modern stuff.