Odd Connection Issues - Mailing list pgsql-jdbc

From Jordan S. Jones
Subject Odd Connection Issues
Date
Msg-id 3E8AB673.7050600@racistnames.com
Whole thread Raw
List pgsql-jdbc
Hello,

I am in the process of writing a client/server application that uses
PostgreSQL as the database backend.  I am expecting a high amount of
traffic through this server, so I have opted to utilize the
Jdbc3PoolingDataSource class to get my connections from.. When the
server starts up, it creates, at this point, an initial pool fof 50
connections and a max of 75.  The problem I am running into, is after
236 connections, it hangs on dbPool.getConnection (); where dbPool = new
Jdbc3PoolingDataSource (); From what I have seen, it never returns from
this state.

Previously, this behavior would occur around 255 connections.  I am
using 7.3.2..

Any help on the matter would be greatly appreciated.. If this isn't at
all coherent, I sincerely apologize.

Thanks,
Jordan S. Jones


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: prepared statements and sequences
Next
From: "John Laban"
Date:
Subject: Changing transaction isolation mid-transaction