[Datasource Configuration] New message: "How to Read my oracle*ds.xml"
by 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
16 years, 2 months
[jBPM] New message: "Re: Upgrade from JBPM3 to JBPM4 woes"
by Flavio N.
User development,
A new message was posted in the thread "Upgrade from JBPM3 to JBPM4 woes":
http://community.jboss.org/message/524263#524263
Author : Flavio N.
Profile : http://community.jboss.org/people/VegaMilano
Message:
--------------------------------------------------------------
Sorry for the misunderstanding.
When I told about lack of answers I didn't mean in THIS forum. We already searched around and not from today, and that was my comment about.
My intent is not to "blame" anyone: for sure we (not just I) seem to have a lack of understanding of jBPM and I really hoped someone says me "You don't understand nothing at all: the things can be manged in this way".
It seems you're a veteran here, so it could be great if you can suggest us some specific reference to the examples, testcases, source and so on you was talking about, because we really was not able to find anything (our fault, I am the first to admit that).
Peace
Flavio
--------------------------------------------------------------
To reply to this message visit the message page: http://community.jboss.org/message/524263#524263
16 years, 2 months