[jboss-user] [Datasource Configuration] New message: "How to Read my oracle*ds.xml"

[Ram kumar]

User development,

A new message was posted in the thread "How to Read my oracle*ds.xml":

http://community.jboss.org/message/524275#524275

Author  : Ram kumar
Profile : http://community.jboss.org/people/maluram

Message:
--------------------------------------------------------------
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.
 
<local-tx-datasource>
    <jndi-name>myDataSource</jndi-name>
    <use-java-context>false</use-java-context>
    <connection-url>@rca_url@</connection-url> 
    <driver-class>oracle.jdbc.OracleDriver</driver-class>
    <user-name>@user@</user-name>
    <password>@pwd@</password>
    <min-pool-size>5</min-pool-size>    
    <max-pool-size>50</max-pool-size>
    <!--<blocking-timeout-millis>60000</blocking-timeout-millis> -->
    <idle-timeout-minutes>1</idle-timeout-minutes> 
    <track-statements>true</track-statements>
    <background-validation>true</background-validation>
    <background-validation-minutes>1</background-validation-minutes><!-- deprecated ? -->
    <background-validation-millis>10000</background-validation-millis>    
    <prepared-statement-cache-size>10</prepared-statement-cache-size>      
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
    <new-connection-sql>select 1 from dual</new-connection-sql>
    <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>       
    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
    <metadata>
       <type-mapping>Oracle9i</type-mapping>
    </metadata>
  </local-tx-datasource>
 
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.


--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/524275#524275