This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JBoss/WildFly and the fly likes Hidden Rollbacks and Commits from Jboss Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Hidden Rollbacks and Commits from Jboss" Watch "Hidden Rollbacks and Commits from Jboss" New topic
Author

Hidden Rollbacks and Commits from Jboss

Murali Vvsd
Greenhorn

Joined: Sep 26, 2012
Posts: 2

Hi ,
I have a Problem with Commits and Rollbacks in my application.Actually these are High in number (Collected from Tool).

1. In Application we have a Connection Manager class from where we are getting the connection Object by setting auto commit to false.

2. We are Committing the Transaction from the same class by using commit().

3.We are getting rollbacks even in the case of successful transaction .

I am unable to find it out from where these extra/hidden rollbacks are coming .(These are not from the program as we have centralized mechanism for Commits and Rollbacks)

Application server: Jboss-5.1-GA3

Oracle 11G Db and type4 Driver

OJDBC5.jar

I used Toad session Browser to collect the statics for Transaction.


Please help me to find out the reason for extra rollbacks and commits.

Thanks in Advance.
Murali Vvsd
Greenhorn

Joined: Sep 26, 2012
Posts: 2

Hi,
Please anyone giveme your inputs on this. I am using below Oracle-ds.xml

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

<local-tx-datasource>

<jndi-name>MyDS</jndi-name>

<connection-url>jdbcracle:thin:@<HostName>:<POrt_NUM>:<SID></connection-url>

<driver-class>oracle.jdbc.OracleDriver</driver-class>

<user-name>user</user-name>

<password>pwd</password>

<!--<security-domain>mydbDBSecurity</security-domain>-->

<!--connection-property name="relaxAutoCommit">yes</connection-property-->
<!--<connection-property name="autoCommit">false</connection-property> -->

<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

<!-- <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>-->

<!--new-connection-sql>set autocommit=0;</new-connection-sql-->

<!--<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>-->

<track-statements>true</track-statements>

<metadata>

<type-mapping>Oracle11G</type-mapping>

</metadata>

</local-tx-datasource>

</datasources>
 
Consider Paul's rocket mass heater.
 
subject: Hidden Rollbacks and Commits from Jboss
 
Similar Threads
Dirty Read / Dirty Write scenarios
Regarding autoCommit()
Transaction Management
Regarding autoCommit()
difference between userTransaction.rollback() & userTransaction timeout