<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.Stylwiadomocie-mail17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="PL" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hello Tatsuo,<o:p></o:p></p>
<p class="MsoNormal">I have encountered a problem in communication between Jboss and pgpool using jdbc drivers. This is Jboss output:<o:p></o:p></p>
<p class="MsoNormal"> Caused by: org.postgresql.util.PSQLException: This connection has been closed.<o:p></o:p></p>
<p class="MsoNormal"> at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:861)<o:p></o:p></p>
<p class="MsoNormal"> at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1767)<o:p></o:p></p>
<p class="MsoNormal"> at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:732)<o:p></o:p></p>
<p class="MsoNormal"> at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:718)<o:p></o:p></p>
<p class="MsoNormal"> at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:404)<o:p></o:p></p>
<p class="MsoNormal"> at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:161) [hibernate-core-4.2.5.Final.jar:4.2.5.Final]<o:p></o:p></p>
<p class="MsoNormal"> at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182) [hibernate-core-4.2.5.Fina<o:p></o:p></p>
<p class="MsoNormal">l.jar:4.2.5.Final]<o:p></o:p></p>
<p class="MsoNormal">Version of pgpool in our environment is 4.0.5 and jdbc driver used in Jboss is 42.2.11.jre7. We plan to upgrade pgpool to at least 4.1.4, but i’m not sure if it will resolve problem. Do you have any idea if above error is a matter of improper
configuration of pgpool or bug in jdbc driver/pgpool? Two yaers ago we had also problem connecting to pgpool via jdbc drivers and upgrade from 4.0.1 to 4.0.5 helped us because of bug fixed in 4.0.5.<o:p></o:p></p>
<p class="MsoNormal">Best regards.<o:p></o:p></p>
<p class="MsoNormal"><b><span style="mso-fareast-language:PL">Andrzej Rozmus<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#161616;background:white;mso-fareast-language:PL">Starszy Technolog</span><span style="mso-fareast-language:PL"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#161616;mso-fareast-language:PL">Departament Systemów Administracji Rządowej</span><span style="mso-fareast-language:PL"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#161616;mso-fareast-language:PL">Dział Ministerstwo Finansów</span><span style="mso-fareast-language:PL"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#161616;background:white;mso-fareast-language:PL">Zespół Projektowy AIS/AES</span><span style="mso-fareast-language:PL"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;mso-fareast-language:PL">Asseco Poland S.A.</span></b><span style="font-size:9.0pt;mso-fareast-language:PL"><br>
ul. Branickiego 13<br>
02-972 Warszawa<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#161616;background:white;mso-fareast-language:PL">tel. kom. +48 502 270 059</span><b><span style="mso-fareast-language:PL"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="mso-fareast-language:PL">andrzej.rozmus@asseco.pl<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>