<!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: Oracle schema for jbpm 5.4
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/swiderski.maciej">Maciej Swiderski</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/780027#780027">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>yes, it has slightly changed. In 5.4 installer script there are two new targets that allows you to generate DDL scripts from persistence.xml files:</p><p>- jbpm.schemaexport</p><p>- ht.schemaexport</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>then in installer_home/db you'll fine several persistence files important for DDL generation are:</p><p>- jbpm-persistence-JPA1.xml</p><p>- jbpm-persistence-JPA2.xml</p><p>- task-persistence-JPA1.xml</p><p>- task-persistence-JPA2.xml</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>what you need to do is to simply edit one that interesting for you and change hibernate dialect to the one that matches your data base and next run schema export ant targets and you'll get your DDL scripts in installer_home/db/export-jbpm and/or installer_home.db/export-ht</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>by default it runs on JPA2 based persistence.xml files and uses hibernate 4 to generate ddl, it can be altered by specifying system properly when executing ant -D<span class="s">jpa.version=JPA1</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span class="s">HTH<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/780027#780027">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>