Postgresql Help: Connection attempt failed after repeated successful connections /disconnections

From: "Hu, Victoria" <hu(at)aai(dot)textron(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Postgresql Help: Connection attempt failed after repeated successful connections /disconnections
Date: 2011-09-27 00:29:33
Message-ID: 68BD443D128A0143A3DEBDB4E03866EBB1D8@TXAMASNWH027.ent.textron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

After around 4000 times of connection and disconnection, I received following error. I have all required close() statements. Where else shall I look into?
SEVERE: SQLException - getConnection(...)
CONNECTION STATUS: false
org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:150)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)

Thanks
Vicky

Browse pgsql-novice by date

  From Date Subject
Next Message michael lush 2011-09-27 08:52:41 plperl.so no such file or directory
Previous Message Hany ABOU-GHOURY 2011-09-26 20:08:01 Refreshing (update) tables in Dev Database in <Host2> from production database on <Host1>