<!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="http://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;">
Re: How to install jBPM 5.0 on a JBoss AS
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/melc">Chris Melas</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/603218#603218">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I'm glad everything worked fine so far <span> :) </span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>In order to change the persistence of jbpm from h2 to some other data source you need to change the values of the jdbc driver, dialect, jdbc connection url,username, password within testDS1-ds.xml and the persistence.xml, hibernate.cfg.xml files found in the following files,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>1. jbpm-human-task-5.xxxx.jar (inside META-INF)</p><p>2. jbpm-bam-5.xxxx.jar</p><p>3. jbpm-gwt-console-server-5.xxxx.war (WEB-INF/classes/META-INF)</p><p>4. testDS1-ds.xml after installation is located in jboss (i.e. /jboss-5.1.0.GA/server/default/deploy/testDS1-ds.xml).</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>p.s.1 After the installation you'll have to replace these jar files after you've changed their persistence.xml and hibernate.cfg.xml, within the runtime folder that has been created and within the jbpm-gwt-console-server.war that is deployed in jboss (i.e. /jboss-5.1.0.GA/server/default/deploy/).</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>p.s.2 you might want to comment out after the first run the <property name="hbm2ddl.auto">create</property> found inside persistence and hibernate files ,  since this property will recreate the db each time jbpm and the human task are restarted, in other words all data persisted in the jbpm db tables will be deleted.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>p.s.3 if you use console reporting the birt reports will also have to be edited to point to the new datasource</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/603218#603218">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://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>