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