We are facing issue with JDBC Adapter part from 6.5 release and Oracle 10G RAC.
We made following test:
Kill the node on which transaction is running.
Commit - > No eception was thrown and no data are inserted in DB.
Rollback in case of exception.
The issue is: When we kill the node commit is executed without errors and we can not identify, should we repeat transaction or not. The service end without erros.
The most interesting is when we perform for example select after execution of service, we receive exception “Transaction must rollback”.
Could anybody help with this strange behavior of JDBC Adapter?
And why connection is open on insert statement but not on Start Transaction statement.
There is something wrong here.