In my testing environment, I have trouble managing the connections. Beyond certain point, connections are not destroyed in JBoss EAP5.0. Without going much in there, thought of testing my *ds.xml parameters.
<background-validation-minutes>1</background-validation-minutes><!-- deprecated ? -->
<new-connection-sql>select 1 from dual</new-connection-sql>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
With above xml deployed, I fired my java test client to get 25 connections in a loop and closing them immediately.Result: Connection created 10 & Connection Destroyed Count = 5. Fine with proper closing of connections.
Now I flushed the connections and run the test client again - without closing the connections, which I am interested in.
Even after waiting 15 minutes, Connection Destroyed Count = 0 and all the 25 created are still in use.
How do I read my above *ds.xml - if I want to know when/whether unused connections will be destroyed ?. I would expect, stale connection validation fires every 10 seconds and if found they are closed.
Any help much appreciated.