7 Replies Latest reply on May 26, 2016 1:43 AM by Nicklas Karlsson

    WF10 connection pool not recovering

    Nicklas Karlsson Master

      Hi,

       

        I'm simulating database outages by shutting down the oracle TNS listener. My connection pool has min size  = max size = 1 with strict min and prefill. The problem, however, is that the connection pool doesn't recover even after the TNS listener becomes available again. What would be the correct flush-strategy or other attributes to have on the datasource for the recovery to work?

       

      I use

       

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

                              <validate-on-match>true</validate-on-match>

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

                              <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.novendor.NullExceptionSorter"/>

       

      for connection validation.

       

      I've tried various flushings from the CLI in order to trigger the refresh after TNS becomes available but only a :reboot appear to work

       

      Thanks in advance,

      Nik