[jboss-user] [Datasource Configuration] New message: "How to Read my oracle*ds.xml"
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