4 Replies Latest reply on Jul 23, 2016 4:40 PM by Andrey Martynov

    WildFly 8.1.0.Final connection pool recovery

    Nicklas Karlsson Master

      Hi,

       

        I'm currently migrating to WF 8.1 and testing connection pool stability by killing of my Oracle DB sessions in order to simulate failures. Apparently I'm a bit too successful since my app never wakes up after that ;-)

       

      In my connection pool I have

       

                          <pool>

                              <flush-strategy>EntirePool</flush-strategy>

                          </pool>

       

      which I thought would clean up the pool but I still get no DB access when I refresh pages etc. Any suggestions?

       

      I also have

       

                          <validation>

                              <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>

                              <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"/>

                              <exception-sorter class-name="my.custom.ExceptionSorterAllwaysReturningTrue"/>

                          </validation>

                          <timeout>

                              <idle-timeout-minutes>10</idle-timeout-minutes>

                          </timeout>

       

      but that doesn't help.

       

      Thanks in advance,

      Nik