Re: Intermittent Connection problems using JDBC - Mailing list pgsql-jdbc

From Andrew Lazarus
Subject Re: Intermittent Connection problems using JDBC
Date
Msg-id 1666453432.20070608145023@attglobal.net
Whole thread Raw
In response to Intermittent Connection problems using JDBC  ("Srinivas Kotapally" <ksrinivas@coriendo.com>)
List pgsql-jdbc
<p>Hello Srinivas,<p><br /><p>Is it possible that the pool is exceeding max_connections as specified on the server
postgresql.conffile?<p><br /><p>Thursday, June 7, 2007, 3:21:58 PM, you wrote:<p><br /><div><table border="0"
cellpadding="1"cellspacing="2"><tr valign="top"><td style="background-color: #0000ff;" width="12"><p><span
class="rvts6">></span></td><tdstyle="background-color: #ffffff;" width="734"><p><span class="rvts7">Hi
All</span><p><spanclass="rvts8"> </span><p><span class="rvts7">I am connecting to my DB using a JDBC connection and
sometimesI get this error.  This is not consistent and does not happen all the time.  I have tried to use various
methodsto troubleshoot this to no avail.  Can this occur if the connection to the database is delayed?  I have noticed
somenetwork issues off and on in our network.  What is the default connection timeout in pgsql-jdbc and would that
resultin 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!</span><p><span class="rvts8"> </span><p><span
class="rvts7">CDBConnectionPool.newConnection(): SQLException= org.postgresql.util.PSQLException: Connection refused.
Checkthat the hostname and port are correct and that the postmaster is accepting TCP/IP connections.</span><p><span
class="rvts8"> </span><p><spanclass="rvts7">Regards</span><p><br /><p><span
class="rvts7">Srini</span></td></tr></table></div><p><br/><p><br /><p><br /><p><br /><p><span
class="rvts9">-- </span><p><spanclass="rvts9">Best regards,</span><p><span class="rvts9"> Andrew                      
    </span><a class="rvts10" href="mailto:drlaz@attglobal.net">mailto:drlaz@attglobal.net</a> 

pgsql-jdbc by date:

Previous
From: "Srinivas Kotapally"
Date:
Subject: Re: Intermittent Connection problems using JDBC
Next
From: "Kalle Hallivuori"
Date:
Subject: Re: FYI: porting Copy API to 8.x