Issue with JDBC Adapter part from 6.5 release and Oracle 10G RAC.

Hello All,

We are facing issue with JDBC Adapter part from 6.5 release and Oracle 10G RAC.
We made following test:

StartTranasaction
Insert
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.

Bets Regards,
Krasimir Zlatev

Hi Krasimir,
Please search the past discussions on this forum. There are lots of threads discussing the JDBC Adapter Transaction related issues. Will give you good insight.

Regards,
Bhawesh.