<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Hi Kris<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks for the clues. But I have
bigger problems when I try to use the persistence with Oracle and EclipseLink(because
of project requirements).<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I have mentioned in the below
mail about the problems faced while migrating from H2 to Oracle. After fixing
these (Oracle with Hibernate) issues, now I am facing quite a few issues while
using EclipseLink (in place of Hibernate), like use of temporal types for
dates, etc. I tried fixing these issues one by one, but got stuck with this exception[1]
and no clue how to fix it. Any help would be appreciated.<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'>Local Exception Stack: </span><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'>Exception [EclipseLink-30005] (Eclipse
Persistence Services - 1.0.2 (Build 20081024)): </span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>org.eclipse.persistence.exceptions.PersistenceUnitLoadingException</span></u><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'>Exception Description: An exception was
thrown while searching for persistence archives with ClassLoader:
sun.misc.Launcher$AppClassLoader@133056f</span><span style='font-size:10.0pt;
font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'>Internal Exception: </span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>javax.persistence.PersistenceException</span></u><span
style='font-size:10.0pt;font-family:"Courier New";color:red'>: Exception
[EclipseLink-28018] (Eclipse Persistence Services - 1.0.2 (Build 20081024)): </span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>org.eclipse.persistence.exceptions.EntityManagerSetupException</span></u><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'>Exception Description: Predeployment of
PersistenceUnit [org.drools.task] failed.</span><span style='font-size:10.0pt;
font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'>Internal Exception: </span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>java.util.NoSuchElementException</span></u><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'> at
org.eclipse.persistence.exceptions.PersistenceUnitLoadingException.exceptionSearchingForPersistenceResources(</span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>PersistenceUnitLoadingException.java:121</span></u><span
style='font-size:10.0pt;font-family:"Courier New";color:red'>)</span><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'> at
org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactory(</span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>PersistenceProvider.java:117</span></u><span
style='font-size:10.0pt;font-family:"Courier New";color:red'>)</span><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'> at
org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactory(</span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>PersistenceProvider.java:64</span></u><span
style='font-size:10.0pt;font-family:"Courier New";color:red'>)</span><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'> at
javax.persistence.Persistence.createEntityManagerFactory(</span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>Persistence.java:83</span></u><span
style='font-size:10.0pt;font-family:"Courier New";color:red'>)</span><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'> at
javax.persistence.Persistence.createEntityManagerFactory(</span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>Persistence.java:60</span></u><span
style='font-size:10.0pt;font-family:"Courier New";color:red'>)</span><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'> at com.sample.RuleFlowTest.main(</span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>RuleFlowTest.java:51</span></u><span
style='font-size:10.0pt;font-family:"Courier New";color:red'>)</span><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:red'>Caused by: </span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>javax.persistence.PersistenceException</span></u><span
style='font-size:10.0pt;font-family:"Courier New";color:red'>: Exception
[EclipseLink-28018] (Eclipse Persistence Services - 1.0.2 (Build 20081024)): </span><u><span
style='font-size:10.0pt;font-family:"Courier New";color:navy'>org.eclipse.persistence.exceptions.EntityManagerSetupException</span></u><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New";
color:red'>Exception Description: Predeployment of PersistenceUnit
[org.drools.task] failed.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>-Umesh<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
rules-users-bounces@lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] <b>On Behalf Of </b>Kris Verlaenen<br>
<b>Sent:</b> Thursday, March 26, 2009 8:32 PM<br>
<b>To:</b> Rules Users List<br>
<b>Subject:</b> Re: [rules-users] Facing severe issues while using Persistence<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Umesh,</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Based
on the error in the H2 log, it seems like you are trying to assign tasks to a
user that is not in your users database. The task component contains a
list of possible users and methods to add new users. When creating a new
task, possible actors must be in the user list, otherwise the foreign key
constraint cannot be satisfied. By default, there should always be an
"Administrator" user, as all tasks are by default assigned to this
users. On top of that, you also need to add all possible users that you
use in your processes.</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>It
might be better to check for the existing users when trying to create a task
and give an appropriate error message if the user cannot be found ... I would
gladly apply a patch if you could find the time. Tasks are created in
WSHumanTaskHandler, so that would be the location to do these modifications.</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Kris</span><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>-----
Original Message ----- <o:p></o:p></span></p>
</div>
<blockquote style='border:none;border-left:solid black 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<div>
<p class=MsoNormal style='background:#E4E4E4'><b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'> <a
href="mailto:umesh.wankhede@arisglobal.co.in"
title="umesh.wankhede@arisglobal.co.in">Umesh Wankhede</a> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>To:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> <a
href="mailto:rules-users@lists.jboss.org" title="rules-users@lists.jboss.org">Rules
Users List</a> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Sent:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> Tuesday, March 24,
2009 2:07 PM<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Subject:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> [rules-users] Facing
severe issues while using Persistence<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal>Hi<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>While using workflow persistence feature (with human task
component), I am having quite a few problems. When I use default db (H2), I get
ConstraintViolationException [1]. Since I have to ultimately integrate with
Oracle, I modify the config files to point to Oracle. But with that I started
getting lot of other issues, like invalid column names (size, date), invalid
table name (Comment), SQLGrammarException, etc[2] (This is serious problem, if
you use Oracle!)<o:p></o:p></p>
<p class=MsoNormal>I am struggling for quite a few days to get this work, but
no success, any help would be greatly appreciated.<o:p></o:p></p>
<p class=MsoNormal>I am attaching the source code also[3].<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>[1]db-h2-errors.log<o:p></o:p></p>
<p class=MsoNormal>[2] db-oracle-errors.log<o:p></o:p></p>
<p class=MsoNormal>[3] RuleFlowTest.java, ruleflow.rf<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Regds<o:p></o:p></p>
<p class=MsoNormal>Umesh<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p> Legal Notice: This transmission, including any attachments, is
confidential, proprietary, and may be privileged. It is intended solely for the
intended recipient. If you are not the intended recipient, you
have received this transmission in error and you are hereby advised that
any review, disclosure, copying, distribution, or use of this transmission, or
any of the information included therein, is unauthorized and
strictly prohibited. If you have received this transmission in error,
please immediately notify the sender by reply and permanently delete all copies
of this transmission and its attachments<o:p></o:p></p>
<p> <o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>_______________________________________________<br>
rules-users mailing list<br>
rules-users@lists.jboss.org<br>
https://lists.jboss.org/mailman/listinfo/rules-users<o:p></o:p></span></p>
</blockquote>
</div>
</body>
<!--[object_id=#arisglobal.co.in#]--><P dir=ltr style="MARGIN-RIGHT: 0px" align=left> Legal Notice: This transmission, including any attachments, is confidential, proprietary, and may be privileged. It is intended solely for the intended recipient. If you are not the intended recipient, you have received this transmission in error and you are hereby advised that any review, disclosure, copying, distribution, or use of this transmission, or any of the information included therein, is unauthorized and strictly prohibited. If you have received this transmission in error, please immediately notify the sender by reply and permanently delete all copies of this transmission and its attachments</P>
<P dir=ltr style="MARGIN-RIGHT: 0px" align=left> </P></html>