• XAMPP
• Moodle 1.9
• Firebug
• New Module Template
• Social Bookmarking Activity Template

Default MySQL admin user: root
Defalut admin password: blank

Related Posts

• June 30, 2008 -- Workshop at Salamanca (0)
• July 4, 2008 -- Back to Barcelona (0)
• June 23, 2008 -- Moodle Social Bookmarking Activity 2008062001 (4)
• May 29, 2008 -- Bookmarks Module version 2008052901 (2)
• May 19, 2008 -- New release of Social Bookmarking Module (3)

Tags: Apache, Bookmarks, CITA, Firebug, Moodle, MySQL, new module template, Salamanca, workshop, workshop stuff, XAMPP

This post is a how-to with the necessary steps to install jBPM 3.2.2 on a Apache Tomcat 5.5 and MySQL 5.0.

1. Create schema and table in database
   In this example a schema ‘jbpm’ with a user ‘jboss’ is used.
   Generate all jBPM tables using the script jbpm.jpdl.mysql.sql. If you want your users/roles information (the identity components) also from the MySQL db, use the second sql script attached here mysql.identity.script.jbpm321.sql to set up the necessary tables and fill them with the demo values.
2. Prepare your jBPM archive
   1. Open a console in jbpm-jpdl-3.2.2/deploy and run:

      ant customize.console.for.tomcat

   2. This builds a jbpm-console.war in jbpm-jpdl-3.2.2/deploy/customized
   3. Unzip this file and change jbpm-console/WEB-INF/classes/hibernate.cfg.xml to reflect the following changes:

      <hibernate-configuration>
        <session-factory>
      
          <!-- hibernate dialect -->
          <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
      
          <!-- JDBC connection properties (begin) -->
          <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
          <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpm</property>
          <property name="hibernate.connection.username">jboss</property>
          <property name="hibernate.connection.password">jboss</property>
           <!-- JDBC connection properties (end) -->
      
          <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
      
          <!-- DataSource properties (begin) ==
          <property name="hibernate.connection.datasource">java:/JbpmDS</property>
          == DataSource properties (end) -->
          <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
      ...

   4. Note that the following line is commented:

          <property name="hibernate.connection.datasource">java:/JbpmDS</property>

   5. Extract el-api.jar and el-ri.jar from the original war file (jbpm-console.war/WEB-INF/lib) to jbpm-console/WEB-INF/lib
   6. Copy jboss-j2ee.jar and commons-collections.jar to jbpm-console/WEB-INF/lib. You can find these files in jbpm-jpdl-3.2.2/server/server/jbpm/lib
   7. Download mysql jdbc driver from MySQL Home Page and move it to $TOMCAT_HOME/common/lib
   8. Zip jbpm-console to a war file and move it to $TOMCAT_HOME/webapps
3. Setup a JDBC Realm in Tomcat
   Create a file jbpm-console.xml in /$CATALINA_HOME/conf/Catalina/localhost similar to

<Context>
<Realm  className="org.apache.catalina.realm.JDBCRealm"
	driverName="com.mysql.jdbc.Driver"
	connectionURL="jdbc:mysql://localhost:3306/jbpm"
	connectionName="jboss"
	connectionPassword="jboss"
	userTable="JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g"
	userNameCol="g.TYPE_ = 'security-role' AND m.GROUP_ = g.ID_ AND m.USER_ = u.ID_ AND u.NAME_"
	userCredCol="DISTINCT u.PASSWORD_"
	userRoleTable="JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g"
	roleNameCol="g.NAME_" />
</Context>

Now you should be able to run jBPM default web app in Tomcat.

This how-to is a resume and an adaptation of JBoss.com Wiki. Sql scripts are also the same of the original page.

Related Posts

• March 14, 2008 -- jBPM task nodes development (6)
• April 4, 2008 -- Run a jBPM process (9)
• February 15, 2008 -- jBPM mail nodes development (10)
• February 14, 2008 -- jBPM decision nodes development (7)
• February 14, 2008 -- jBPM simple nodes development (1)

Tags: BPM, Hibernate, HowTo, Java, JBoss, jBPM, MySQL, Tomcat, workflow