[pgpool-general: 7576] Re: jboss - jdbc - pgpool

[Tatsuo Ishii]

> Hello Tatsuo,
> I have encountered a problem in communication between Jboss and pgpool using jdbc drivers. This is Jboss output:
>     Caused by: org.postgresql.util.PSQLException: This connection has been closed.
>         at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:861)
>         at org.postgresql.jdbc.PgConnection.prepareStatement(PgConnection.java:1767)
>         at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:732)
>         at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:718)
>         at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:404)
>         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:161) [hibernate-core-4.2.5.Final.jar:4.2.5.Final]
>         at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182) [hibernate-core-4.2.5.Fina
> l.jar:4.2.5.Final]
> 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.

It seems pgpool closed the connection from the client. There are
number of reasons pgpool decides to close the connection to client. To
clarify the reason, you'd better to share the pgpool log when pgpool
closed the connection.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp