Deepak Singhvi [
https://community.jboss.org/people/deepak.singhvi] created the discussion
"problems in jbpm5 with db2 integration"
To view the discussion, visit:
https://community.jboss.org/message/756887#756887
--------------------------------------------------------------
*What i am doing:*
Trying to use DB2 with jbpm5 (5.3)
*Problems:*
a. Some tables are not created ---> (mentioned below).
b. Exception when running the sample program (sample.bpmn from evaluation
project)--->(mentioned below)
My war got deployed ( jbpm-gwt-console-server.war including other wars like
designer.war, drools-guvnor.war,jbpm-form-builder.war,
jbpm-gwt-console.war,jbpm-human-task-war.war) but i do not see
ProcessInstanceInfo, WorkItemInfo, SessionInfo, etc tables in db.
Following are the tables which are present in jbpm5 database
ATTACHMENT,BOOLEANEXPRESSION,DEADLINE,DELEGATION_DELEGATES,EMAIL_HEADER,ESCALATION,I18NTEXT,NOTIFICATION,
NOTIFICATION_BAS,NOTIFICATION_EMAIL_HEADER,
NOTIFICATION_RECIPIENTS,ORGANIZATIONALENTITY,PEOPLEASSIGNMENTS_BAS,
PEOPLEASSIGNMENTS_EXCLOWNERS,PEOPLEASSIGNMENTS_POTOWNERS,PEOPLEASSIGNMENTS_RECIPIENTS,PEOPLEASSIGNMENTS_STAKEHOLDERS,
REASSIGNMENT,REASSIGNMENT_POTENTIALOWNERS,SUBTASKSSTRATEGY,TASK,TASK_COMMENT
These are the table which are available in
Q.1 When does processInstaceInfo, etc table gets created?
Q.2 I get the error when i start sample program.
*Error on console ( ProcessTest.java)*
0 30/08 09:30:02,395[main] ERROR
workitem.wsht.GenericHTWorkItemHandler.executeWorkItem - Thu Aug 30 09:30:02 GMT+05:30
2012: Error when creating task on task server for work item id 1. Error reported by task
server: Command AddTaskRequest faild due to Operation failed. Please contact task server
administrator.
java.lang.RuntimeException: +Command AddTaskRequest faild due to Operation failed. Please
contact task server administrator.+
at
org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:662)
at
org.jbpm.task.service.hornetq.HornetQTaskServerHandler.messageReceived(HornetQTaskServerHandler.java:44)
at
org.jbpm.task.service.hornetq.BaseHornetQTaskServer.run(BaseHornetQTaskServer.java:85)
at java.lang.Thread.run(Thread.java:619)
Process started ...
*Error in server.log of jboss7*
09:30:02,379 ERROR [stderr] (Thread-16) java.lang.RuntimeException: Operation failed
09:30:02,379 ERROR [stderr] (Thread-16) at
org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:994)
09:30:02,379 ERROR [stderr] (Thread-16) at
org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:186)
09:30:02,379 ERROR [stderr] (Thread-16) at
org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:144)
09:30:02,379 ERROR [stderr] (Thread-16) at
org.jbpm.task.service.hornetq.HornetQTaskServerHandler.messageReceived(HornetQTaskServerHandler.java:44)
09:30:02,379 ERROR [stderr] (Thread-16) at
org.jbpm.task.service.hornetq.BaseHornetQTaskServer.run(BaseHornetQTaskServer.java:85)
09:30:02,379 ERROR [stderr] (Thread-16) at
java.lang.Thread.run(Thread.java:619)
09:30:02,379 ERROR [stderr] (Thread-16) Caused by:
javax.persistence.PersistenceException: org.hibernate.HibernateException: The database
returned no natively generated identity value
09:30:02,379 ERROR [stderr] (Thread-16) at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
Deepak
:)
--------------------------------------------------------------
Reply to this message by going to Community
[
https://community.jboss.org/message/756887#756887]
Start a new discussion in jBPM at Community
[
https://community.jboss.org/choose-container!input.jspa?contentType=1&...]