Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hidden Rollbacks and Commits from Jboss

 
Murali Vvsd
Greenhorn
Posts: 2
Java
  • Mark post as helpful
  • send pies
  • 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
  • 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>
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic