We have encountered a problem that sometimes when we connected to oracle database to update/select through the wildfly datasouce, the transaction/ connection is on hold and there is no return from the transaction. The transaction is on hold more than 900s but the query only cosumed 1-2s to finish running. When we triggered the called again, the task can complete normally within 2s. We have checked the oracle database and there is no db lock during the transaction hold. Is there an unknown issue or anyone encountered the same problem?
Here is the sampele datasource setting in standalone.xml (using JTA)
<datasource jndi-name="java:jboss/datasources/caseman" pool-name="testds" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@172.11.110.11:1521:chosti1</connection-url>
<driver>ojdbc6</driver>
<security>
<user-name>testuser</user-name>
<password>password</password>
</security>
</datasource>
