<!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;">
Re: Database Schema for Enterprise Install
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/cameron.moloney">Cameron Moloney</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/743519#743519">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 would have to say that although i have got this stuff all working with Oracle now - reliance on JPA and persistence units for the database creation is just a hideous nightmare.</p><p>The fact that you have to trawl into various jar files to modify persistence.xml files and mappings if your database platform varies from the provided h2 database is a real headache.  Even just changing the database host for different environments is non-trivial - particularly if you want your application and the JBPM toolset to point to a persistent database.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>If you are planning on using Maven for your build process, and plan on running jbpm inside a container, be prepared for significant packaging issues!</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The provided hibernate mappings are not compatible with Hibernate 4 and Oracle.  The Maven dependencies for 5.2.0.Final are not compatible with JBoss AS7.  Virtually every step of what should have been a simple process has been time consuming and frustrating.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>If you are looking for an 'install and use' component in your system to provide BPMN workflow capability - i definitely wouldn't recommend JBPM5 at this stage.  I would be looking at Bonita or something more mature.</p><p>Unfortunately, we had this part of the technology dictated to us for a proof-of-concept.  I will certainly have a reasonable amount to say in the lessons learned phase of the POC.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I also wonder what the upgrade path is going to be for these components?  If DDL was provided, at least you could assess if there were any structural changes - and plan data migrations to the new strucutre.  As far as I can tell, the process currently would be to run the jbpm componets with hibernate auto create set to 'create' or 'update', assess if the resulting schema differs from the previous one - and then worry about how you get your data from the old one to the new one.</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/743519#743519">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>