8 Replies Latest reply on Nov 23, 2013 5:51 PM by Harinath Mallepally

    Install JBPM on Mysql without ANT

    Sadiroveski S Newbie

      Hello,

       

      Can we prepare the Mysql database so JBPM 5.3 will connect to after changing the persistence.xml and without running the ANT.

      What I am trying to do is prevent using the install.demo and start.demo. I want to manually install JBOSS AS 7, manually start the jboss and task service.

       

      Also, how can we change the directory where JBPM console ooks for processes?

       

      Thanks in advance,

        • 1. Re: Install JBPM on Mysql without ANT
          Thomas Setiabudi Expert

          Hi Sadiroveski,

           

          to install the demo without running the ant script, you can refer to the build.xml provided with the jbpm full installer package.

           

          look for this line in build.xml

          <target name="install.demo" depends="install.jboss,install.guvnor.into.jboss,install.designer.into.jboss,install.jBPM-gwt-console.into.jboss,install.jBPM-ht.into.jboss,install.form.builder.into.jboss,install.eclipse,install.jBPM.runtime,install.droolsjbpm-eclipse.into.eclipse" />

           

          there you get what the ant install.demo command do. when you execute ant install.demo, it will execute the dependencies, so the next thing you should look is the install.jboss

          <target name="install.jboss" depends="download.jboss">

              <unzip src="${install.home}/lib/jboss-as-${jboss.server.version}.zip" dest="${install.home}" />

              <chmod perm="a+x" file="${jboss.home}/bin/run.sh" />

              <chmod perm="a+x" file="${jboss.home}/bin/shutdown.sh" />

              <chmod perm="a+x" file="${jboss.home}/bin/standalone.sh" />

                <chmod perm="a+x" file="${jboss.home}/bin/jboss-admin.sh" />

            </target>

           

          it unzip the jboss AS from the lib directory to the install home directory.

          So, by replicating what the build.xml do manually, you should be able to achieve the same result like running the ANT install.demo command.

           

           

          Regards,

          Thomas Setiabudi

          • 2. Re: Install JBPM on Mysql without ANT
            Sadiroveski S Newbie

            Thanks Thomas,

             

            how to prepare the build the Mysql tables for JBPM?

            I think there is 2 configuration one for JBPM and one for Task.

            If you have any idea please let me know.

             

            Regards,

            • 3. Re: Install JBPM on Mysql without ANT
              Touil Imad Newbie

              Hello Sadiroveski,

               

              Did you find a solution for your question ?

              • 4. Re: Install JBPM on Mysql without ANT
                Thomas Setiabudi Expert

                Hi Sadiroveski,

                 

                have you try to refer to this guide http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e597 ?

                 

                about the DB, yes you can configure two DBs in your MySQL Database.

                 

                about building the DB tables, The db tables should be generated automatically when you have properly set all the persistence.xml and start the jboss AS.

                 

                I haven't do setup for MySQL yet, but the guide link above should have enough information about it.

                I just tried to change the DB to MS SQL Server and can get everything run well now: https://community.jboss.org/wiki/SetUpJBPM53ToUseMSSQLServer2008

                 

                • 5. Re: Install JBPM on Mysql without ANT
                  Sadiroveski S Newbie

                  ------------------------------------------------------------------

                  Hello,

                  Can we prepare the Mysql database so JBPM 5.3 will connect to after changing the persistence.xml and without running the ANT.

                  What I am trying to do is prevent using the install.demo and start.demo. I want to manually install JBOSS AS 7, manually start the jboss and task service.

                  Also, how can we change the directory where JBPM console ooks for processes?

                  Thanks in advance,

                  --------------------------------------------------------------------------------

                   

                  Dear Thomas,

                   

                  I really appreciate your answers and your help. I used the regular way for to connect JBPM to Mysql i.e. using ant.

                  What I need is to make it manually. Actually, you fired up something in my head which is why I don't export the tables and build my own installation SQL scripts for that. I will try it and let you know.

                   

                  Also, I am asking about how to let the console look for a specific directory for processes?

                   

                  Thanks again,

                  • 7. Re: Install JBPM on Mysql without ANT
                    Sadiroveski S Newbie

                    Hello Touil,

                     

                    Can't see any script that install the database files. In build.xml you can only see the start.db.files.

                    What I am going to do is to Backup/export the JBPM and Task tables in Mysql. Then, clean everything and install Jboss AS7 with related deployments and the task service and run them.

                     

                    I will notify you if this gonna work or in case I found a better approach.

                     

                    Regards,

                    • 8. Re: Install JBPM on Mysql without ANT
                      Harinath Mallepally Newbie

                      hi, you had any luck on this?

                       

                      I found ddl scripts on github C:\Users\harinath\Documents\GitHub\jbpm\jbpm-installer\db\ddl-scripts (my relative path)

                       

                      could see db scripts of multiple databases here