JDBC 2.0 and pooled connections?

From: "Dr(dot) Evil" <drevil(at)sidereal(dot)kz>
To: pgsql-general(at)postgresql(dot)org
Subject: JDBC 2.0 and pooled connections?
Date: 2001-10-11 08:23:23
Message-ID: 20011011082323.6035.qmail@sidereal.kz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2001-10-11 10:04:33 Multiple postgresql installations on one machine.
Previous Message tony 2001-10-11 07:55:01 Re: Performance problem with 50,000,000 rows