<!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=iso-8859-1">
<META content="MSHTML 6.00.6000.16809" name=GENERATOR>
<STYLE>@font-face {
font-family: Calibri;
}
@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
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-compose
}
.MsoChpDefault {
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=#ffffff>
<DIV><FONT face=Arial size=2>Umesh,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Kris</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=umesh.wankhede@arisglobal.co.in
href="mailto:umesh.wankhede@arisglobal.co.in">Umesh Wankhede</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=rules-users@lists.jboss.org
href="mailto:rules-users@lists.jboss.org">Rules Users List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, March 24, 2009 2:07
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [rules-users] Facing severe
issues while using Persistence</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<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></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>
<P>
<HR>
<P></P>_______________________________________________<BR>rules-users mailing
list<BR>rules-users@lists.jboss.org<BR>https://lists.jboss.org/mailman/listinfo/rules-users<BR></BLOCKQUOTE></BODY></HTML>