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

    WF10 connection pool not recovering




        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"/>


                              <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,