Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Facing Issue with JTATransactionManager

 
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am getting the below Exception while using org.springframework.transaction.jta.WebSphereUowTransactionManager

JDBCTransacti E org.hibernate.transaction.JDBCTransaction toggleAutoCommit Could not toggle autocommit
java.sql.SQLException: DSRA9250E: Operation setAutoCommit is not allowed during a global transaction for Shareable Connections.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createSharingException(WSJdbcConnection.java:1571)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:3440)
at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:142)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
at

Data is getting inserted properly to database how ever seeing the above error.

using the @Transactional(propagation = Propagation.REQUIRED) annotation for the method which does multiple table inserts.

The current spring version i am using is 3.2.6.RELEASE and hibernate 3.2.6

Any help is appreciated.
 
I'm all tasted up for a BLT! This tiny ad wants a monte cristo!
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic