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.
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: