<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3314" name=GENERATOR><!--[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-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman","serif"; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal
}
SPAN.EmailStyle19 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
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 lang=EN-US vLink=purple link=blue bgColor=white>
<DIV dir=ltr align=left><SPAN class=292183412-30032009><FONT face=Arial
color=#0000ff size=2>This looks like a JPA issue; have you configured your
PersistenceUnit?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=292183412-30032009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=292183412-30032009><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=292183412-30032009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=292183412-30032009><FONT face=Arial
color=#0000ff size=2>Looks like EclipseLink can't find a PU
definition.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rules-users-bounces@lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] <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<BR></FONT><BR></DIV>
<DIV></DIV>
<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><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">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; COLOR: red; FONT-FAMILY: 'Courier New'">Exception
[EclipseLink-30005] (Eclipse Persistence Services - 1.0.2 (Build 20081024)):
</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">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; COLOR: red; FONT-FAMILY: 'Courier New'">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; COLOR: red; FONT-FAMILY: 'Courier New'">Internal
Exception: </SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">javax.persistence.PersistenceException</SPAN></U><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">: Exception
[EclipseLink-28018] (Eclipse Persistence Services - 1.0.2 (Build 20081024)):
</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">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; COLOR: red; FONT-FAMILY: 'Courier New'">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; COLOR: red; FONT-FAMILY: 'Courier New'">Internal
Exception: </SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">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; COLOR: red; FONT-FAMILY: 'Courier New'">
at
org.eclipse.persistence.exceptions.PersistenceUnitLoadingException.exceptionSearchingForPersistenceResources(</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">PersistenceUnitLoadingException.java:121</SPAN></U><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">)</SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">
at
org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactory(</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">PersistenceProvider.java:117</SPAN></U><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">)</SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">
at
org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactory(</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">PersistenceProvider.java:64</SPAN></U><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">)</SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">
at javax.persistence.Persistence.createEntityManagerFactory(</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">Persistence.java:83</SPAN></U><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">)</SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">
at javax.persistence.Persistence.createEntityManagerFactory(</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">Persistence.java:60</SPAN></U><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">)</SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">
at com.sample.RuleFlowTest.main(</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">RuleFlowTest.java:51</SPAN></U><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">)</SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">Caused by:
</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">javax.persistence.PersistenceException</SPAN></U><SPAN
style="FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: 'Courier New'">: Exception
[EclipseLink-28018] (Eclipse Persistence Services - 1.0.2 (Build 20081024)):
</SPAN><U><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">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; COLOR: red; FONT-FAMILY: 'Courier New'">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-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<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'">
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: 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-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 4pt; PADDING-BOTTOM: 0in; MARGIN: 5pt 0in 5pt 3.75pt; BORDER-LEFT: black 1.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: medium none">
<DIV>
<P class=MsoNormal style="BACKGROUND: #e4e4e4"><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
title=umesh.wankhede@arisglobal.co.in
href="mailto: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
title=rules-users@lists.jboss.org
href="mailto: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 width="100%" SIZE=2>
</SPAN></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; 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><!--[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></BLOCKQUOTE></BODY></HTML>