Re: idle in transaction - Mailing list pgsql-jdbc

Hi.<br /><br /> Are you using DODS/Enhydra to manage your database connection pool?<br /> If yes, see my email in the
Enhydramailing list:<br /><a class="moz-txt-link-freetext"
href="http://mail-archive.objectweb.org/dods/2006-05/msg00000.html">http://mail-archive.objectweb.org/dods/2006-05/msg00000.html</a><br
/><aclass="moz-txt-link-freetext"
href="http://mail-archive.objectweb.org/dods/2006-06/msg00000.html">http://mail-archive.objectweb.org/dods/2006-06/msg00000.html</a><br
/><br/> The latest DODS dont have this issue anymore. You just use "RollbackOnReset" option.<br /><br /> Bests
regards.<br/> João Paulo Ribeiro<br /><br /> Sriram Dandapani wrote: <blockquote
cite="mid6992E470F12A444BB787B5C937B9D4DF05DF1974@ca-mail1.cis.local"type="cite"><style>
 
<!--/* Style Definitions */p.MsoNormal, li.MsoNormal,
div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"TimesNew Roman";}
 
a:link, span.MsoHyperlink{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed{color:purple;text-decoration:underline;}
span.EmailStyle17{mso-style-type:personal-compose;font-family:Arial;color:windowtext;}
@page Section1{size:8.5in 11.0in;margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1{page:Section1;}
--> </style><div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt;
font-family:Arial;">I use postgres 8.1.2 database and postgres 8.1.404 jdbc driver .</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I keep seeing “idle in
transaction”connections on the postgres box all the time. The application logic closes all connections , so it makes me
wonderif the driver is issuing a begin statement after every commit to leave a floating transaction
open.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family:
Arial;"> </span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family:
Arial;">Thisis causing autovacuum to not finish (and hence I have to frequently issue database-wide vacuums to prevent
thetransaction id wraparound problem)</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10pt; font-family: Arial;"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10pt; font-family: Arial;">Any help here is appreciated</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size: 10pt; font-family: Arial;">Thanks</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size: 10pt; font-family: Arial;">Sriram</span></font></div></blockquote><br
/><br/><pre class="moz-signature" cols="72">-- 
 
João Paulo Ribeiro | Senior Software Engineer
<a class="moz-txt-link-abbreviated" href="mailto:jp@mobicomp.com">jp@mobicomp.com</a>

PHONE: + 351 253 305 250
FAX  : + 351 253 305 250
<a class="moz-txt-link-abbreviated" href="http://www.mobicomp.com">www.mobicomp.com</a>

________________________________________________________________

About Solutions | Wireless World

CONFIDENTIALITY NOTICE: This message, as well as existing attached files, is confidential and intended exclusively for
theindividual(s) named as addressees. If you are not the intended recipient, you are kindly requested not to make any
usewhatsoever of its contents and to proceed to the destruction of the message, thereby notifying the sender.
 
DISCLAIMER: The sender of this message can not ensure the security of its electronic transmission and consequently does
notaccept liability for any fact which may interfere with the integrity of its content.</pre>