2 Replies Latest reply on Aug 30, 2012 12:04 AM by Deepak Singhvi

    jBPM 5: where are the db-tables-scripts ?

    Andy R. Newbie

      Hello,

       

      In an older posting I read the following:

       

      "but in jBPM5 with Oracle, there are only 4 tables: EVENTTYPES, PROCESSINSTANCEINFO,SESSIONINFO, WORKITEMINFO"

       

      Ok, but where are the scripts for creating these tables ? I did not find them in the jBPM 5-package.

        • 1. Re: jBPM 5: where are the db-tables-scripts ?
          Janina Faggiano Newbie

          Hi Andy,

           

          There are no scripts for the database.

           

          The tables in the database are generated with JPA Entities.
          For example entities SessionInfo, WorkItemInfo, ProcessInstanceInfo are classes with @ Entity annotation and the tables are created when you deploy jpbm-console-server.

          • 2. Re: jBPM 5: where are the db-tables-scripts ?
            Deepak Singhvi Newbie

            HI Janina,

             

              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)

             

            Could you plz suggestion something on this? 

             

            Deepak