<!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;">
Getting error on retriving personal task for human task workflow with jbpm 5.3 and oracle 11g r2 database.
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/vkn...">vikas k</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/793702#793702">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi,</p><p>I am trying to integrate JBPM 5.3 with oracle 11 g r2.I am getting schema created properly on the database with below tables.<br/>I have created a human task sample workflow with web designer and deployed from there.I am able to start the flow but then when I login with the owner of humantask and try to retrive the personal task,I am getting errors.</p><p>I have attached server log file and error snapshot.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Where as I am able to run Evalution process successfully for jbpm 5.3 with oracle as database.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Kindly direct me on this problem for solution.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><br/>Tables</p><p>ATTACHMENT<br/>BOOLEANEXPRESSION<br/>CONTACTS<br/>CONTENT<br/>DEADLINE<br/>DELEGATION_DELEGATES<br/>EMAIL_HEADER<br/>ESCALATION<br/>EVENTTYPES<br/>I18NTEXT<br/>NODEINSTANCELOG<br/>NOTIFICATION<br/>NOTIFICATION_BAS<br/>NOTIFICATION_EMAIL_HEADER<br/>NOTIFICATION_RECIPIENTS<br/>ORGANIZATIONALENTITY<br/>PEOPLEASSIGNMENTS_BAS<br/>PEOPLEASSIGNMENTS_EXCLOWNERS<br/>PEOPLEASSIGNMENTS_POTOWNERS<br/>PEOPLEASSIGNMENTS_RECIPIENTS<br/>PEOPLEASSIGNMENTS_STAKEHOLDERS<br/>PROCESSINSTANCEINFO<br/>PROCESSINSTANCELOG<br/>REASSIGNMENT<br/>REASSIGNMENT_POTENTIALOWNERS<br/>ROLES<br/>SESSIONINFO<br/>SUBTASKSSTRATEGY<br/>TASK<br/>TASK_COMMENT<br/>VARIABLEINSTANCELOG<br/>WORKITEMINFO</p><p><br/>Modification done for h2 database change to oracle 11 g r2</p><p>1. Modified installer_home/db/persistence.xml</p><p><br/> <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/><br/>     <br/>2.Modified installer_home/db/driver_jar_module.xml</p><p><br/><module xmlns="urn:jboss:module:1.0" name="com.oracle.ojdbc6"><br/>   <resources><br/>     <resource-root path="ojdbc6.jar"/><br/>   </resources><br/>   <br/>   <br/> 3. Modified  installer_home\task-service\resources\META-INF\persistence.xml<br/>   <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/><br/>      <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver"/><br/>      <property name="hibernate.connection.url" value="jdbc:oracle:thin:@IP:1521:SID" /><br/>      <property name="hibernate.connection.username" value="USER"/><br/>      <property name="hibernate.connection.password" value="PASSWORD"/><br/> <br/> 4.Modified installer_home\task-service\resources\war\persistence.xml<br/> <br/> <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/><br/> <br/> 5. Modified installer_home\build.xml<br/> <br/>  <property name="db.driver.module.prefix" value="com/oracle/ojdbc6"/><br/>  <br/>  <br/>  <property name="db.driver.jar.name" value="ojdbc6.jar" /><br/>  <br/>  <br/>  6. Modified installer_home\standalone.xml<br/>  <br/>  <br/>   <datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" jta="true" use-java-context="true" use-ccm="true"><br/>                    <connection-url>jdbc:oracle:thin:@IP:1521:SID</connection-url><br/>                    <driver>oracle</driver><br/>                    <pool><br/>                        <min-pool-size>1</min-pool-size><br/>                        <max-pool-size>4</max-pool-size><br/>                        <prefill>false</prefill><br/>                        <use-strict-min>false</use-strict-min><br/>                        <flush-strategy>FailingConnectionOnly</flush-strategy><br/>                    </pool><br/>                    <security><br/>                       <user-name>USER</user-name><br/>                       <password>PASSWORD</password><br/>                    </security><br/>                    <validation><br/>                       <check-valid-connection-sql>SELECT 1 from dual</check-valid-connection-sql><br/>                       <validate-on-match>false</validate-on-match><br/>                       <background-validation>false</background-validation><br/>                    </validation><br/>                </datasource><br/>                <drivers><br/>                    <driver name="oracle" module="com.oracle.ojdbc6"><br/>                        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class><br/>                        <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class><br/>                    </driver><br/>    </drivers><br/>            </datasources></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/793702#793702">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>