11 Replies Latest reply on Jun 19, 2013 2:54 PM by xenthik

    jBPM 5.4 with MySql

    nbsiva90

      Hi,

       

      I'm trying to setup the jbpm with backend db as MySql/MS-SQL

       

      Hence, i found this useful article https://community.jboss.org/wiki/SetUpJBPM53ToUseMSSQLServer2008

       

      i was able to proceed with this, but the step 4 while executing

       

      ant install.demo.db

       

      i encountered the following error, Target "install.demo.db" does not exist in the project "jBPM.install".

       

      But where can i find the scripts.

       

      please tell me an alternate solution for this.

       

      TIA


        • 1. Re: jBPM 5.4 with MySql
          maxur

          Hi,

           

          you should use: ant install.db.files

           

          You can find that in build.xml file.

          • 2. Re: jBPM 5.4 with MySql
            roxy1987

            Just give ant install.demo.

            install.demo.db is mentioned in the user guide but the target is not there in build.xml.

            • 3. Re: jBPM 5.4 with MySql
              lisadesouza89

              thank u!! you are the only person who's responded with some useful information!!

              however ant install.db.files only copies the driver to the server module folder. The scripts are still not created or installed. My main issue is that the database is empty and nothing changes.

              • 4. Re: jBPM 5.4 with MySql
                roxy1987

                Lisa,

                 

                Once you have run install.demo. You need to run start.demo. Which will deploy the human task war file and hence fire up the task service. Then access the jbpm console. If your installation was fine then you would see the tables in your db. If not then you would need to do a clean install. The steps are to be followed exactly as mentioned in the user guide.

                 

                Regards.

                • 5. Re: jBPM 5.4 with MySql
                  nbsiva90

                  Hi,

                   

                  Actually there are two databases, one for task and one for jbpm.

                   

                  I went along the procedure, and only jbpm database contains table and the task database is still empty.

                  • 6. Re: jBPM 5.4 with MySql
                    lisadesouza89

                    ok things seem to be going better now with installating, but while installing ht i get:

                         [copy] Warning: Could not find file ...\jbpm-installer\db\task-persistence.xml to copy.

                         [copy] Warning: Could not find file ...\jbpm-installer\db\Taskorm.xml to copy.

                     

                    in build.xml is

                     

                    <copy tofile="${install.home}/target/jbpm-human-task-war/WEB-INF/classes/META-INF/persistence.xml" overwrite="true"

                        file="${install.home}/db/task-persistence.xml" failonerror="false"/>

                        <copy tofile="${install.home}/target/jbpm-human-task-war/WEB-INF/classes/META-INF/ProcessInstanceInfoMapping.xml" overwrite="true"

                        file="${install.home}/db/Taskorm.xml" failonerror="false"/>

                     

                    it meant to be:

                     

                    <copy tofile="${install.home}/target/jbpm-human-task-war/WEB-INF/classes/META-INF/persistence.xml" overwrite="true"

                        file="${install.home}/db/task-persistence-${jpa.version}.xml" failonerror="false"/>

                        <copy tofile="${install.home}/target/jbpm-human-task-war/WEB-INF/classes/META-INF/ProcessInstanceInfoMapping.xml" overwrite="true"

                        file="${install.home}/db/Taskorm-${jpa.version}.xml" failonerror="false"/>

                     

                    since task-persistence-JPA2.xml & Taskorm-JPA2.xml exist??

                     

                    also wherever jbpm-persistence.xml is referenced, i think it should be jbpm-persistence-${jpa.version}.xml

                    • 7. Re: jBPM 5.4 with MySql
                      roxy1987

                      Lisa,

                      Yes tha jpa version should also be there. You can just change the name of the files as per your build.xml.

                      • 8. Re: jBPM 5.4 with MySql
                        roxy1987

                        Siva,

                         

                        Are you able to run processes and complete tasks etc in jbpm-console? If yes then everything is fine. Just change your task persistence hibernate.hbm2ddl.auto property to update.

                         

                        Regards.

                         

                         

                        • 9. Re: jBPM 5.4 with MySql
                          lisadesouza89

                          you're saying I should change the file names? and not make any changes in the file mapping in build.xml as my comment above?

                          Because currently I've changed in build.xml and it's not working...

                          • 10. Re: jBPM 5.4 with MySql
                            iahi1998

                            Here's an article describing how to setup jBPM5.4 to run with MySQL: https://community.jboss.org/wiki/SetUpJBPM54FinalInstallerToUseMySQL-OrHowToRunSection37OfTheUserGuide

                            I hope this helps.

                            • 11. Re: jBPM 5.4 with MySql
                              xenthik

                              HI, I am also getting the same (I went along the procedure, and only jbpm database contains table and the task database is still empty.), is it okay, or something wrong, further i created a process wiith one work item as  human task which can be assigend to an user belongs to HR or PM group, but this task is not getting assigned to any one.   I can see that task is getting created in jbpm5.task table, but all columns are null belong to orgnisation enitity table. please help.

                               

                              thanks in advance