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.
   

   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

   <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
   

   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

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 !