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