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 :
    origin-repository.jboss.org/nexus/content/groups/public/org/kie/kie-wb-distribution-wars/6.1.0.Final/
    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.
    2_open_with_winrargo 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
    <properties>
          <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
    
          <property name="hibernate.max_fetch_depth" value="3" />
          <property name="hibernate.hbm2ddl.auto" 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="hibernate.id.new_generator_mappings" value="false" />
          <property name="hibernate.transaction.jta.platform" value="org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform" />
        </properties>
    
    
  6. Drag persistence.xml in your desktop to jbpm-console.war through Winrar
    5_replace_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 :6_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>