Win a copy of Escape Velocity: Better Metrics for Agile Teams this week in the Agile and Other Processes 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Paul Clapham
  • Jeanne Boyarsky
  • Ron McLeod
  • Frank Carver
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
  • Piet Souris
  • Frits Walraven
  • fred rosenberger

Issues with Rollback when using WSJdbcConnection

Ranch Hand
Posts: 128
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

We use websphere 6.0 and Oracle 10g. In our application for certain scenarios we need to pass Array of String, Integers as input to Stored procedures. As this needs to use OracleCallableStatement, we do get the native connection as below. And use that get CallableStatement.

nativeconnection = (Connection) WSJdbcUtil.getNativeConnection((WSJdbcConnection)datasource.getConnection());

This works fine. And we are able to insert/update records into DB.We are using CMP for managing transactions(Stateless Session Beans). But what we observed was, that when ever there is an exception in a certain part of transaction, rollback does not happen. This is really scary as this would lead to inconsistemt data. We are sure this happens because of WSJdbcConnection. We tested the same code without using WSJdbcConnection rollback was happening then. While using WSJdbcConnection do we need to handle anything specific? It would be of great help if some could provide suggestion to solve this problem. This would help us to avoid rewrite of our code base.

Thanks in Advance.

No thanks. We have all the government we need. This tiny ad would like you to leave now:
the value of filler advertising in 2021
    Bookmark Topic Watch Topic
  • New Topic