Thread: Odd Connection Issues

Odd Connection Issues

From
"Jordan S. Jones"
Date:
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