<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I just saw your email, we tried to stick to the EJ3/JPA spec, is there
something we have used that is beyond those specs that oracle or
eclipse link don't support? Or is it you are using old
eclipselink/oracle libraries that aren't fully ejb3/jpa compliant?<br>
<br>
Unfortunately I know noting about EclipseLink. But if you figure all
these things out, could you send in some notes for others users and
also some suggestions on how we can improve things to make it easier to
work across persistence impl.<br>
<br>
Mark<br>
Umesh Wankhede wrote:
<blockquote
cite="mid:05320D8FE728A846AC1973B86F8026A90474CB6C@indxchange01.agi.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<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.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{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]-->
<div class="Section1">
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">The root
cause is java.util.NoSuchElementException
as you can see in the stack.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<div
style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">
<a class="moz-txt-link-abbreviated" href="mailto:rules-users-bounces@lists.jboss.org">rules-users-bounces@lists.jboss.org</a>
[<a class="moz-txt-link-freetext" href="mailto:rules-users-bounces@lists.jboss.org">mailto:rules-users-bounces@lists.jboss.org</a>] <b>On Behalf Of </b>Anstis,
Michael (M.)<br>
<b>Sent:</b> Monday, March 30, 2009 6:07 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>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: blue;">This
looks like a JPA issue; have you configured your
PersistenceUnit?</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"> <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: blue;">I
haven't used EclipseLink but in other IDE's you can create a PU
graphically. There's always persistence.xml to fall back to as well.</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"> <o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: blue;">Looks
like EclipseLink can't find a PU definition.</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><o:p></o:p></span></p>
<blockquote
style="margin-top: 5pt; margin-right: 0in; margin-bottom: 5pt;">
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><o:p> </o:p></span></p>
<div class="MsoNormal" style="text-align: center;" align="center"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";">
<hr align="center" size="2" width="100%"></span></div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">
<a class="moz-txt-link-abbreviated" href="mailto:rules-users-bounces@lists.jboss.org">rules-users-bounces@lists.jboss.org</a>
[<a class="moz-txt-link-freetext" href="mailto:rules-users-bounces@lists.jboss.org">mailto:rules-users-bounces@lists.jboss.org</a>] <b>On Behalf Of </b>Umesh
Wankhede<br>
<b>Sent:</b> 30 March 2009 13:10<br>
<b>To:</b> Rules Users List<br>
<b>Subject:</b> RE: [rules-users] Facing severe issues while using
Persistence</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Hi Kris<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">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: rgb(31, 73, 125);">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"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">Local
Exception Stack: </span><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">Exception
[EclipseLink-30005] (Eclipse Persistence Services - 1.0.2
(Build 20081024)): </span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">org.eclipse.persistence.exceptions.PersistenceUnitLoadingException</span></u><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; 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: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">Internal
Exception: </span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">javax.persistence.PersistenceException</span></u><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">:
Exception
[EclipseLink-28018] (Eclipse Persistence Services - 1.0.2 (Build
20081024)): </span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">org.eclipse.persistence.exceptions.EntityManagerSetupException</span></u><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">Exception
Description: Predeployment of PersistenceUnit
[org.drools.task] failed.</span><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">Internal
Exception: </span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">java.util.NoSuchElementException</span></u><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">
at
org.eclipse.persistence.exceptions.PersistenceUnitLoadingException.exceptionSearchingForPersistenceResources(</span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">PersistenceUnitLoadingException.java:121</span></u><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">)</span><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">
at
org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactory(</span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">PersistenceProvider.java:117</span></u><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">)</span><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">
at
org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactory(</span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">PersistenceProvider.java:64</span></u><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">)</span><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">
at
javax.persistence.Persistence.createEntityManagerFactory(</span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">Persistence.java:83</span></u><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">)</span><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">
at
javax.persistence.Persistence.createEntityManagerFactory(</span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">Persistence.java:60</span></u><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">)</span><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">
at com.sample.RuleFlowTest.main(</span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">RuleFlowTest.java:51</span></u><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">)</span><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">Caused
by: </span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">javax.persistence.PersistenceException</span></u><span
style="font-size: 10pt; font-family: "Courier New"; color: red;">:
Exception
[EclipseLink-28018] (Eclipse Persistence Services - 1.0.2 (Build
20081024)): </span><u><span
style="font-size: 10pt; font-family: "Courier New"; color: navy;">org.eclipse.persistence.exceptions.EntityManagerSetupException</span></u><span
style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; 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: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">-Umesh<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<div
style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">
<a class="moz-txt-link-abbreviated" href="mailto:rules-users-bounces@lists.jboss.org">rules-users-bounces@lists.jboss.org</a>
[<a class="moz-txt-link-freetext" href="mailto:rules-users-bounces@lists.jboss.org">mailto:rules-users-bounces@lists.jboss.org</a>]
<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: 10pt; font-family: "Arial","sans-serif";">Umesh,</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 10pt; 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: 12pt; font-family: "Times New Roman","serif";"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 10pt; 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: 12pt; font-family: "Times New Roman","serif";"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">Kris</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";">-----
Original Message ----- <o:p></o:p></span></p>
</div>
<blockquote
style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color black; border-width: medium medium medium 1.5pt; margin: 5pt 0in 5pt 3.75pt; padding: 0in 0in 0in 4pt;">
<div>
<p class="MsoNormal"
style="background: rgb(228, 228, 228) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><b><span
style="font-size: 10pt; font-family: "Arial","sans-serif";">From:</span></b><span
style="font-size: 10pt; font-family: "Arial","sans-serif";"> <a
moz-do-not-send="true" 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: 10pt; font-family: "Arial","sans-serif";">To:</span></b><span
style="font-size: 10pt; font-family: "Arial","sans-serif";"> <a
moz-do-not-send="true" 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: 10pt; font-family: "Arial","sans-serif";">Sent:</span></b><span
style="font-size: 10pt; 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: 10pt; font-family: "Arial","sans-serif";">Subject:</span></b><span
style="font-size: 10pt; 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: 12pt; 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" style="text-align: center;" align="center"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";">
<hr align="center" size="2" width="100%"></span></div>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";">_______________________________________________<br>
rules-users mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a><o:p></o:p></span></p>
</blockquote>
<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>
</blockquote>
</div>
<!--[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>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
rules-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a>
</pre>
</blockquote>
<br>
</body>
</html>