I've already complain that when to pass Hibernate Transaction Manager to Activiti - Activiti doesn't rollback own changes (means after rollback it push changes to own DB).
But it isn't the point.
The point is the next question: Activiti has 24 tables. Which tables it should rollback and wich shouldn't?