5 Replies Latest reply on Nov 9, 2005 11:08 AM by kukeltje

    Use ems of JBPM on databases other than Oracle...

    erikengerd2

      Hi,

      I tried to run the tests for JBPM with a MySQL database, but got a large number of failures/errors. Looking in the documentation this is also expected. It appears that only Oracle 9 is fully functional (Oracle 8 also gave me failed tests).

      Now this worries me. How am I to trust JBPM for MySQL if the unit tests are not all working?

      Cheers
      Erik

        • 1. Re: Use ems of JBPM on databases other than Oracle...
          camunda

          Hi Erik,

          we have a full ERP system developed with jBPM ( see press release http://www.camunda.com/pressemeldung.php?newsitem_id=800) and are running with mySQL 4.1.

          So I can say, it no problem to work with mySQL (and in the background there is hibernate working which haqs also no real problems with mySQL).

          What is your problem with mySQL?

          • 2. Re: Use ems of JBPM on databases other than Oracle...
            erikengerd2

            Hi,


            I have no problems with MySQL but just tried to run the JBPM test cases that are in the JBPM starter kit.

            Thanks to your feedback, I am more confident now about using JBPM in combination with MySQL.

            Nevertheless, I think the JBPM development team should seriously take the time to fix the unit tests. Unit tests that do not work and comments in the readme saying that most cases probably fail to due date/time issues does not really inspire confidence.

            Cheers
            Erik

            • 3. Re: Use ems of JBPM on databases other than Oracle...
              kukeltje

              There has been extensive testing of various db's (read the sourceforge forums). Could you tell us the
              - version of the vm
              - version of mysql
              - version of jBPM
              - which testcases fail
              - amount of time you can donate to fix the tests ;-)

              Besides this, I agree that it is not good to have these kinds of comments in the code but we work according to priorities. So if you can give us a reason, either via a jira issue with lots of votes, or via commercial support, we'd be happy to change priorities, really.

              That reminds me, would jou be so kind to file a jira issue on this with the information requested above? That way we can track the issue.

              • 4. Re: Use ems of JBPM on databases other than Oracle...
                erikengerd2

                Hi,


                I have created a task JBPM-437 which provides more details, with a reference to this thread. From what I can see so far, the issue might be purely an issue with cleanup of the database between test cases.

                I can spend a little bit of time trying to see how system configuration affects the problem and will add that info to the jira issue as well.

                Cheers
                Erik

                • 5. Re: Use ems of JBPM on databases other than Oracle...
                  kukeltje

                  Thanks for replying. I've downgraded it to minor (there is no normal :-( ) since it is not clear what caused this. If it is a real issue on our side (maybe others can run the testcases as well) we'll upgrade it again.