[Datasource Configuration] - Jboss 4.2.3 stall connection issue
by vamshi nooka
vamshi nooka [https://community.jboss.org/people/vnooka] created the discussion
"Jboss 4.2.3 stall connection issue"
To view the discussion, visit: https://community.jboss.org/message/744379#744379
--------------------------------------------------------------
Hi,
we are currently using JBoss 4.2.3 and are seeing lot of stalled transactions in the wiley.
I tried all the possible configurations in the datasource file to check for stall connections but nothing helped.
i have attached our DS file for the reference.
Any help would be greatly appreciated.
Tx a ton!
<datasources>
<xa-datasource>
<jndi-name>xxxxxxxDS</jndi-name>
<track-connection-by-tx/>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:oracle:thin:xxxxxxxxxxxxxxxxx</xa-datasource-property>
<xa-datasource-property name="User">xxxxxxxxxxxx</xa-datasource-property>
<xa-datasource-property name="Password">xxxxxxxxxxxxxx</xa-datasource-property>
<!--pooling parameters-->
<min-pool-size>20</min-pool-size>
<max-pool-size>500</max-pool-size>
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<!-- Uses the pingDatabase method to check a conn is still valid before handing it out from the pool -->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
<!-- Checks the Oracle error codes and messages for fatal errors -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- Oracles XA ds cannot reuse a connection outside a tx once enlisted in a global tx and vice-versa -->
<no-tx-separate-pools/>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</xa-datasource>
</datasources>
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/744379#744379]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 5 months
Re: [jboss-user] [jBPM] - Human Task Module RoadMap
by vchmakov
vchmakov [https://community.jboss.org/people/vchmakov] commented on the document
"Human Task Module RoadMap"
To view all comments on this document, visit: https://community.jboss.org/docs/DOC-18617#comment-10135
--------------------------------------------------
Hi Mauricio!
And I totally agree with you that the standalone component can be very much useful in different scenarios. We also like the notion of de-coupling of the business logic and widely use it when appropriate.
At the moment we are on the 5.2 build of the jBPM and pretty much busy for even thinking of switching to the new release. Our current implementation of the Rule Server is a standalone application communicating with other parts of the system via MQ. The Task Manager with custom task completion pages is under the JBoss. The idea is to re-implement the entire application to run it under the JBoss AS 7, so we are also very much interested in using Task Management and other jBPM components integrated into JBoss AS 7 via CDI. While doing this we will definitely be looking closely at the changes/fixes in the engine and will gladly report any issues. If we are able to fix them ourselves we will provide you guys with our version of the fix.
Thanks,
Vladimir
--------------------------------------------------
12 years, 5 months