Installing JBoss jBPM 3.2.2 on Apache Tomcat 5.5 and MySQL

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.