8 Replies Latest reply on Apr 9, 2008 3:07 PM by Chuck Pearce

    Looking for Paid JBPM MySQL Server Setup

    Chuck Pearce Newbie

      We are a small software development group that had a developer leave us who had set up our original jBPM server running the Hypersonic database. We are in need of converting our current setup to run on a MySQL 5.x database. There is no need to convert the actual data, we can redeploy all processes.

      From what I understand this should be a pretty straight forward process, however we keep running into snags. Please contact me if you are interested, future jobs may be available such as optimization of the jBPM server.

      Thank you,
      Chuck Pearce

        • 1. Re: Looking for Paid JBPM MySQL Server Setup
          Ronald van Kuijk Master

           

          we keep running into snags.
          why don't you post them here... maybe we can solve them in a simple way

          • 2. Re: Looking for Paid JBPM MySQL Server Setup
            Chuck Pearce Newbie

            kukeeltje: that would be great, let me give that a shot.

            I have two issues, the first is an error on launch that reads:

            "--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
            ObjectName: jboss.jca:service=DataSourceBinding,name=MySqlDS
            State: NOTYETINSTALLED
            Depends On Me:
            jboss.mq:service=PersistenceManager

            ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
            State: NOTYETINSTALLED
            Depends On Me:
            jboss.ejb:service=EJBTimerService,persistencePolicy=database
            jboss:service=KeyGeneratorFactory,type=HiLo
            jboss.mq:service=StateManager
            "

            I am almost certian this has something to do with the "mysql-jdbc2-service.xml" and "mysql-jdbc-state-service.xml" files in /server/jbpm/deploy/jms/

            then the other error, the one I can never seem to get rid of is:

            "00:13:51,701 WARN [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
            00:13:51,702 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 job0_.ID_ as ID1_26_, job0_.VERSION_ as VERSION3_26_, job0_.DUEDATE_ as DUEDAT' at line 1
            00:13:51,702 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: could not execute query
            00:13:51,705 ERROR [JobExecutorThread] exception in job executor thread. waiting 5000 milliseconds
            org.jbpm.JbpmException: couldn't get acquirable jobs"


            This I believe might have something to do with the fact that I have not populated the MySQL database with any data. It did auto create the tables, however there is no data in there. I tried to import the jbpmDB.script file, but I guess that is not formatted for MySQL. Or perhaps I have the library setup incorrectly.

            I do have "mysql-connector-java-3.1.14-bin.jar" in /server/jbpm/lib

            I have tried multiple tutorials online and the second error always seems to be my result.

            Thank you,
            Chuck Pearce

            • 3. Re: Looking for Paid JBPM MySQL Server Setup
              Ronald van Kuijk Master

              the first one is 'simply' caused by not having the MySqlDS configured correctly. See http://wiki.jboss.org/wiki/SetUpAMysqlDatasource for more info.

              The second one is most likely caused by not having the correct hibernate dialect.

              Additional info can be found on http://docs.jboss.com/jbpm/v3/userguide/thejbpmdatabase.html

              • 4. Re: Looking for Paid JBPM MySQL Server Setup
                Chuck Pearce Newbie

                Thank you for the assistance, I believe I am extremely close. The database connection was made, and data was inserted. Here is a log of what is occurring, it appears somewhere I did not set "JbpmDS" to "DefaultDS". Any idea where I made the issue?

                http://www.pastebin.ca/978413

                Also it was the "hibernate.cfg.xml" file that was causing that issue, I had not modified it. I changed the dialect and datasource.

                Thank you,
                Chuck Pearce

                • 5. Re: Looking for Paid JBPM MySQL Server Setup
                  Ronald van Kuijk Master

                  Might be that you have duplicate configs.

                  The hibernate config file should point to JbpmDS, that is the default with the latest versions. But since JbpmDS is not there it and data IS inserted, it probably is pointing directly to the database. There should be a jbpm-ds.xml file pointing to the database and the hibernate config pointing to this datasource. please check those

                  • 6. Re: Looking for Paid JBPM MySQL Server Setup
                    Ronald van Kuijk Master

                    suggestion: Part of this is all basic JEE/JBoss, so instead of paid jBPM support, might I suggest support at a 'lower' level ;-)

                    • 7. Re: Looking for Paid JBPM MySQL Server Setup
                      Chuck Pearce Newbie

                      kukeltje: today, you are my hero! Thank you so much for you help, the server is up and running using MySQL, I had deleted "jbpm-ds.xml" and didn't realize that the file was still required even after the mysql-ds.xml went into place.

                      Strangely the JBPM designer aspect we have pretty well, it is the server that we are lost in. Do you have any recommendations on optimization, or is it pretty well set just on a standard instillation?

                      Thank you again!
                      Chuck Pearce

                      • 8. Re: Looking for Paid JBPM MySQL Server Setup
                        Chuck Pearce Newbie

                        Oh one last question, it appears that processes are being deployed to the hypersonic database, and the jbpm-console logs into the hypersonic database. However our webservice connects to the mysql database. Any idea what file I need to change to fix this?