I need a transaction to insert related records into different destinations. Because they are unmanaged (using SQLAssembler) the datastore is different, so I point them to the same datastore (channelset is the same), autocommit is set to false and use-transactions is true. However when I commit, the parent record has been inserted even when creating its child record goes into error. Anyone who can provide me some working samplecode?
Btw, the tomcat log shows a user transaction being started before the first record and rolled back right after it goes into error.