<!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/message/741521#741521">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>A few days ago I tried to get JBPM 5.3 installed into JBoss AS 5.1 using PostgreSQL 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 tiral and error.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Hopefully this post will help others at least get to this point. <span> :) </span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h2>My configuration:</h2><p>Ubuntu 12.04</p><p>java version "1.6.0_24"</p><p>OpenJDK Runtime Environment (IcedTea6 1.11.1) (6b24-1.11.1-4ubuntu3)</p><p>OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)</p><p>JBoss 5.1.0GA</p><p>PostgreSQL 9.1.4 on x86_64</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h2><span style="text-decoration: underline;">Preparation</span></h2><h3>Get the installer:</h3><p>The first thing I did was download the jbpm-installer and unzip it into ~/Downloads/jbpm-installer/ and this is the directory/path I will use for the rest of this post.</p><h3>Save some download time:</h3><p>If you are like me, you probably already had 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.)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier;"> cd </span><span style="font-family: courier new,courier;">~/Downloads/jbpm-installer/</span></p><p><span style="font-family: courier new,courier;"> cp ~/Downloads/jboss-5.1.0.GA.zip lib/</span></p><p><span style="font-family: courier new,courier;"> 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>Prepare the JBoss installtion directory:</h3><p>You will need to setup a JBoss installation folder for the installer to install into. For the rest of the post, I use "path-to-jboss" as this location.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier;"> cd /path-to-jboss/</span></p><p><span style="font-family: courier new,courier;"> unzip ~/Downloads/jbpm-installer/lib/jboss-5.1.0.GA.zip</span></p><h3>Copy DB drivers into installer:</h3><p>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. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><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></p><h2><span style="text-decoration: underline; font-family: courier new,courier;">Configuration</span></h2><h3><span style="font-family: courier new,courier;">Update build.properties:</span></h3><p><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></p><h4>Drools Guvnor version:</h4><p>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 5.1, and instead you should use 5.3.1.Final. So change the following properties in  build.properties as follows:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier;"># (Drools guvnor which works with JBoss AS 5.1)</span></p><p><span style="font-family: courier new,courier;">drools.guvnor.version=5.3.1.Final</span></p><p><span style="font-family: courier new,courier;"><span>drools.guvnor.url=</span><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>Designer version:</h4><p>Update 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 redirecter, this may not be necessary.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier;">designer.version=2.2.Final-jboss </span></p><p><span style="font-family: courier new,courier;"><span>#designer.url=</span><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;"><span>designer.url=</span><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;">JBoss Home and version:</span></h4><p><span style="font-family: arial,helvetica,sans-serif;">Uncomment/update the jboss.xxxx properties:</span></p><p><span style="font-family: arial,helvetica,sans-serif;"><br/></span></p><p><span style="font-family: courier new,courier;">jboss.server.version=${jboss.server.version.5}</span></p><p><span style="font-family: courier new,courier;">jboss.home=<path-to-jboss>/jboss-5.1.0.GA</span></p><p><span style="font-family: courier new,courier;"><span>jboss.download.url=</span><a class="jive-link-external-small" href="http://downloads.sourceforge.net/jboss/jboss-$" target="_blank">http://downloads.sourceforge.net/jboss/jboss-$</a><span>{jboss.server.version}.zip</span></span></p><p><span style="font-family: courier new,courier;">jboss.server.configuration=default</span></p><p><span style="font-family: courier new,courier;">jboss.server.deploy.dir=${jboss.home}/server/${jboss.server.configuration}/deploy</span></p><p><span style="font-family: courier new,courier;">jboss.server.data.dir=${jboss.home}/server/${jboss.server.configuration}/data/</span></p><p><span style="font-family: courier new,courier;">jboss.clean.repository=true</span></p><h3>Update build.xml</h3><p>Edit <span style="font-family: courier new,courier;">~/Downloads/jbpm-installer/build.xml</span> to reflect the correct DB driver:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>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></p><h3><span style="font-family: courier new,courier;">Database specific files:</span></h3><p><span style="font-family: arial,helvetica,sans-serif;">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>Edit db/persistence.xml:</h4><p>First edit <span style="font-family: courier new,courier;">~/Downloads/</span><span style="font-family: courier new,courier;">jbpm-installer/db/persistence.xml</span></p><h5><span style="font-family: courier new,courier;">Change the dialect and set DB specific configurations:</span></h5><p>I updated/added the follwing to the <span style="font-family: courier new,courier;"><properties> </span>section:</p><p><span style="font-family: courier new,courier;"> <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/></span></p><p><span style="font-family: courier new,courier;"> <property name="hibernate.default_schema" value="jbpm5"/></span></p><h5><span style="font-family: courier new,courier;">Use AS5 transaction manager:<br/></span></h5><p>You will need to comment out the AS7 section and comment in the AS5 section:</p><p><span style="font-family: courier new,courier;">   <!-- for AS7 --></span></p><p><span style="font-family: courier new,courier;">   <!-- <property name="hibernate.transaction.manager_lookup_class" value="org.jbpm.integration.console.JBPMTransactionManager" /> --></span></p><p><span style="font-family: courier new,courier;">   <!-- for AS5 --></span></p><p><span style="font-family: courier new,courier;">   <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>Whole file:</h5><p><span style="font-family: courier new,courier;"> <?xml version="1.0" encoding="UTF-8" standalone="yes"?></span></p><p><span style="font-family: courier new,courier;"> <persistence version="1.0"</span></p><p><span style="font-family: courier new,courier;"><span>             xsi:schemaLocation="</span><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;"><span>                                 </span><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;"><span>                                 </span><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> </span></span></p><p><span style="font-family: courier new,courier;"><span>                                 </span><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>"</span></span></p><p><span style="font-family: courier new,courier;"><span>             xmlns:orm="</span><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>"</span></span></p><p><span style="font-family: courier new,courier;"><span>             xmlns:xsi="</span><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>"</span></span></p><p><span style="font-family: courier new,courier;"><span>             xmlns="</span><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>"></span></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier;">  <persistence-unit name="org.jbpm.persistence.jpa" transaction-type="JTA"></span></p><p><span style="font-family: courier new,courier;">    <provider>org.hibernate.ejb.HibernatePersistence</provider></span></p><p><span style="font-family: courier new,courier;">    <jta-data-source>java:jboss/datasources/jbpmDS</jta-data-source></span></p><p><span style="font-family: courier new,courier;">    <mapping-file>META-INF/JBPMorm.xml</mapping-file></span></p><p><span style="font-family: courier new,courier;">    <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;">    <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class></span></p><p><span style="font-family: courier new,courier;">    <class>org.drools.persistence.info.SessionInfo</class></span></p><p><span style="font-family: courier new,courier;">    <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;">    <class>org.jbpm.process.audit.ProcessInstanceLog</class></span></p><p><span style="font-family: courier new,courier;">    <class>org.jbpm.process.audit.NodeInstanceLog</class></span></p><p><span style="font-family: courier new,courier;">    <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;">    <properties></span></p><p><span style="font-family: courier new,courier;">      <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/></span></p><p><span style="font-family: courier new,courier;">      <property name="hibernate.default_schema" value="jbpm5"/></span></p><p><span style="font-family: courier new,courier;">      <property name="hibernate.max_fetch_depth" value="3"/></span></p><p><span style="font-family: courier new,courier;">      <!-- 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;">      <property name="hibernate.hbm2ddl.auto" value="update" /></span></p><p><span style="font-family: courier new,courier;">      <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;">      <!-- for AS7 --></span></p><p><span style="font-family: courier new,courier;">      <!-- <property name="hibernate.transaction.manager_lookup_class" value="org.jbpm.integration.console.JBPMTransactionManager" /> --></span></p><p><span style="font-family: courier new,courier;">      <!-- for AS5 --></span></p><p><span style="font-family: courier new,courier;">      <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" /></span></p><p><span style="font-family: courier new,courier;">    </properties></span></p><p><span style="font-family: courier new,courier;">  </persistence-unit></span></p><p><span style="font-family: courier new,courier;"> </persistence></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h4>Update db/persistence-as5.xml:</h4><p>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.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><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></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><h4><span style="font-family: courier new,courier;">Update task-service:</span></h4><p><span style="font-family: arial,helvetica,sans-serif;">Somewhere in the documentation, I read that this file 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></p><p><span style="font-family: arial,helvetica,sans-serif;"><br/></span></p><p>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></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: arial,helvetica,sans-serif;">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;">...</span></p><p> <span style="font-family: courier new,courier;"><persistence-unit name="org.jbpm.task"></span></p><p><span style="font-family: courier new,courier;">  </span><span style="font-family: courier new,courier;"><provider>org.hibernate.ejb.HibernatePersistence</provider></span></p><p><strong style="font-family: courier new,courier;">  <jta-data-source>java:jboss/datasources/jbpmDS</jta-data-source></strong></p><p><span style="font-family: courier new,courier;">  <mapping-file>META-INF/Taskorm.xml</mapping-file></span></p><p><span style="font-family: courier new,courier;">...</span></p><p><span style="font-family: courier new,courier;"> <properties></span></p><p><span style="font-family: courier new,courier;">  <property name="hibernate.dialect" value="org.hibernate.dialect.<strong>PostgreSQLDialect</strong>"/></span></p><p><strong style="font-family: courier new,courier;">  <property name="hibernate.default_schema" value="jbpm5"/></strong></p><p><strong style="font-family: courier new,courier;">  <property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/></strong></p><p><strong style="font-family: courier new,courier;">  <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" /></strong></p><p><span style="font-family: courier new,courier;">  <property name="hibernate.connection.username" value="<strong>some_username</strong>"/></span></p><p><span style="font-family: courier new,courier;">  <property name="hibernate.connection.password" value="<strong>some_password</strong>"/></span></p><p><span style="font-family: courier new,courier;"> </properties></span></p><p><span style="font-family: courier new,courier;">...<br/></span></p><p><span style="font-family: arial,helvetica,sans-serif;"><br/></span></p><h3><span style="font-family: courier new,courier;">Update the datasource:</span></h3><p><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></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier;">  <connection-url>jdbc:postgresql://some_host:5432/some_db_name</connection-url></span></p><p><span style="font-family: courier new,courier;">  <driver-class>org.postgresql.Driver</driver-class></span></p><p><span style="font-family: courier new,courier;">  <user-name>some_username</user-name></span></p><p><span style="font-family: courier new,courier;">  <password>some_password</password></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-family: courier new,courier;"><br/></span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/741521#741521">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>