<!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: JBPM 5.2 and tomcat 7.0 and oracle 10 integration
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/smclenahan">smclenahan</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/741449#741449">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 have posted an example of how to do this with Oracle 11g Express at the following location - note this will assume you have the H2 installation working as described in a related post.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><a class="jive-link-external-small" href="http://ironclaws.wordpress.com/2012/06/13/jbpm-5-2-tomcat-7-oracle-11g-express-demo/">http://ironclaws.wordpress.com/2012/06/13/jbpm-5-2-tomcat-7-oracle-11g-express-demo/</a></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>For Oracle 10g - If using Express you will probably find that this example will work as is - maybe a slightly different Oracle JDBC driver version required.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>For non express Oracle - assuming you have granted create database privileges to your user - all should work fine. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I think though from a best practices point of view it is probably better to continue the pattern set by express and create the target database independently in the instance, and grant only the object creation rights to the user.</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/741449#741449">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>