[pgpool-general: 7575] jboss - jdbc - pgpool

[Rozmus Andrzej]

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.
Best regards.
Andrzej Rozmus
Starszy Technolog
Departament Systemów Administracji Rządowej
Dział Ministerstwo Finansów
Zespół Projektowy AIS/AES
Asseco Poland S.A.
ul. Branickiego 13
02-972 Warszawa
tel. kom. +48 502 270 059
andrzej.rozmus at asseco.pl

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210517/8a3f55f7/attachment.htm>