2 Replies Latest reply on Jan 24, 2010 2:28 AM by xalperte

    Wiki demo didn't work with XA Transactions

    xalperte

      Hi,


      I'm integrating the Wiki example into our solution, part of the integration is assure that the Wiki component is executing all the DB operations through the same transaction using XADatasSources (JBoss Portal Portal, jBPM, Our Application and now the Wiki).


      I'm using MySQL 5.1.37 with the 5.1.11 jConnector


      The problem happens when the Event Listeners are called for maintain the NestedSet entities. In the NestedSetOperations are being executed Bulk queries (direct updates) that are forcing the database to do commit and that's not possible when a XA Transaction is Active throwing SQLException and not performing the maintenance.


      The effect is that the Wiki Menu is not working when we try to add menu items.


      Any suggestion? what can be done in order to solve this problem? maybe load the NestedSet objects and perform the update in memory?


      By the way, congratulations, you did a great job with this wiki!
      Thanks.

        • 1. Re: Wiki demo didn't work with XA Transactions
          christian.bauer

          I have a version of the wiki local that works without the nested set datamodel (also minus some features). This will be committed in a week or two in the 2.2 branch.


          By the way, those bulk operations are simple UPDATE statements and I don't think they should force any database driver to commit the transaction.

          • 2. Re: Wiki demo didn't work with XA Transactions
            xalperte

            Sorry, it was a warn and not an error.


            Then, I don't know why the menu is nor running well. After some time working with the directories and the menu the items does not appears more in the screen.


            I developed a lightweight version of the menu in order to solve the problem.


            Which new features or changes are you preparing?


            Thanks.