I have a cmp bean named NodeBean with relation to ContentBean.
When i try to remove the node bean the following statements execute:
SELECT contentid FROM content WHERE (nodeid=?)
UPDATE content SET nodeid=? WHERE contentid=?
DELETE FROM node WHERE nodeid=?
When the last statement throws an exception the transaction does not roll back. This leaves the content table in a wrong state.
I am using JBoss 3.0 RC3 on Windows 2000
running on Sun JDK 1.4.0
with Microsoft JDBC Driver and SQL Server 2000 sp2