0 Replies Latest reply on Dec 15, 2009 5:05 AM by Wiouou

    DataService problem with transactions

    Wiouou

      Hi,

       

      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.