Installing JBPM 6.1 standalone using MySQL DB in JBOSS EAP 6.1

Here step by step to installing JBPM 6.1 standalone (jbpm-console.war) using MySQL DB in JBOSS EAP 6.1.

  1. Download JBPM 6.1 for jboss eap version from here link :
    and rename it become jbpm-console.war
  2. Create a database in mysql db with name ‘learn_jbpm’
    CREATE DATABASE learn_jbpm;
  3. put jbpm-console.war at jboss/standalone/deployment directory and don’t forget to create file jbpm-console.war.dodeploy as deployment trigger.
  4. Right click jbpm-console.war and open with –> Winrar, as default jbpm using h2 sql db dialect. we will change it to MySQL Hibernate dialect.
    Open Jbpm  war file with WinRar

    Open Jbpm war file with WinRar

    go to \WEB-INF\classes\META-INF and extract persistence.xml to desktop

  5. Edit persistence.xml and go to bottom in the tag properties edit the hibernate.dialect property value become
          <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
          <property name="hibernate.max_fetch_depth" value="3" />
          <property name="" value="update" />
          <property name="hibernate.show_sql" value="false" />
          <!-- BZ 841786: AS7/EAP 6/Hib 4 uses new (sequence) generators which seem to cause problems -->
          <property name="" value="false" />
          <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" />
  6. Drag persistence.xml in your desktop to jbpm-console.war through Winrar

    Replace file Persistence.xml

    Replace file Persistence.xml

  7. go to /jboss/standalone/configuration/ edit file standalone-full.xml, we will change data source and pointing to mysql db which have created.
  8. go to datasource tag, and edit datasource become like this :

    Change Datasource

    Change Datasource

  9. Open your command prompt and go to jboss/bin directory, start your jboss using command standalone.bat -c standalone-full.xml
  10. Open your browser and go to http://localhost:yourport/jbpm-console

Good Luck !

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>