<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Installing JBPM 5.3 on JBoss AS 5.1 and changing DB
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/doboss">doboss</a> in <i>jBPM</i> - <a href="https://community.jboss.org/docs/DOC-18580">View the full document</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p><span style="color: #000000;">A few days ago I tried to get JBPM 5.3 installed into JBoss AS 5.1 using PostgreSQL (without Eclipse) via the jbpm-installer. I had some trouble, but after some customizations, I have been able to get it installed and running. Some of the information came right out of the documentation, some came from community posts, and some I figured out through trial and error.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;">I figured this all out, then wrote it down, and did it again to verify which things needed to be done. Hopefully I successfully captured all the steps here. I used headings and fonts to try to make this easy to follow. I tried to proof this post real quick as well, but I am thin on time, so I apologies for any mistakes I made. With a bit more time, I suspect these steps could be trimmed down to only the necessary steps, as I may have changed which had no effect on the installation. <span> :| </span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;">Hopefully this post will help others at least get to this point. <span> :) </span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h2><span style="color: #000000;">My configuration:</span></h2><p><span style="color: #000000;">Ubuntu 12.04</span></p><p><span style="color: #000000;">java version "1.6.0_24"</span></p><p><span style="color: #000000;">OpenJDK Runtime Environment (IcedTea6 1.11.1) (6b24-1.11.1-4ubuntu3)</span></p><p><span style="color: #000000;">OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)</span></p><p><span style="color: #000000;">JBoss 5.1.0GA</span></p><p><span style="color: #000000;">PostgreSQL 9.1.4 on x86_64</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h2><span style="text-decoration: underline; color: #000000;">Preparation</span></h2><h3><span style="color: #000000;">Get the installer:</span></h3><p><span style="color: #000000;">The first thing I did was download the jbpm-installer and unzip it into <span style="font-family: courier new,courier;">~/Downloads/jbpm-installer/</span>, and this is the directory/path I will use for the rest of this post.</span></p><h3><span style="color: #000000;">Save some download time:</span></h3><p><span style="color: #000000;">If you are like me, you probably already have a copy of the JBoss distribution sititng around, and rather than having the installation script download it again, I copied it into the installer's lib folder and made a soft link with the name the installer was expecting.  (This step is not critical, just a way to save a bit of time.)</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;"><span style="font-family: courier new,courier;"> cd </span><span style="font-family: courier new,courier;">~/Downloads/jbpm-installer/</span></span></p><p><span style="font-family: courier new,courier; color: #000000;"> cp ~/Downloads/jboss-5.1.0.GA.zip lib/</span></p><p><span style="font-family: courier new,courier; color: #000000;"> ln -s jboss-5.1.0.GA.zip jboss-as-5.1.0.GA.zip # This makes a link with a name of what the installer is expecting</span></p><h3><span style="color: #000000;">Prepare the JBoss installation directory:</span></h3><p><span style="color: #000000;">You will need to setup a JBoss installation directory for the installer to install into. For the rest of the post, I use "path-to-jboss" as this location.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;"> cd /path-to-jboss/</span></p><p><span style="font-family: courier new,courier; color: #000000;"> unzip ~/Downloads/jbpm-installer/lib/jboss-5.1.0.GA.zip</span></p><h3><span style="color: #000000;">Copy DB drivers into installer:</span></h3><p><span style="color: #000000;">If you are going to use a DB other than the default H2 db, you will need to place the drivers where the installer can find them. </span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;"><span style="font-family: courier new,courier;"> cp ~/Downloads/postgresql-9.1-901.jdbc4.jar </span><span style="font-family: courier new,courier;">~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/lib/</span></span></p><h3><span style="color: #000000;">Create the JBPM schema:</span></h3><p><span style="color: #000000;">You will need to create the jbpm schema/database for JBPM to use. I use jbpm5 in this post.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;"><br/></span></p><h2><span style="text-decoration: underline; font-family: arial,helvetica,sans-serif; color: #000000;">Configuration</span></h2><h3><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Update build.properties:</span></h3><p><span style="color: #000000;"><span style="font-family: arial,helvetica,sans-serif;">Next you will need to edit </span><span style="font-family: courier new,courier;">~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/</span><span style="font-family: courier new,courier;">build.properties<br/></span></span></p><h4><span style="color: #000000;">Drools Guvnor version:</span></h4><p><span style="color: #000000;">From what I read and remember experiencing, the version of Drools Govnor which is setup to be used by the installer will not work with JBoss AS 5.1, and instead you should use 5.3.1.Final. So change the following properties:</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;"># (Drools guvnor which works with JBoss AS 5.1)</span></p><p><span style="font-family: courier new,courier; color: #000000;">drools.guvnor.version=5.3.1.Final</span></p><p><span style="font-family: courier new,courier; color: #000000;">drools.guvnor.url=<a class="jive-link-external-small" href="https://repository.jboss.org/nexus/content/repositories/releases/org/drools/guvnor-distribution-wars/5.3.1.Final/guvnor-distribution-wars-5.3.1.Final-jboss-as-5.1.war" target="_blank">https://repository.jboss.org/nexus/content/repositories/releases/org/drools/guvnor-distribution-wars/5.3.1.Final/guvnor-distribution-wars-5.3.1.Final-jboss-as-5.1.war</a></span></p><h4><span style="color: #000000;">Designer version:</span></h4><p><span style="color: #000000;">Update the properties to use the correct version of the designer for AS 5. I changed the URL to a specific server because it looked like the installer got stuck when redirected so that part may not be necessary.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;">designer.version=2.2.Final-jboss </span></p><p><span style="font-family: courier new,courier; color: #000000;">#designer.url=<a class="jive-link-external-small" href="http://sourceforge.net/projects/jbpm/files/designer/designer-2.2/" target="_blank">http://sourceforge.net/projects/jbpm/files/designer/designer-2.2/</a></span></p><p><span style="font-family: courier new,courier; color: #000000;">designer.url=<a class="jive-link-external-small" href="http://iweb.dl.sourceforge.net/project/jbpm/designer/designer-2.2/" target="_blank">http://iweb.dl.sourceforge.net/project/jbpm/designer/designer-2.2/</a></span></p><h4><span style="font-family: arial,helvetica,sans-serif; color: #000000;">JBoss Home and version:</span></h4><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Uncomment/update the jboss.xxxx properties:</span></p><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;"><br/></span></p><p><span style="font-family: courier new,courier; color: #000000;">jboss.server.version=${jboss.server.version.5}</span></p><p><span style="font-family: courier new,courier; color: #000000;">jboss.home=/path-to-jboss/jboss-5.1.0.GA</span></p><p><span style="font-family: courier new,courier; color: #000000;">jboss.download.url=<a class="jive-link-external-small" href="http://downloads.sourceforge.net/jboss/jboss-$" target="_blank">http://downloads.sourceforge.net/jboss/jboss-$</a>{jboss.server.version}.zip</span></p><p><span style="font-family: courier new,courier; color: #000000;">jboss.server.configuration=default</span></p><p><span style="font-family: courier new,courier; color: #000000;">jboss.server.deploy.dir=${jboss.home}/server/${jboss.server.configuration}/deploy</span></p><p><span style="font-family: courier new,courier; color: #000000;">jboss.server.data.dir=${jboss.home}/server/${jboss.server.configuration}/data/</span></p><p><span style="font-family: courier new,courier; color: #000000;">jboss.clean.repository=true</span></p><h3><span style="color: #000000;">Update build.xml</span></h3><p><span style="color: #000000;">Edit <span style="font-family: courier new,courier;">~/Downloads/jbpm-installer/build.xml</span> to reflect the correct DB driver:</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;">Change<span style="font-family: courier new,courier;"> <property name="db.driver.jar.name" value="mysql-connector-java.jar"/></span> to <span style="font-family: courier new,courier;"><property name="db.driver.jar.name" value="postgresql-9.1-901.jdbc4.jar"/></span></span></p><h3><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Database specific files:</span></h3><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;">There are several files which need to be updated for JBoss AS 5 as well as for your specific DB dialect and configurations. <br/></span></p><h4><span style="color: #000000;">Edit db/persistence.xml:</span></h4><p><span style="color: #000000;">First edit <span style="font-family: courier new,courier;">~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/db/persistence.xml</span></span></p><h5><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Change the dialect and set DB specific configurations:</span></h5><p><span style="color: #000000;">I updated/added the follwing to the <span style="font-family: courier new,courier;"><properties> </span>section:</span></p><p><span style="font-family: courier new,courier; color: #000000;"> <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/></span></p><p><span style="font-family: courier new,courier; color: #000000;"> <property name="hibernate.default_schema" value="jbpm5"/></span></p><h5><span style="font-family: courier new,courier; color: #000000;"><span style="font-family: arial,helvetica,sans-serif;">Use AS5 transaction manager:</span><br/></span></h5><p><span style="color: #000000;">You will need to comment out the AS7 section and comment in the AS5 section:</span></p><p><span style="font-family: courier new,courier; color: #000000;">   <!-- for AS7 --></span></p><p><span style="font-family: courier new,courier; color: #000000;">   <!-- <property name="hibernate.transaction.manager_lookup_class" value="org.jbpm.integration.console.JBPMTransactionManager" /> --></span></p><p><span style="font-family: courier new,courier; color: #000000;">   <!-- for AS5 --></span></p><p><span style="font-family: courier new,courier; color: #000000;">   <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" /></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h5><span style="color: #000000;">Whole file:</span></h5><p><span style="color: #000000;">This is what my final file looked like:</span></p><p><span style="font-family: courier new,courier; color: #000000;"> <?xml version="1.0" encoding="UTF-8" standalone="yes"?></span></p><p><span style="font-family: courier new,courier; color: #000000;"> <persistence version="1.0"</span></p><p><span style="font-family: courier new,courier; color: #000000;">             xsi:schemaLocation="<a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a></span></p><p><span style="font-family: courier new,courier; color: #000000;">                                 <a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" target="_blank">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd</a></span></p><p><span style="font-family: courier new,courier; color: #000000;">                                 <a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a> </span></p><p><span style="font-family: courier new,courier; color: #000000;">                                 <a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" target="_blank">http://java.sun.com/xml/ns/persistence/orm_1_0.xsd</a>"</span></p><p><span style="font-family: courier new,courier; color: #000000;">             xmlns:orm="<a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/orm" target="_blank">http://java.sun.com/xml/ns/persistence/orm</a>"</span></p><p><span style="font-family: courier new,courier; color: #000000;">             xmlns:xsi="<a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>"</span></p><p><span style="font-family: courier new,courier; color: #000000;">             xmlns="<a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence" target="_blank">http://java.sun.com/xml/ns/persistence</a>"></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;">  <persistence-unit name="org.jbpm.persistence.jpa" transaction-type="JTA"></span></p><p><span style="font-family: courier new,courier; color: #000000;">    <provider>org.hibernate.ejb.HibernatePersistence</provider></span></p><p><span style="font-family: courier new,courier; color: #000000;">    <jta-data-source>java:jboss/datasources/jbpmDS</jta-data-source></span></p><p><span style="font-family: courier new,courier; color: #000000;">    <mapping-file>META-INF/JBPMorm.xml</mapping-file></span></p><p><span style="font-family: courier new,courier; color: #000000;">    <mapping-file>META-INF/ProcessInstanceInfo.hbm.xml</mapping-file></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;">    <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class></span></p><p><span style="font-family: courier new,courier; color: #000000;">    <class>org.drools.persistence.info.SessionInfo</class></span></p><p><span style="font-family: courier new,courier; color: #000000;">    <class>org.drools.persistence.info.WorkItemInfo</class></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;">    <class>org.jbpm.process.audit.ProcessInstanceLog</class></span></p><p><span style="font-family: courier new,courier; color: #000000;">    <class>org.jbpm.process.audit.NodeInstanceLog</class></span></p><p><span style="font-family: courier new,courier; color: #000000;">    <class>org.jbpm.process.audit.VariableInstanceLog</class></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;">    <properties></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.default_schema" value="jbpm5"/></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.max_fetch_depth" value="3"/></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <!-- hbm2ddl.auto MUST BE update! The console will otherwise overwrite the schema with each new thread --></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.hbm2ddl.auto" value="update" /></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.show_sql" value="false" /></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;">      <!-- for AS7 --></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <!-- <property name="hibernate.transaction.manager_lookup_class" value="org.jbpm.integration.console.JBPMTransactionManager" /> --></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <!-- for AS5 --></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" /></span></p><p><span style="font-family: courier new,courier; color: #000000;">    </properties></span></p><p><span style="font-family: courier new,courier; color: #000000;">  </persistence-unit></span></p><p><span style="font-family: courier new,courier; color: #000000;"> </persistence></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h4><span style="color: #000000;">Update db/persistence-as5.xml:</span></h4><p><span style="color: #000000;">Most of my problems came from things related to the DB, and it was unclear to me which files were being used/ignored, so for simplicity, I just copied persistence.xml on top of persistence-as5.xml.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;"><span style="font-family: courier new,courier;">cp ~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/db/persistence.xml </span> <span style="font-family: courier new,courier;">~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/db/persistence-as5.xml </span></span></p><h4><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Update task-service META-INF/persistence.xml:</span></h4><p><span style="color: #000000;"><span style="font-family: arial,helvetica,sans-serif;">Somewhere in the documentation, I read that </span><span style="font-family: courier new,courier;">task-service/resources/META-INF/persistence.xml</span><span style="font-family: arial,helvetica,sans-serif;"> must be updated. Even though I updated it, I don't think it was used for the installation, and I had to manually copy the file into the deploy directory (covered later in the post.) But go ahead and edit it here, this way you have it somewhere outside of the JBoss install in case you need it again.</span></span></p><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;"><br/></span></p><p><span style="color: #000000;">First edit <span style="font-family: courier new,courier;">~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/task-service/resources/META-INF/persistence.xml</span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;">You will need to add the <span style="font-family: courier new,courier;"><jta-data-source></span> section as well as configure the <span style="font-family: courier new,courier;"><properties></span> section:</span></p><p><span style="font-family: courier new,courier; color: #000000;">...</span></p><p><span style="font-family: courier new,courier; color: #000000;"> <persistence-unit name="org.jbpm.task"></span></p><p><span style="color: #000000;"><span style="font-family: courier new,courier;">  </span><span style="font-family: courier new,courier;"><provider>org.hibernate.ejb.HibernatePersistence</provider></span></span></p><p><span style="font-family: courier new,courier; color: #000000;"><strong>  <jta-data-source>java:jboss/datasources/jbpmDS</jta-data-source></strong></span></p><p><span style="font-family: courier new,courier; color: #000000;">  <mapping-file>META-INF/Taskorm.xml</mapping-file></span></p><p><span style="font-family: courier new,courier; color: #000000;">...</span></p><p><span style="font-family: courier new,courier; color: #000000;"> <properties></span></p><p><span style="font-family: courier new,courier; color: #000000;">  <property name="hibernate.dialect" value="org.hibernate.dialect.<strong>PostgreSQLDialect</strong>"/></span></p><p><span style="font-family: courier new,courier; color: #000000;"><strong>  <property name="hibernate.default_schema" value="jbpm5"/></strong></span></p><p><span style="font-family: courier new,courier; color: #000000;"><strong>  <property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/></strong></span></p><p><span style="font-family: courier new,courier; color: #000000;"><strong>  <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" /></strong></span></p><p><span style="font-family: courier new,courier; color: #000000;">  <property name="hibernate.connection.username" value="<strong>some_username</strong>"/></span></p><p><span style="font-family: courier new,courier; color: #000000;">  <property name="hibernate.connection.password" value="<strong>some_password</strong>"/></span></p><p><span style="font-family: courier new,courier; color: #000000;"> </properties></span></p><p><span style="font-family: courier new,courier; color: #000000;">...<br/></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h4><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Update task-service war/persistence.xml:</span></h4><p><span style="color: #000000;"><span style="font-family: arial,helvetica,sans-serif;">When things were not working because of problems talking to the DB, I found another persistence.xml file which I also updated. I changed the dialect, added the default_schema, and commented in the correct transaction.manager_lookup_class for AS5. </span><span style="font-family: arial,helvetica,sans-serif;">Again, I'm not sure if it was actually picked up and used.<br/></span></span></p><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;"><br/></span></p><p><span style="color: #000000;">Now edit <span style="font-family: courier new,courier;">~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/task-service/resources/war/persistence.xml</span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;">   <properties></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.dialect" value="org.hibernate.dialect.<strong>PostgreSQLDialect</strong>"/></span></p><p><span style="font-family: courier new,courier; color: #000000;"><strong>      <property name="hibernate.default_schema" value="jbpm5"/></strong></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.max_fetch_depth" value="3"/></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.hbm2ddl.auto" value="create" /></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <property name="hibernate.show_sql" value="false" /></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <!-- for AS7 --></span></p><p><span style="font-family: courier new,courier; color: #000000;"><strong>      <!--</strong> <property name="hibernate.transaction.manager_lookup_class" value="org.jbpm.integration.console.JBPMTransactionManager" /> <strong>--></strong></span></p><p><span style="font-family: courier new,courier; color: #000000;">      <!-- for AS5 --></span></p><p><span style="font-family: courier new,courier; color: #000000;"><strong>      <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" /></strong></span></p><p><span style="font-family: courier new,courier; color: #000000;">    </properties></span></p><h3><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Update the datasource:</span></h3><p><span style="color: #000000;"><span style="font-family: courier new,courier;"><span style="font-family: arial,helvetica,sans-serif;">Update </span>~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/db/jBPM-ds.xml <span style="font-family: arial,helvetica,sans-serif;">as needed. (Remember to change the driver)<br/></span></span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;">  <connection-url>jdbc:postgresql://some_host:5432/some_db_name</connection-url></span></p><p><span style="font-family: courier new,courier; color: #000000;">  <driver-class>org.postgresql.Driver</driver-class></span></p><p><span style="font-family: courier new,courier; color: #000000;">  <user-name>some_username</user-name></span></p><p><span style="font-family: courier new,courier; color: #000000;">  <password>some_password</password></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h2><span style="text-decoration: underline; font-family: arial,helvetica,sans-serif; color: #000000;">Installation</span></h2><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Okay, this part was easy. From inside the jbpm-installer/ directory just run:</span></p><p><span style="font-family: courier new,courier; color: #000000;">   ant install.demo.noeclipse</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h2><span style="text-decoration: underline; font-family: arial,helvetica,sans-serif; color: #000000;">Tweaking</span></h2><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Once everything was installed, I had a lot of errors when trying to start JBoss, so I had to tweak some of the stuff post install.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h3><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Remove the form builder:</span></h3><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;">For whatever reason, the form builder would not deploy and gave me this error:</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;"> [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfszip:/path-to-jboss/jboss-5.1.0.GA/server /default/deploy/jbpm-form-builder.war/ state=PreReal mode=Manual requiredState=Real</span></p><p><span style="font-family: courier new,courier; color: #000000;">org.jboss.deployers.spi.DeploymentException: Error deploying: vfszip:/path-to-jboss/jboss-5.1.0.GA/server/default/deploy/jbpm-form-builder.war/</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;">Since I'm probably not going to use the form builder, I just removed it. I thought maybe the war got corrupted, but I tried the install multiple times with the same error. If you have found a way to make this work, please add to this thread so others can get it working. <span> :) </span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;"> rm path-to-jboss/jboss-5.1.GA/server/default/deploy/jbpm-form-builder.war</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h3><span style="color: #000000;">Fix JBPM console:</span></h3><p><span style="color: #000000;">Out of the box, I got this error when trying to start JBoss:</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;">[org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=persistence.unit:unitName=#org.jbpm.persistence.jpa state=Create</span></p><p><span style="font-family: courier new,courier; color: #000000;">org.hibernate.DuplicateMappingException: Duplicate collection role mapping org.jbpm.persistence.processinstance.ProcessInstanceInfo.eventTypes</span></p><p><br/><span style="color: #000000;">Following this thread: <a class="jive-link-message-small" href="https://community.jboss.org/message/739278#739278">https://community.jboss.org/message/739278</a> I was able to fix the problem by renaming <span style="font-family: courier new,courier;">ProcessInstanceInfo.hbm.xml<span style="font-family: arial,helvetica,sans-serif;">.</span></span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;">I exploded the war, and made the necessary updates:</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"><span style="font-family: courier new,courier; color: #000000;"> </span> </p><p><span style="font-family: courier new,courier; color: #000000;"> cd path-to-jboss/jboss-5.1.GA/server/default/deploy/</span></p><p><span style="font-family: courier new,courier; color: #000000;"> # Because you can't have a dir with the same name as a file, I do the following 4 steps.<br/></span></p><p><span style="font-family: courier new,courier; color: #000000;"> mkdir tmp</span></p><p><span style="font-family: courier new,courier; color: #000000;"> mv jbpm-gwt-console-server.war tmp</span></p><p><span style="font-family: courier new,courier; color: #000000;"> mv tmp jbpm-gwt-console-server.war</span></p><p><span style="font-family: courier new,courier; color: #000000;"> cd tmp jbpm-gwt-console-server.war</span></p><p><span style="font-family: courier new,courier; color: #000000;"> unzip jbpm-gwt-console-server.war # Expload the war<br/></span></p><p><span style="font-family: courier new,courier; color: #000000;"> mv jbpm-gwt-console-server.war jbpm-gwt-console-server.orig # You could delete the original instead...<br/></span></p><p><span style="font-family: courier new,courier; color: #000000;"> cd WEB-INF/classes/META-INF/</span></p><p><span style="font-family: courier new,courier; color: #000000;"> mv ProcessInstanceInfo.hbm.xml ProcessInstanceInfo.orig # You could removed this file instead...</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h3><span style="color: #000000;">Fix human task war:</span></h3><p><span style="color: #000000;">I also had errors from the human-task war when starting JBoss:</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;">Error 1:</span></p><p><span style="font-family: courier new,courier; color: #000000;">[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/jbpm-human-task-war]] (main) StandardWrapper.Throwable</span></p><p><span style="font-family: courier new,courier; color: #000000;">javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;">Error 2:</span></p><p><span style="font-family: courier new,courier; color: #000000;">[org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=persistence.unit:unitName=#org.jbpm.task state=Create</span></p><p><span style="font-family: courier new,courier; color: #000000;">java.lang.RuntimeException: Specification violation [EJB3 JPA 6.2.1.2] - You have not defined a jta-data-source for a JTA enabled persistence context named: org.jbpm.task</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;">Error 3:</span></p><p><span style="font-family: courier new,courier; color: #000000;">[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/jbpm-human-task-war]] (main) StandardWrapper.Throwable</span></p><p><span style="font-family: courier new,courier; color: #000000;">java.lang.ClassCastException: org.jboss.tm.usertx.client.ServerVMClientUserTransaction cannot be cast to javax.transaction.UserTransaction</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;">Error #1 and #2 are due to a persistence.xml which is not setup for my configuration. Error #3 is because of conflicting classes in jta-1.1.jar which is inside the war.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;">So I exploded the war and made the changes:</span></p><p><span style="font-family: courier new,courier; color: #000000;"> cd path-to-jboss/jboss-5.1.GA/server/default/deploy/</span></p><p><span style="font-family: courier new,courier; color: #000000;"> mkdir tmp</span></p><p><span style="font-family: courier new,courier; color: #000000;"> mv jbpm-human-task-war.war tmp</span></p><p><span style="font-family: courier new,courier; color: #000000;"> mv tmp jbpm-human-task-war.war</span></p><p><span style="font-family: courier new,courier; color: #000000;"> cd jbpm-human-task-war.war</span></p><p><span style="font-family: courier new,courier; color: #000000;"> unzip jbpm-human-task-war.war</span></p><p><span style="font-family: courier new,courier; color: #000000;"> mv jbpm-human-task-war.war jbpm-human-task-war.orig</span></p><p><span style="font-family: courier new,courier; color: #000000;"> cp ~/Downloads/jbpm-installer/task-service/resources/META-INF/persistence.xml WEB-INF/classes/META-INF/ # Fixes 1 and 2</span></p><p><span style="font-family: courier new,courier; color: #000000;"> rm WEB-INF/lib/jta-1.1.jar # Fix 3</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h2><span style="text-decoration: underline; font-family: arial,helvetica,sans-serif; color: #000000;">Start JBoss</span></h2><p><span style="font-family: arial,helvetica,sans-serif; color: #000000;">After all this, I started JBoss with the ant task. (You could probably just start it from the bin dir.)</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;"><span style="font-family: courier new,courier;"> cd ~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/</span></span></p><p><span style="font-family: courier new,courier; color: #000000;"> ant start.demo.noeclipse</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier; color: #000000;"><span style="font-family: arial,helvetica,sans-serif;">When all was said and done, I was able to start jboss, user the jbpm-console, guvnor, and designer. <span> B-) </span></span><br/></span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Comment by <a href="https://community.jboss.org/docs/DOC-18580">going to Community</a></p>
<p style="margin: 0;">Create a new document in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=102&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>