[rules-users] Exceptions on Human Task creation
Kris Verlaenen
kris.verlaenen at cs.kuleuven.be
Mon Apr 12 12:17:20 EDT 2010
Robert,
The task client in Eclipse automatically assigns user "Administrator" as the
business administrator of the tasks you create, so you should atleast have
this user defined (you're using "Admin" instead). That should fix the
referencial integrity constraint violation.
Kris
----- Original Message -----
From: "Robert" <robert.weissmann at web.de>
To: <rules-users at lists.jboss.org>
Sent: Saturday, April 10, 2010 3:20 PM
Subject: [rules-users] Exceptions on Human Task creation
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 at 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/
_______________________________________________
rules-users mailing list
rules-users at lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm
More information about the rules-users
mailing list