Issue with drools-flow/persistence
by Daniel Ilkovich
I'm stumped. I'm trying to implement persistence with Drools-flow, and I'd
like to grab the value of a property on a workitem / processinstance, but
everytime I try to get the workitem or process instance I end up with the
stack trace below.
I'm walking through the source and from what I can tell, this happens
anytime I try and grab a property that is annotated with @Lob in an entity
class.
My environment is hibernate/mysql/JPA persistence using BTM as a transaction
manager.
These are the relevant lines of code:
ksession =
JPAKnowledgeService.loadStatefulKnowledgeSession(ksession.getId(), m_kbase ,
null, m_environment);
m_pi = ksession.getProcessInstance(m_pi.getId());
What am I doing wrong?
<pre>
<code>
java.lang.NullPointerException
at java.io.ByteArrayInputStream.<init>(ByteArrayInputStream.java:89)
at
org.drools.persistence.processinstance.ProcessInstanceInfo.getProcessInstance(ProcessInstanceInfo.java:135)
at
org.drools.persistence.processinstance.JPAProcessInstanceManager.getProcessInstance(JPAProcessInstanceManager.java:62)
at
org.drools.common.AbstractWorkingMemory.getProcessInstance(AbstractWorkingMemory.java:1793)
at
org.drools.impl.StatefulKnowledgeSessionImpl.getProcessInstance(StatefulKnowledgeSessionImpl.java:261)Hibernate:
select at
org.drools.command.runtime.process.GetProcessInstanceCommand.execute(GetProcessInstanceCommand.java:29)
at
org.drools.command.runtime.process.GetProcessInstanceCommand.execute(GetProcessInstanceCommand.java:12)
at
org.drools.persistence.session.SingleSessionCommandService.execute(SingleSessionCommandService.java:254)
at
org.drools.command.impl.CommandBasedStatefulKnowledgeSession.getProcessInstance(CommandBasedStatefulKnowledgeSession.java:95)
at
com.thoughtvine.tracks.workflow.TracksFlow.getParameterFromWorkItem(TracksFlow.java:182)
at
com.thoughtvine.tracks.workflow.test.TestTracksFlow.testGetWorkItem(TestTracksFlow.java:118)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
at
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
at
org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
</code>
</pre>
16 years, 3 months
- 2
- 2
Performance comparasion of D3.0 and D5.0
by Agrawal, Swapnil
Hi
Do we have a performance comparison chart between Drools 3.0 and Drools 5.0?
I see we have one between 4.0 amd 5.0 and one between 2.5 and 3.0.
But missing the 3.0 and 5.0 comparison.
We recently moved to 5.0 from 3.0 and see significant drop in performance.
Need to check if the drop is related to our application structure or it is due to the upgrade of drools.
Thanks
Swapnil Agrawal
cell: 201 616 1189
desk: 212 816 7024
16 years, 3 months
- 1
- 1
drools-fusion: rule firing erroneously for the first time in a sliding window
by Badrinath, Shyam
Hi
I am using Drools 5.1.0 M1 within Eclipse. I am trying out a sample
rule, which fires if the minimum cpu is over 80 for 5s using sliding
windows. I see that it works well over a running window of 5s, but for
the first time, it fires even before reaching 5s.
It seems to ignore the fact that 5s hasn't elapsed yet. I am using the
engine in STREAM mode and using a pseudo clock to advance the time
manually.
Is this the expected behavior? Thanks!
sb
Here is the rule:
package org.drools.examples
import org.drools.examples.CpuMetric.Cpu;
import org.drools.examples.CpuMetric.Alarm;
global org.apache.log4j.Logger logger
declare Cpu
@role(event)
@expires(5s)
end
rule "Above Cpu threshold of 80 for 5s"
dialect "java"
when
not Alarm()
$cpuMin : Number(intValue >= 80) from accumulate(
$cpu : Cpu($v : value) over window:time(5s), min($v)
)
then
logger.info("Cpu above 80 for 5 s, raising alarm. min cpu:
"+$cpuMin);
Alarm a = new Alarm();
a.setReason("raised alarm as we hit cpu threshold");
a.setTime(System.currentTimeMillis());
insert(a);
end
Here is the snippet of the class that declares the Cpu and Alarm class
as well inserts events into the rule engine. The other thing I noticed
is the accumulate function seems to ignore the regex in the <src
pattern>. For example, in the rule above, if I give
$cpuMin : Number(intValue >= 80) from accumulate(
$cpu : Cpu($v : value, srcIp =='<val1>' && destIp == '<val2>') over
window:time(5s), min($v)
And insert cpu events, with no matching srcIp and destIp, I shouldn't
see any alarm raised, but I do and right at the beginning.
. . ... (code before this..)
//to use sliding windows, have to run the engine in stream mode
//default is cloud mode..where there are no concept of time and
//event ordering
KnowledgeBaseConfiguration kbaseconfig =
KnowledgeBaseFactory.newKnowledgeBaseConfiguration();
kbaseconfig.setOption(EventProcessingOption.STREAM);
// add the packages to a knowledgebase (deploy the knowledge
packages).
KnowledgeBase kbase =
KnowledgeBaseFactory.newKnowledgeBase(kbaseconfig);
kbase.addKnowledgePackages(pkgs);
KnowledgeSessionConfiguration conf =
KnowledgeBaseFactory.newKnowledgeSessionConfiguration();
conf.setOption(ClockTypeOption.get("pseudo"));
StatefulKnowledgeSession ksession =
kbase.newStatefulKnowledgeSession(conf, null);
//get clock to manually advance and test firing..
SessionPseudoClock clock = ksession.getSessionClock();
logger.info("Pseudo clock current time: "+clock.getCurrentTime());
ksession.setGlobal("logger", logger);
ksession.addEventListener(new DebugAgendaEventListener());
ksession.addEventListener(new DebugWorkingMemoryEventListener());
// setup the audit logging
KnowledgeRuntimeLogger krlogger = KnowledgeRuntimeLoggerFactory
.newFileLogger(ksession, "log/cpu");
BufferedReader bf = new BufferedReader(new
FileReader("/opt/cpumetricdata.txt"));
String s;
long time=0;
int count=0;
long lastime=0;
int delta=0;
//logger.info("Advancing 5s right at the start");
//clock.advanceTime(5000, TimeUnit.MILLISECONDS);
while((s = bf.readLine()) != null)
{
String[] vals = s.split(",");
Cpu cpumetric = new Cpu();
cpumetric.setValue(Integer.parseInt(vals[1]));
//set in ms
//for the first time, initialize time and lastime
//to the value read in from the first line.
time = Long.parseLong(vals[0]);
if(count ==0)
{
lastime = time;
logger.info("Initialized lastime to "+lastime);
}
cpumetric.setTime(time);
cpumetric.setSrcIp("10.155.21.86");
cpumetric.setDestIp("10.6.35.120");
logger.info("Inserted cpu metric "+cpumetric);
logger.info("Count: "+count+" Pseudo clock current time:
"+clock.getCurrentTime());
ksession.insert(cpumetric);
ksession.fireAllRules();
//advance based on the read in time in ms
//do it only from the second insert onwards
delta=(int) (time-lastime);
if(count >=1)
{
clock.advanceTime(delta, TimeUnit.MILLISECONDS);
logger.info("Pseudo clock advanced "+delta+ "ms");
}
count++;
lastime=time;
}
System.out.println("Inserted facts, current time is "+new Date());
krlogger.close();
ksession.dispose();
bf.close();
}
public static class Alarm
{
private String reason;
private long time;
private String type;
/**
* @return the reason
*/
public String getReason()
{
return reason;
}
/**
* @param reason the reason to set
*/
public void setReason(String reason)
{
this.reason = reason;
}
/**
* @return the time
*/
public long getTime()
{
return time;
}
/**
* @return the type
*/
public String getType()
{
return type;
}
/**
* @param type the type to set
*/
public void setType(String type)
{
this.type = type;
}
/**
* @param time the time to set
*/
public void setTime(long time)
{
this.time = time;
}
}
public static class Cpu implements Serializable
{
private long time;
private int value;
private String srcIp;
private String destIp;
/* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString()
{
return "Cpu [time=" + time + ", value=" + value + "]";
}
/**
* @return the time
*/
public long getTime()
{
return time;
}
/**
* @param time the time to set
*/
public void setTime(long time)
{
this.time = time;
}
/**
* @return the srcIp
*/
public String getSrcIp()
{
return srcIp;
}
/**
* @param srcIp the srcIp to set
*/
public void setSrcIp(String srcIp)
{
this.srcIp = srcIp;
}
/**
* @return the destIp
*/
public String getDestIp()
{
return destIp;
}
/**
* @param destIp the destIp to set
*/
public void setDestIp(String destIp)
{
this.destIp = destIp;
}
/**
* @return the value
*/
public int getValue()
{
return value;
}
/**
* @param value the value to set
*/
public void setValue(int value)
{
this.value = value;
}
}
}
Data that drives the insertion:
1358,81
2359,86
3360,88
4361,80
5362,84
6363,80
7364,83
8365,99
9366,97
10367,99
16 years, 3 months
- 2
- 4
Re: [rules-users] questions on guvnor and drools 5.0
by Libor Nenadál
Hi Jean!
Dne 13. dubna 2010 19:41 Jean-Denis Maroie [via Drools - Java Rules Engine]
<ml-node+716101-1775405691-43605(a)n3.nabble.com<ml-node%2B716101-1775405691-43605(a)n3.nabble.com>
> napsal(a):
>
> In the test scenario I want to create a list of objects and apply some
> rules on it. But Im unable to create my list in the test scenario. When I
> have to enter the value of the method "add" of my list I only can type
> integers. I want to enter a variable's name containing an object created
> before.
>
> Did you try the method with equal sign I wrote about in the previous post?
I.e. if your object is named myObject, fill to the edit box =myObject. I
just want to be sure.
BR,
Libor
--
View this message in context: http://n3.nabble.com/questions-on-guvnor-and-drools-5-0-tp58616p716193.html
Sent from the Drools - User mailing list archive at Nabble.com.
16 years, 3 months
- 1
- 0
Flow, Human Task, Group Assignment
by Chris Raschl
Hi,
I've got a question concerning drools flow, human tasks and group
assignments.
I assigned a human task to a group (via the groupId parameter) and can
successfully retrieve it using the TaskServiceSession function:
getTasksAssignedAsPotentialOwner(userId, groupIds, language)
This function implies in my understanding that the knowledge about group
membership is not (yet?) managed within the human task management
component, otherwise there would be no need to pass the groupIds to it.
If a user tries to claim the task now, a PermissionDeniedException is
thown because drools currently has no information about his group
membership.
see TaskServiceSession, line 602:
isAllowed(final User user, final List<OrganizationalEntity> entities)
There is even a comment in there...
"for now just do a contains, I'll figure out group membership later."
Is there a way to work around this issue? I'd like to avoid implementing
my own TaskServiceSession because of the lack of an interface and a
dependency to SubTasksStrategies.
Thanks in advance,
Chris
16 years, 3 months
- 1
- 0
Logging and BIRT
by Amit Kumar
Hi Folks,
I tried simple logging by using this code
KnowledgeRuntimeLogger logger =
KnowledgeRuntimeLoggerFactory.newFileLogger(ksession, "test");
It logs only basic stuff.
How can I log rule runtime, etc.
Trying to generate a report using BIRT as mentioned here
http://downloads.jboss.com/drools/docs/5.0.1.26597.FINAL/drools-flow/html...
Thanks in advance,
Amit
16 years, 3 months
- 2
- 4
Double Handling
by Ade Timi
Hi,
I am new to Drools. I am having a problem comparing 2 double values. I have
a Java class with a double attribute called loanToValue. The loanToValue is
been read from an XML file and the value is 92000.0. Based on this value I
do not expect this rule to be fired, but for some reason it does. And the
print statement returns 92000.0. Does anyone know what I'm doing wrong? My
rule looks as follows:
rule "G2 Equity in Asset"
ruleflow-group "goods"
dialect "mvel"
when
$d : IndividualDecision()
Individual(eval($d.getLoanToValue() < "85"))
then
System.out.println("loanToValue: " + ($d.getLoanToValue()));
end
Thanks,
Ade
Adeyinka Timi | Technical Supprt | Nathean Technologies Ltd
Registered Office 3 Lyncon Court, IDA Science & Technology Park, Snugborough
Road, Blanchardstown, Dublin 15, Ireland
T +353 1 685 3001 | VOIP 076 615 1117 | E adeyinka.timi(a)nathean.com |
<http://www.nathean.com/> <http://www.nathean.com> www.nathean.com
Incorporated in Ireland, No. 339972
The information appearing in this email and any files transmitted with it is
confidential and may not be reproduced, modified, distributed, transmitted,
displayed, published or broadcast without the prior written permission of
Nathean Technologies Ltd. It is intended solely for the use of the
addressee(s). Nathean Technologies Ltd, its directors, officers and
employees do not accept liability for any loss or damage of any nature
howsoever arising pertaining to the use of information appearing in this
email and/or any files transmitted with it. Whilst this email has been
checked for the presence of computer viruses, Nathean Technologies Ltd does
not, except as required by law, represent, warrant and/or guarantee that the
integrity of this communication has been maintained nor that the
communication is free of errors, viruses, interception or interference.
16 years, 3 months
- 4
- 10
Exceptions on Human Task creation
by Robert
Hi,
I try to use the Human Task View within Eclipse (I don't think that is the
problem) creating a Human Task.
(Remark: I tried this with Drools-Version 5.1.0 M1 and 5.1.0 Trunk
(selfbuild). Each time the same problems. I would like to stay on my build
trunk-version, since it works with the BPMN2, which the M1 did not).
Used Jars (relevant for here):
- h2-1.1.119.jar
- hibernate-core-3.3.0.SP1.jar
- persistence-api-1.0.jar
In general, if you need more information, just let me know.
What did I do ?
1. Starting a Mina-Server:
public class TaskManagementServer {
private EntityManagerFactory emf;
private TaskService taskService;
private TaskServiceSession taskSession;
private MinaTaskServer server;
public static void main(String[] args) throws Exception {
new TaskManagementServer().start();
}
private void start() throws Exception {
EntityManagerFactory emf =
Persistence.createEntityManagerFactory("org.drools.task");
taskService = new TaskService(emf,
SystemEventListenerFactory.getSystemEventListener());
taskSession = taskService.createSession();
taskSession.addUser(new User("Admin"));
taskSession.addUser(new User("Tim"));
taskSession.addUser(new User("Romy"));
server = new MinaTaskServer(taskService);
Thread thread = new Thread(server);
thread.start();
Thread.sleep( 500 );
System.out.println("Server started ...");
}
}
Starts-up without any errors.
2. Eclipse Human Task View: Enter Tim -> Refresh -> Empty list (as
expected)
3. Eclipse Human Task View: Enter Tim -> Create -> Dialog shows-up
(Create New Task) -> Enter data (Name: Clean Room ; Potential owner: Tim ;
Subject: Cleaning ; rest I kept empty) -> Hit OK.
4a. The Error appears in the Server console (Server console log, see below)
4b. Humans Task View -> Dialog shows-up (Task View: "Could not connect to
server, refresh first").
5. Eclipse Human Task View: Press Refresh -> Empty list (sure, still
empty because of the error/exceptions).
Thanks for your help, cheers, Rob.
This is the complete console output of the Task-Server:
For the exceptions see a little more down.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/D:/temp/Drools/alllibs/slf4j-jdk14-1.5.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/D:/temp/Drools/alllibs/slf4j-log4j12-1.5.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/D:/temp/Drools/alllibs/slf4j-log4j12-1.5.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/D:/temp/Drools/alllibs/slf4j-simple-1.5.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/D:/Downloads/Drools/drools-5.1.0.M1-bin/lib/slf4j-jdk14-1.5.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
explanation.
10.04.2010 14:34:35 org.hibernate.cfg.annotations.Version <clinit>
INFO: Hibernate Annotations 3.4.0.GA
10.04.2010 14:34:35 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.3.0.SP1
10.04.2010 14:34:35 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
10.04.2010 14:34:35 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : javassist
10.04.2010 14:34:35 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
10.04.2010 14:34:35 org.hibernate.annotations.common.Version <clinit>
INFO: Hibernate Commons Annotations 3.1.0.GA
10.04.2010 14:34:35 org.hibernate.ejb.Version <clinit>
INFO: Hibernate EntityManager 3.4.0.GA
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: TasksAssignedAsBusinessAdministrator => select
new org.drools.task.query.TaskSummary( t.id, names.text, subjects.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t left
join t.taskData.createdBy, I18NText names, I18NText subjects, I18NText
descriptions, OrganizationalEntity businessAdministrator where
businessAdministrator.id = :userId and businessAdministrator in elements (
t.peopleAssignments.businessAdministrators ) and names.language =
:language and names in elements( t.names) and ( subjects.language =
:language and subjects in elements( t.subjects) or t.subjects.size = 0 )
and ( descriptions.language = :language and descriptions in elements(
t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime
is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: TasksAssignedAsExcludedOwner => select new
org.drools.task.query.TaskSummary( t.id, names.text, subjects.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t left
join t.taskData.createdBy, I18NText names, I18NText subjects, I18NText
descriptions, OrganizationalEntity excludedOwners where excludedOwners.id
= :userId and excludedOwners in elements (
t.peopleAssignments.excludedOwners ) and names.language = :language and
names in elements( t.names) and ( subjects.language = :language and
subjects in elements( t.subjects) or t.subjects.size = 0 ) and (
descriptions.language = :language and descriptions in elements(
t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime
is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: TasksAssignedAsPotentialOwner => select new
org.drools.task.query.TaskSummary( t.id, names.text, subject.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t left
join t.taskData.createdBy left join t.taskData.actualOwner left join
t.subjects as subject, I18NText names, I18NText descriptions,
OrganizationalEntity potentialOwners where potentialOwners.id = :userId
and potentialOwners in elements ( t.peopleAssignments.potentialOwners )
and names.language = :language and names in elements( t.names) and (
subject.language = :language or t.subjects.size = 0 ) and (
descriptions.language = :language and descriptions in elements(
t.descriptions) or t.descriptions.size = 0 ) and t.taskData.status in
('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and
t.taskData.expirationTime is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: TasksAssignedAsPotentialOwnerWithGroups =>
select new org.drools.task.query.TaskSummary( t.id, names.text,
subjects.text, descriptions.text, t.taskData.status, t.priority,
t.taskData.skipable, t.taskData.actualOwner, t.taskData.createdBy,
t.taskData.createdOn, t.taskData.activationTime,
t.taskData.expirationTime) from Task t left join t.taskData.createdBy left
join t.taskData.actualOwner, I18NText names, I18NText subjects, I18NText
descriptions, OrganizationalEntity potentialOwners where (
potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and
potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and
names.language = :language and names in elements( t.names) and (
subjects.language = :language and subjects in elements( t.subjects) or
t.subjects.size = 0 ) and ( descriptions.language = :language and
descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and
t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress',
'Suspended') and t.taskData.expirationTime is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: TasksAssignedAsPotentialOwnerByGroup => select
new org.drools.task.query.TaskSummary( t.id, names.text, subjects.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t left
join t.taskData.createdBy left join t.taskData.actualOwner, I18NText
names, I18NText subjects, I18NText descriptions, OrganizationalEntity
potentialOwners where potentialOwners.id = :groupId and potentialOwners in
elements ( t.peopleAssignments.potentialOwners ) and names.language =
:language and names in elements( t.names) and ( subjects.language =
:language and subjects in elements( t.subjects) or t.subjects.size = 0 )
and ( descriptions.language = :language and descriptions in elements(
t.descriptions) or t.descriptions.size = 0 ) and t.taskData.status in
('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and
t.taskData.expirationTime is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: SubTasksAssignedAsPotentialOwner => select new
org.drools.task.query.TaskSummary( t.id, names.text, subjects.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t left
join t.taskData.createdBy left join t.taskData.actualOwner, I18NText
names, I18NText subjects, I18NText descriptions, OrganizationalEntity
potentialOwners where t.taskData.parentId = :parentId and
potentialOwners.id = :userId and potentialOwners in elements (
t.peopleAssignments.potentialOwners ) and names.language = :language and
names in elements( t.names) and ( subjects.language = :language and
subjects in elements( t.subjects) or t.subjects.size = 0 ) and (
descriptions.language = :language and descriptions in elements(
t.descriptions) or t.descriptions.size = 0 ) and t.taskData.status in
('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and
t.taskData.expirationTime is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: GetSubTasksByParentTaskId => select new
org.drools.task.query.TaskSummary( t.id, names.text, subjects.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t,
I18NText names, I18NText subjects, I18NText descriptions where
t.taskData.parentId = :parentId and names.language = :language and names
in elements( t.names) and ( subjects.language = :language and subjects in
elements( t.subjects) or t.subjects.size = 0 ) and ( descriptions.language
= :language and descriptions in elements( t.descriptions) or
t.descriptions.size = 0 ) and t.taskData.status in ('Created', 'Ready',
'Reserved', 'InProgress', 'Suspended') and t.taskData.expirationTime is
null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: TasksAssignedAsRecipient => select new
org.drools.task.query.TaskSummary( t.id, names.text, subjects.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t left
join t.taskData.createdBy, I18NText names, I18NText subjects, I18NText
descriptions, OrganizationalEntity recipients where recipients.id =
:userId and recipients in elements ( t.peopleAssignments.recipients ) and
names.language = :language and names in elements( t.names) and (
subjects.language = :language and subjects in elements( t.subjects) or
t.subjects.size = 0 ) and ( descriptions.language = :language and
descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and
t.taskData.expirationTime is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: TasksAssignedAsTaskInitiator => select new
org.drools.task.query.TaskSummary( t.id, names.text, subjects.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t left
join t.taskData.createdBy, I18NText names, I18NText subjects, I18NText
descriptions, OrganizationalEntity taskInitiator where taskInitiator.id =
:userId and taskInitiator = t.peopleAssignments.taskInitiator and
names.language = :language and names in elements( t.names) and (
subjects.language = :language and subjects in elements( t.subjects) or
t.subjects.size = 0 ) and ( descriptions.language = :language and
descriptions in elements( t.descriptions) or t.descriptions.size = 0 ) and
t.taskData.expirationTime is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: TasksAssignedAsTaskStakeholder => select new
org.drools.task.query.TaskSummary( t.id, names.text, subjects.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t left
join t.taskData.createdBy, I18NText names, I18NText subjects, I18NText
descriptions, OrganizationalEntity taskStakeholder where
taskStakeholder.id = :userId and taskStakeholder in elements (
t.peopleAssignments.taskStakeholders ) and names.language = :language and
names in elements( t.names) and ( subjects.language = :language and
subjects in elements( t.subjects) or t.subjects.size = 0 ) and (
descriptions.language = :language and descriptions in elements(
t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime
is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: TasksOwned => select new
org.drools.task.query.TaskSummary( t.id, names.text, subjects.text,
descriptions.text, t.taskData.status, t.priority, t.taskData.skipable,
t.taskData.actualOwner, t.taskData.createdBy, t.taskData.createdOn,
t.taskData.activationTime, t.taskData.expirationTime) from Task t left
join t.taskData.createdBy, I18NText names, I18NText subjects, I18NText
descriptions where t.taskData.actualOwner.id = :userId and names in
elements( t.names) and names.language = :language and ( subjects.language
= :language and subjects in elements( t.subjects) or t.subjects.size = 0 )
and ( descriptions.language = :language and descriptions in elements(
t.descriptions) or t.descriptions.size = 0 ) and t.taskData.expirationTime
is null
10.04.2010 14:34:36 org.hibernate.cfg.annotations.QueryBinder bindQuery
INFO: Binding Named query: UnescalatedDeadlines => select new
org.drools.task.query.DeadlineSummary( t.id, d.id, d.date) from Task t,
Deadline d where (d in elements( t.deadlines.startDeadlines ) or d in
elements( t.deadlines.endDeadlines ) ) and d.escalated = false order by
d.date
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.Attachment
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.Attachment on table Attachment
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.Content
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.Content on table Content
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class:
org.drools.task.BooleanExpression
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.BooleanExpression on table
BooleanExpression
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.Comment
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.Comment on table Comment
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.Deadline
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.Deadline on table Deadline
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.Escalation
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.Escalation on table Escalation
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class:
org.drools.task.OrganizationalEntity
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.OrganizationalEntity on table
OrganizationalEntity
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.Group
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.I18NText
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.I18NText on table I18NText
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.Notification
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.Notification on table Notification
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class:
org.drools.task.EmailNotification
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class:
org.drools.task.EmailNotificationHeader
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.EmailNotificationHeader on table
EmailNotificationHeader
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.Reassignment
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.Reassignment on table Reassignment
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.Task
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.Task on table Task
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.SubTasksStrategy
10.04.2010 14:34:36 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity org.drools.task.SubTasksStrategy on table
SubTasksStrategy
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class:
org.drools.task.OnParentAbortAllSubTasksEndStrategy
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class:
org.drools.task.OnAllSubTasksEndParentEndStrategy
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: org.drools.task.User
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Task.taskData.comments -> Comment
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Task.taskData.attachments ->
Attachment
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Task.subjects -> I18NText
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Task.subTaskStrategies ->
SubTasksStrategy
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Task.names -> I18NText
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Task.descriptions -> I18NText
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Task.deadlines.startDeadlines ->
Deadline
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Task.deadlines.endDeadlines ->
Deadline
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Reassignment.documentation ->
I18NText
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Notification.subjects -> I18NText
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Notification.names -> I18NText
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Notification.documentation ->
I18NText
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Notification.descriptions ->
I18NText
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Escalation.reassignments ->
Reassignment
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Escalation.notifications ->
Notification
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Escalation.constraints ->
BooleanExpression
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Deadline.escalations ->
Escalation
10.04.2010 14:34:36 org.hibernate.cfg.annotations.CollectionBinder
bindOneToManySecondPass
INFO: Mapping collection: org.drools.task.Deadline.documentation ->
I18NText
10.04.2010 14:34:36 org.hibernate.cfg.AnnotationConfiguration
secondPassCompile
INFO: Hibernate Validator not found: ignoring
10.04.2010 14:34:36 org.hibernate.ejb.Ejb3Configuration configure
WARNUNG: hibernate.connection.autocommit = false break the EJB3
specification
10.04.2010 14:34:36
org.hibernate.cfg.search.HibernateSearchEventListenerRegister
enableHibernateSearch
INFO: Unable to find org.hibernate.search.event.FullTextIndexEventListener
on the classpath. Hibernate Search is not enabled.
10.04.2010 14:34:36
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
10.04.2010 14:34:36
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
10.04.2010 14:34:36
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
10.04.2010 14:34:36
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: org.h2.Driver at URL: jdbc:h2:mem:mydb
10.04.2010 14:34:36
org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=sa, password=****, autocommit=false,
release_mode=auto}
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: H2, version: 1.1.119 (2009-09-26)
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: H2 JDBC Driver, version: 1.1.119 (2009-09-26)
10.04.2010 14:34:37 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.H2Dialect
10.04.2010 14:34:37 org.hibernate.transaction.TransactionFactoryFactory
buildTransactionFactory
INFO: Transaction strategy:
org.hibernate.transaction.JDBCTransactionFactory
10.04.2010 14:34:37
org.hibernate.transaction.TransactionManagerLookupFactory
getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of
read-write or transactional second-level cache is not recommended)
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 3
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory
createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
10.04.2010 14:34:37 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: enabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory createRegionFactory
INFO: Cache region factory :
org.hibernate.cache.impl.NoCachingRegionFactory
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
10.04.2010 14:34:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
10.04.2010 14:34:37 org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
10.04.2010 14:34:37 org.hibernate.impl.SessionFactoryObjectFactory
addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
10.04.2010 14:34:37 org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: Running hbm2ddl schema export
10.04.2010 14:34:37 org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: exporting generated schema to database
10.04.2010 14:34:38 org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: schema export complete
Hibernate: select task0_.id as col_0_0_, deadline1_.id as col_1_0_,
deadline1_.date as col_2_0_ from Task task0_, Deadline deadline1_ where
(deadline1_.id in (select startdeadl2_.id from Deadline startdeadl2_ where
task0_.id=startdeadl2_.Deadlines_StartDeadLine_Id) or deadline1_.id in
(select enddeadlin3_.id from Deadline enddeadlin3_ where
task0_.id=enddeadlin3_.Deadlines_EndDeadLine_Id)) and
deadline1_.escalated=0 order by deadline1_.date
Hibernate: insert into OrganizationalEntity (DTYPE, id) values ('User', ?)
Hibernate: insert into OrganizationalEntity (DTYPE, id) values ('User', ?)
Hibernate: insert into OrganizationalEntity (DTYPE, id) values ('User', ?)
Server started ...
[2010:04:100 14:04:84:debug] Message receieved on server :
QueryTasksAssignedAsPotentialOwner
[2010:04:100 14:04:84:debug] Arguments : [, en-UK]
Hibernate: select task0_.id as col_0_0_, i18ntext4_.text as col_1_0_,
subjects3_.text as col_2_0_, i18ntext5_.text as col_3_0_, task0_.status as
col_4_0_, task0_.priority as col_5_0_, task0_.skipable as col_6_0_,
task0_.actualOwner_id as col_7_0_, task0_.createdBy_id as col_8_0_,
task0_.createdOn as col_9_0_, task0_.activationTime as col_10_0_,
task0_.expirationTime as col_11_0_ from Task task0_ left outer join
OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer
join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left
outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id,
I18NText i18ntext4_, I18NText i18ntext5_, OrganizationalEntity
organizati6_ where organizati6_.id=? and (organizati6_.id in (select
potentialo9_.entity_id from PeopleAssignments_PotentialOwners potentialo9_
where task0_.id=potentialo9_.task_id)) and i18ntext4_.language=? and
(i18ntext4_.id in (select names10_.id from I18NText names10_ where
task0_.id=names10_.Task_Names_Id)) and (subjects3_.language=? or (select
count(subjects11_.Task_Subjects_Id) from I18NText subjects11_ where
task0_.id=subjects11_.Task_Subjects_Id)=0) and (i18ntext5_.language=? and
(i18ntext5_.id in (select descriptio12_.id from I18NText descriptio12_
where task0_.id=descriptio12_.Task_Descriptions_Id)) or (select
count(descriptio13_.Task_Descriptions_Id) from I18NText descriptio13_
where task0_.id=descriptio13_.Task_Descriptions_Id)=0) and (task0_.status
in ('Created' , 'Ready' , 'Reserved' , 'InProgress' , 'Suspended')) and
(task0_.expirationTime is null)
10.04.2010 14:35:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: CREATED
10.04.2010 14:35:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: OPENED
10.04.2010 14:35:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: RECEIVED: HeapBuffer[pos=0 lim=196 cap=2048: 00 00 00 C0 AC ED 00 05
73 72 01 00 1F 6F 72 67...]
10.04.2010 14:35:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=192 cap=256: 00 00 00 BC AC ED 00 05 73
72 01 00 1F 6F 72 67...]
10.04.2010 14:35:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=0 cap=0: empty]
[2010:04:100 14:04:525:debug] Message receieved on server :
QueryTasksAssignedAsPotentialOwner
[2010:04:100 14:04:525:debug] Arguments : [Tim, en-UK]
Hibernate: select task0_.id as col_0_0_, i18ntext4_.text as col_1_0_,
subjects3_.text as col_2_0_, i18ntext5_.text as col_3_0_, task0_.status as
col_4_0_, task0_.priority as col_5_0_, task0_.skipable as col_6_0_,
task0_.actualOwner_id as col_7_0_, task0_.createdBy_id as col_8_0_,
task0_.createdOn as col_9_0_, task0_.activationTime as col_10_0_,
task0_.expirationTime as col_11_0_ from Task task0_ left outer join
OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer
join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left
outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id,
I18NText i18ntext4_, I18NText i18ntext5_, OrganizationalEntity
organizati6_ where organizati6_.id=? and (organizati6_.id in (select
potentialo9_.entity_id from PeopleAssignments_PotentialOwners potentialo9_
where task0_.id=potentialo9_.task_id)) and i18ntext4_.language=? and
(i18ntext4_.id in (select names10_.id from I18NText names10_ where
task0_.id=names10_.Task_Names_Id)) and (subjects3_.language=? or (select
count(subjects11_.Task_Subjects_Id) from I18NText subjects11_ where
task0_.id=subjects11_.Task_Subjects_Id)=0) and (i18ntext5_.language=? and
(i18ntext5_.id in (select descriptio12_.id from I18NText descriptio12_
where task0_.id=descriptio12_.Task_Descriptions_Id)) or (select
count(descriptio13_.Task_Descriptions_Id) from I18NText descriptio13_
where task0_.id=descriptio13_.Task_Descriptions_Id)=0) and (task0_.status
in ('Created' , 'Ready' , 'Reserved' , 'InProgress' , 'Suspended')) and
(task0_.expirationTime is null)
10.04.2010 14:35:41 org.apache.mina.filter.logging.LogLevel$4 log
INFO: RECEIVED: HeapBuffer[pos=0 lim=199 cap=2048: 00 00 00 C3 AC ED 00 05
73 72 01 00 1F 6F 72 67...]
10.04.2010 14:35:41 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=192 cap=256: 00 00 00 BC AC ED 00 05 73
72 01 00 1F 6F 72 67...]
10.04.2010 14:35:41 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=0 cap=0: empty]
[2010:04:100 14:04:559:debug] Server IDLE 1
10.04.2010 14:35:51 org.apache.mina.filter.logging.LogLevel$4 log
INFO: IDLE: both idle
[2010:04:100 14:04:564:debug] Server IDLE 2
10.04.2010 14:36:01 org.apache.mina.filter.logging.LogLevel$4 log
INFO: IDLE: both idle
10.04.2010 14:36:11 org.apache.mina.filter.logging.LogLevel$4 log
INFO: IDLE: both idle
[2010:04:100 14:04:568:debug] Server IDLE 3
10.04.2010 14:36:13 org.apache.mina.filter.logging.LogLevel$4 log
INFO: RECEIVED: HeapBuffer[pos=0 lim=379 cap=1024: 00 00 01 77 AC ED 00 05
73 72 01 00 1F 6F 72 67...]
[2010:04:100 14:04:291:debug] Message receieved on server : AddTaskRequest
[2010:04:100 14:04:301:debug] Arguments : [org.drools.task.Task@6668ee36,
null]
Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?
Hibernate: insert into Task (id, allowedToDelegate, taskInitiator_id,
priority, activationTime, actualOwner_id, createdBy_id, createdOn,
documentAccessType, documentContentId, documentType, expirationTime,
faultAccessType, faultContentId, faultName, faultType, outputAccessType,
outputContentId, outputType, parentId, previousStatus, skipable, status,
workItemId) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into I18NText (id, language, text) values (null, ?, ?)
Hibernate: insert into I18NText (id, language, text) values (null, ?, ?)
Hibernate: insert into I18NText (id, language, text) values (null, ?, ?)
Hibernate: update I18NText set Task_Descriptions_Id=? where id=?
Hibernate: update I18NText set Task_Names_Id=? where id=?
Hibernate: insert into PeopleAssignments_BusinessAdministrators (task_id,
entity_id) values (?, ?)
10.04.2010 14:36:13 org.hibernate.util.JDBCExceptionReporter logExceptions
WARNUNG: SQL Error: 23002, SQLState: 23002
10.04.2010 14:36:13 org.hibernate.util.JDBCExceptionReporter logExceptions
SCHWERWIEGEND: Referentielle Integrität verletzt: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)
Referential integrity constraint violation: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID); SQL statement:
insert into PeopleAssignments_BusinessAdministrators (task_id, entity_id)
values (?, ?) [23002-119]
10.04.2010 14:36:13 org.hibernate.util.JDBCExceptionReporter logExceptions
WARNUNG: SQL Error: 23002, SQLState: 23002
10.04.2010 14:36:13 org.hibernate.util.JDBCExceptionReporter logExceptions
SCHWERWIEGEND: Referentielle Integrität verletzt: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)
Referential integrity constraint violation: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID); SQL statement:
insert into PeopleAssignments_BusinessAdministrators (task_id, entity_id)
values (?, ?) [23002-119]
[2010:04:100 14:04:471:exception] Error while commiting the transaction
javax.persistence.RollbackException: Error while commiting the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
at
org.drools.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:685)
at
org.drools.task.service.TaskServiceSession.addTask(TaskServiceSession.java:118)
at
org.drools.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:88)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:752)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:379)
at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:173)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
at
org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:95)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$HeadFilter.messageReceived(DefaultIoFilterChain.java:616)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:408)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:578)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:540)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:532)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:58)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor$Worker.run(AbstractPollingIoProcessor.java:857)
at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not
execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at
org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1141)
at
org.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.java:58)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:171)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
... 28 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referentielle Integrität
verletzt: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)
Referential integrity constraint violation: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID); SQL statement:
insert into PeopleAssignments_BusinessAdministrators (task_id, entity_id)
values (?, ?) [23002-119]
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1090)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 42 more
10.04.2010 14:36:13 org.hibernate.event.def.AbstractFlushingEventListener
performExecutions
SCHWERWIEGEND: Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute
JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at
org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1141)
at
org.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.java:58)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:171)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
at
org.drools.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:685)
at
org.drools.task.service.TaskServiceSession.addTask(TaskServiceSession.java:118)
at
org.drools.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:88)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:752)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:379)
at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:173)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
at
org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:95)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$HeadFilter.messageReceived(DefaultIoFilterChain.java:616)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:408)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:578)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:540)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:532)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:58)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor$Worker.run(AbstractPollingIoProcessor.java:857)
at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referentielle Integrität
verletzt: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)
Referential integrity constraint violation: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID); SQL statement:
insert into PeopleAssignments_BusinessAdministrators (task_id, entity_id)
values (?, ?) [23002-119]
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1090)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 42 more
javax.persistence.RollbackException: Error while commiting the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
at
org.drools.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:685)
at
org.drools.task.service.TaskServiceSession.addTask(TaskServiceSession.java:118)
at
org.drools.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:88)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:752)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
at
org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:379)
at
org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:173)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
at
org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:95)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:49)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:832)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain$HeadFilter.messageReceived(DefaultIoFilterChain.java:616)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:414)
at
org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:408)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:578)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:540)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:532)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:58)
at
org.apache.mina.core.polling.AbstractPollingIoProcessor$Worker.run(AbstractPollingIoProcessor.java:857)
at
org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not
execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at
org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1141)
at
org.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.java:58)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:171)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
... 28 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Referentielle Integrität
verletzt: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)
Referential integrity constraint violation: FK3D56AB6EB009A012:
PUBLIC.PEOPLEASSIGNMENTS_BUSINESSADMINISTRATORS FOREIGN KEY(ENTITY_ID)
REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID); SQL statement:
insert into PeopleAssignments_BusinessAdministrators (task_id, entity_id)
values (?, ?) [23002-119]
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1090)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 42 more
10.04.2010 14:36:13 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=8706 cap=16384: 00 00 21 FE AC ED 00 05
73 72 01 00 1F 6F 72 67...]
10.04.2010 14:36:13 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=0 cap=0: empty]
10.04.2010 14:36:18 org.apache.mina.filter.logging.LogLevel$4 log
INFO: RECEIVED: HeapBuffer[pos=0 lim=199 cap=1024: 00 00 00 C3 AC ED 00 05
73 72 01 00 1F 6F 72 67...]
10.04.2010 14:36:18 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=192 cap=256: 00 00 00 BC AC ED 00 05 73
72 01 00 1F 6F 72 67...]
10.04.2010 14:36:18 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=0 cap=0: empty]
[2010:04:100 14:04:308:debug] Message receieved on server :
QueryTasksAssignedAsPotentialOwner
[2010:04:100 14:04:308:debug] Arguments : [Tim, en-UK]
Hibernate: select task0_.id as col_0_0_, i18ntext4_.text as col_1_0_,
subjects3_.text as col_2_0_, i18ntext5_.text as col_3_0_, task0_.status as
col_4_0_, task0_.priority as col_5_0_, task0_.skipable as col_6_0_,
task0_.actualOwner_id as col_7_0_, task0_.createdBy_id as col_8_0_,
task0_.createdOn as col_9_0_, task0_.activationTime as col_10_0_,
task0_.expirationTime as col_11_0_ from Task task0_ left outer join
OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer
join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left
outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id,
I18NText i18ntext4_, I18NText i18ntext5_, OrganizationalEntity
organizati6_ where organizati6_.id=? and (organizati6_.id in (select
potentialo9_.entity_id from PeopleAssignments_PotentialOwners potentialo9_
where task0_.id=potentialo9_.task_id)) and i18ntext4_.language=? and
(i18ntext4_.id in (select names10_.id from I18NText names10_ where
task0_.id=names10_.Task_Names_Id)) and (subjects3_.language=? or (select
count(subjects11_.Task_Subjects_Id) from I18NText subjects11_ where
task0_.id=subjects11_.Task_Subjects_Id)=0) and (i18ntext5_.language=? and
(i18ntext5_.id in (select descriptio12_.id from I18NText descriptio12_
where task0_.id=descriptio12_.Task_Descriptions_Id)) or (select
count(descriptio13_.Task_Descriptions_Id) from I18NText descriptio13_
where task0_.id=descriptio13_.Task_Descriptions_Id)=0) and (task0_.status
in ('Created' , 'Ready' , 'Reserved' , 'InProgress' , 'Suspended')) and
(task0_.expirationTime is null)
10.04.2010 14:36:28 org.apache.mina.filter.logging.LogLevel$4 log
INFO: IDLE: both idle
[2010:04:100 14:04:342:debug] Server IDLE 1
10.04.2010 14:36:32 org.apache.mina.filter.logging.LogLevel$4 log
INFO: CLOSED
10.04.2010 14:36:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: CREATED
10.04.2010 14:36:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: OPENED
10.04.2010 14:36:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: RECEIVED: HeapBuffer[pos=0 lim=199 cap=2048: 00 00 00 C3 AC ED 00 05
73 72 01 00 1F 6F 72 67...]
10.04.2010 14:36:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=192 cap=256: 00 00 00 BC AC ED 00 05 73
72 01 00 1F 6F 72 67...]
10.04.2010 14:36:34 org.apache.mina.filter.logging.LogLevel$4 log
INFO: SENT: HeapBuffer[pos=0 lim=0 cap=0: empty]
[2010:04:100 14:04:371:debug] Message receieved on server :
QueryTasksAssignedAsPotentialOwner
[2010:04:100 14:04:371:debug] Arguments : [Tim, en-UK]
Hibernate: select task0_.id as col_0_0_, i18ntext4_.text as col_1_0_,
subjects3_.text as col_2_0_, i18ntext5_.text as col_3_0_, task0_.status as
col_4_0_, task0_.priority as col_5_0_, task0_.skipable as col_6_0_,
task0_.actualOwner_id as col_7_0_, task0_.createdBy_id as col_8_0_,
task0_.createdOn as col_9_0_, task0_.activationTime as col_10_0_,
task0_.expirationTime as col_11_0_ from Task task0_ left outer join
OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer
join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left
outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id,
I18NText i18ntext4_, I18NText i18ntext5_, OrganizationalEntity
organizati6_ where organizati6_.id=? and (organizati6_.id in (select
potentialo9_.entity_id from PeopleAssignments_PotentialOwners potentialo9_
where task0_.id=potentialo9_.task_id)) and i18ntext4_.language=? and
(i18ntext4_.id in (select names10_.id from I18NText names10_ where
task0_.id=names10_.Task_Names_Id)) and (subjects3_.language=? or (select
count(subjects11_.Task_Subjects_Id) from I18NText subjects11_ where
task0_.id=subjects11_.Task_Subjects_Id)=0) and (i18ntext5_.language=? and
(i18ntext5_.id in (select descriptio12_.id from I18NText descriptio12_
where task0_.id=descriptio12_.Task_Descriptions_Id)) or (select
count(descriptio13_.Task_Descriptions_Id) from I18NText descriptio13_
where task0_.id=descriptio13_.Task_Descriptions_Id)=0) and (task0_.status
in ('Created' , 'Ready' , 'Reserved' , 'InProgress' , 'Suspended')) and
(task0_.expirationTime is null)
10.04.2010 14:36:45 org.apache.mina.filter.logging.LogLevel$4 log
INFO: IDLE: both idle
[2010:04:100 14:04:397:debug] Server IDLE 1
10.04.2010 14:36:55 org.apache.mina.filter.logging.LogLevel$4 log
INFO: IDLE: both idle
[2010:04:100 14:04:401:debug] Server IDLE 2
--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/
16 years, 3 months
- 3
- 2
DROOLS FLOW: Accessing the Map parameter object in a Java constraint evaluation function
by jeanjvr
I cannot find an example of this in the documentation and a search on the
mailing list was fruitless.
Right now my test process works fine - the constraints in Split Nodes are
set "always true" with different priorities.
I need to access the variables inside the Map parameter sent into the
process when it is started by using a Java evaluation function in a Split
Node:
_processinstance = _ksession.startProcess("flow0", _parameters);
I just don't know how to reference that Map parameter in the Java code in a
Split node.
Thanks for any advice.
--
View this message in context: http://n3.nabble.com/DROOLS-FLOW-Accessing-the-Map-parameter-object-in-a-...
Sent from the Drools - User mailing list archive at Nabble.com.
16 years, 3 months
- 2
- 1
Resuming the Flow: SESSION_ID, PROCESS_INSTANCE_ID, WORKITEM_ID
by tolitius
Hi Flow Crew,
This is about reloading the session and resuming the flow.
Let's say the flow reached one of its wait states, and was persisted.
Two days later an "assigned actor" does his/her duties, and the flow can
be resumed.
At this point, we need to call something, let's call it a
WorkflowService, that would have a resumeFlow( someBusinessId ) method that
will be called.
Here is where the question starts...
I understand there are three pieces in this puzzle: SESSION_ID,
PROCESS_INSTANCE_ID and WORKITEM_ID
I also understand that in order to resume the flow, I need to get a hold
of that certain work item that is ready to be completed, and let the flow
know it is completed.
But at the point, where I should resume the flow, I have no reference to
neither SESSION_ID, PROCESS_INSTANCE_ID or WORKFLOW_ID.
1. How are these three related to each other?
2. How do I find these three associated IDs?
2. Which one(s) do I need to resume the flow?
3. If I (somehow) get the reference to SESSION and PROCESS_INSTANCE
ids, how do I know which work item is ready to be completed?
Thank you,
/Anatoly
--
View this message in context: http://n3.nabble.com/Resuming-the-Flow-SESSION-ID-PROCESS-INSTANCE-ID-WOR...
Sent from the Drools - User mailing list archive at Nabble.com.
16 years, 3 months
- 7
- 48