• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Hidden Rollbacks and Commits from Jboss

 
Greenhorn
Posts: 2
Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 2
Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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>
reply
    Bookmark Topic Watch Topic
  • New Topic