0 Replies Latest reply on Dec 19, 2017 11:16 AM by Wayne Wong

    Un-managed JDBC connection failed to release in Wildfly 10.1.0 Final

    Wayne Wong Newbie

      Hi All

      I thought un-managed JDBC connections (obtained from connection pool) can be auto released after a certain idle time. But it doesn't work as I expected. Here is my configuration:

                          <pool>

                              <min-pool-size>5</min-pool-size>

                              <initial-pool-size>50</initial-pool-size>

                              <max-pool-size>400</max-pool-size>

                              <prefill>false</prefill>

                              <use-strict-min>false</use-strict-min>

                              <flush-strategy>IdleConnections</flush-strategy>                     

                          </pool>

                          <security>

                              <user-name>userName</user-name>

                              <password>secret</password>

                          </security>

                          <validation>

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

                              <check-valid-connection-sql>select 1</check-valid-connection-sql>

                              <validate-on-match>false</validate-on-match>

                              <background-validation>true</background-validation>

                              <background-validation-millis>60000</background-validation-millis>

                              <use-fast-fail>true</use-fast-fail>

                          </validation>

                          <timeout>

                              <idle-timeout-minutes>1</idle-timeout-minutes>

                          </timeout>

       

      Environments: MS SQL Server 2016, JDK8, and Wildfly 10.1.0 Final.

      I also tried Gracefully, AllConnections in the Flush Strategy but no difference. I am not sure what piece I am missing. Please help me out.

      Thanks very much

      Wayne