Re: connection pooling for postgres

Dave,

Is DBCP in good shape these days? We were disappointed with its
stability a few years back, although I guess there's been plenty of time
since then for things to improve . . .

-- Mark Lewis

On Thu, 2007-01-11 at 10:04 -0500, Dave Cramer wrote:
> James,
>
> The internal pooling implementation that the driver provides is not
> really production quality.
>
> It's recommended you look at apache's dbcp.
>
> Dave
> On 11-Jan-07, at 9:28 AM, James Neff wrote:
>
> > Greetings,
> >
> > Sorry for the elementary question but I am still relatively new to
> > Java and JDBC.
> >
> > I have 4 clients running on different servers that connect to a
> > Postgres database, pull down some data, process this data and then
> > insert it back to the database into different tables.
> >
> > Because several of the client servers are running on multiple CPUs,
> > or at least dual core, systems there are actually 10 threads on
> > each client that are doing the processing. This means 10
> > connections per server. I think this is causing some resource
> > problems and would like to see how things run if I set up a
> > connection pool for each client, of say 3 connections, and the
> > processing threads would then use one of those 3 when it becomes
> > available.
> >
> > Where can I find good instructions or a tutorial on how to do
> > connection pooling for JDBC to a Postgres database on my client?
> >
> > Is there a better way for me to approach this?
> >
> > Thanks in advance,
> > James
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend