0 Replies Latest reply on May 30, 2002 7:29 AM by Panagiotis Korros

    Transaction does't roll back when removing CMP Bean

    Panagiotis Korros Newbie

      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