Skip site navigation (1) Skip section navigation (2)

Re: Intermittent Connection problems using JDBC

From: "Srinivas Kotapally" <ksrinivas(at)coriendo(dot)com>
To: "'Andrew Lazarus'" <drlaz(at)attglobal(dot)net>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Intermittent Connection problems using JDBC
Date: 2007-06-08 21:46:21
Message-ID: 037101c7aa16$749a4c20$0401a8c0@srinilaptop (view raw or flat)
Thread:
Lists: pgsql-jdbc
No, the error in that case is different.  It is "Too many connections..."

  _____  

From: Andrew Lazarus [mailto:drlaz(at)attglobal(dot)net] 
Sent: Friday, June 08, 2007 5:50 PM
To: Srinivas Kotapally
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Intermittent Connection problems using JDBC



Hello Srinivas,




Is it possible that the pool is exceeding max_connections as specified on the
server postgresql.conf file?




Thursday, June 7, 2007, 3:21:58 PM, you wrote:





>

Hi All

 

I am connecting to my DB using a JDBC connection and sometimes I get this error.
This is not consistent and does not happen all the time.  I have tried to use
various methods to troubleshoot this to no avail.  Can this occur if the
connection to the database is delayed?  I have noticed some network issues off
and on in our network.  What is the default connection timeout in pgsql-jdbc and
would that result in causing this error in the log OR is this an error that is
generated when the request reaches the DB host machine?  Please advise... we
getting tripped by this issue!

 

CDBConnectionPool.newConnection() : SQLException=
org.postgresql.util.PSQLException: Connection refused. Check that the hostname
and port are correct and that the postmaster is accepting TCP/IP connections.

 

Regards




Srini













-- 

Best regards,

 Andrew                            mailto:drlaz(at)attglobal(dot)net

In response to

pgsql-jdbc by date

Next:From: Andrew LazarusDate: 2007-06-08 21:50:23
Subject: Re: Intermittent Connection problems using JDBC
Previous:From: Heikki LinnakangasDate: 2007-06-08 11:32:14
Subject: Re: FYI: porting Copy API to 8.x

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group