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

Re: Intermittent Connection problems using JDBC

From: Andrew Lazarus <drlaz(at)attglobal(dot)net>
To: "Srinivas Kotapally" <ksrinivas(at)coriendo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Intermittent Connection problems using JDBC
Date: 2007-06-08 21:50:23
Message-ID: 1666453432.20070608145023@attglobal.net (view raw or flat)
Thread:
Lists: pgsql-jdbc
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title></title>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
body {
  margin: 5px 5px 5px 5px;
  background-color: #ffffff;
}
/* ========== Text Styles ========== */
hr { color: #000000}
body, table /* Normal text */
{
 font-size: 9pt;
 font-family: 'Courier New';
 font-style: normal;
 font-weight: normal;
 color: #000000;
 text-decoration: none;
}
span.rvts1 /* Heading */
{
 font-size: 10pt;
 font-family: 'Arial';
 font-weight: bold;
 color: #0000ff;
}
span.rvts2 /* Subheading */
{
 font-size: 10pt;
 font-family: 'Arial';
 font-weight: bold;
 color: #000080;
}
span.rvts3 /* Keywords */
{
 font-size: 10pt;
 font-family: 'Arial';
 font-style: italic;
 color: #800000;
}
a.rvts4, span.rvts4 /* Jump 1 */
{
 font-size: 10pt;
 font-family: 'Arial';
 color: #008000;
 text-decoration: underline;
}
a.rvts5, span.rvts5 /* Jump 2 */
{
 font-size: 10pt;
 font-family: 'Arial';
 color: #008000;
 text-decoration: underline;
}
span.rvts6
{
 font-family: 'tahoma';
 font-weight: bold;
 color: #ffffff;
 background-color: #0000ff;
}
span.rvts7
{
 font-size: 7pt;
 font-family: 'arial';
}
span.rvts8
{
 font-family: 'tahoma';
}
span.rvts9
{
 font-size: 7pt;
 font-family: 'arial';
 font-style: italic;
 color: #c0c0c0;
}
a.rvts10, span.rvts10
{
 font-size: 7pt;
 font-family: 'arial';
 color: #0000ff;
 text-decoration: underline;
}
/* ========== Para Styles ========== */
p,ul,ol /* Paragraph Style */
{
 text-align: left;
 text-indent: 0px;
 padding: 0px 0px 0px 0px;
 margin: 0px 0px 0px 0px;
}
.rvps1 /* Centered */
{
 text-align: center;
}
--></style>
</head>
<body>

<p>Hello Srinivas,</p>
<p><br></p>
<p>Is it possible that the pool is exceeding max_connections as specified on the server postgresql.conf file?</p>
<p><br></p>
<p>Thursday, June 7, 2007, 3:21:58 PM, you wrote:</p>
<p><br></p>
<div><table border=0 cellpadding=1 cellspacing=2>
<tr valign=top>
<td width=12 style="background-color: #0000ff;">
<p><span class=rvts6>&gt;</span></p>
</td>
<td width=734 style="background-color: #ffffff;">
<p><span class=rvts7>Hi All</span></p>
<p><span class=rvts8>&nbsp;</span></p>
<p><span class=rvts7>I am connecting to my DB using a JDBC connection and sometimes I get this error. &nbsp;This is not consistent and does not happen all the time. &nbsp;I have tried to use various methods to troubleshoot this to no avail. &nbsp;Can this occur if the connection to the database is delayed? &nbsp;I have noticed some network issues off and on in our network. &nbsp;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? &nbsp;Please advise... we getting tripped by this issue!</span></p>
<p><span class=rvts8>&nbsp;</span></p>
<p><span class=rvts7>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.</span></p>
<p><span class=rvts8>&nbsp;</span></p>
<p><span class=rvts7>Regards</span></p>
<p><br></p>
<p><span class=rvts7>Srini</span></p>
</td>
</tr>
</table>
</div>
<p><br></p>
<p><br></p>
<p><br></p>
<p><br></p>
<p><span class=rvts9>--&nbsp;</span></p>
<p><span class=rvts9>Best regards,</span></p>
<p><span class=rvts9>&nbsp;Andrew &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span><a class=rvts10 href="mailto:drlaz(at)attglobal(dot)net">mailto:drlaz(at)attglobal(dot)net</a></p>

</body></html>



Attachment: unknown_filename
Description: text/html (3.6 KB)

In response to

Responses

pgsql-jdbc by date

Next:From: Kalle HallivuoriDate: 2007-06-11 19:55:41
Subject: Re: FYI: porting Copy API to 8.x
Previous:From: Srinivas KotapallyDate: 2007-06-08 21:46:21
Subject: Re: Intermittent Connection problems using JDBC

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