Re: Intermittent Connection problems using JDBC

Поиск
Список
Период
Сортировка
От Srinivas Kotapally
Тема Re: Intermittent Connection problems using JDBC
Дата
Msg-id 037101c7aa16$749a4c20$0401a8c0@srinilaptop
обсуждение исходный текст
Ответ на Intermittent Connection problems using JDBC  ("Srinivas Kotapally" <ksrinivas@coriendo.com>)
Список pgsql-jdbc
No, the error in that case is different.  It is "Too many connections..."


From: Andrew Lazarus [mailto:drlaz@attglobal.net]
Sent: Friday, June 08, 2007 5:50 PM
To: Srinivas Kotapally
Cc: pgsql-jdbc@postgresql.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@attglobal.net

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Srinivas Kotapally"
Дата:
Сообщение: Intermittent Connection problems using JDBC
Следующее
От: Andrew Lazarus
Дата:
Сообщение: Re: Intermittent Connection problems using JDBC