0 Replies Latest reply on Jan 23, 2013 3:48 AM by vikas k

    Getting error on retriving personal task for human task workflow with jbpm 5.3 and oracle 11g r2 database.

    vikas k Newbie

      Hi,

      I am trying to integrate JBPM 5.3 with oracle 11 g r2.I am getting schema created properly on the database with below tables.
      I have created a human task sample workflow with web designer and deployed from there.I am able to start the flow but then when I login with the owner of humantask and try to retrive the personal task,I am getting errors.

      I have attached server log file and error snapshot.

       

      Where as I am able to run Evalution process successfully for jbpm 5.3 with oracle as database.

       

      Kindly direct me on this problem for solution.

       

       


      Tables

      ATTACHMENT
      BOOLEANEXPRESSION
      CONTACTS
      CONTENT
      DEADLINE
      DELEGATION_DELEGATES
      EMAIL_HEADER
      ESCALATION
      EVENTTYPES
      I18NTEXT
      NODEINSTANCELOG
      NOTIFICATION
      NOTIFICATION_BAS
      NOTIFICATION_EMAIL_HEADER
      NOTIFICATION_RECIPIENTS
      ORGANIZATIONALENTITY
      PEOPLEASSIGNMENTS_BAS
      PEOPLEASSIGNMENTS_EXCLOWNERS
      PEOPLEASSIGNMENTS_POTOWNERS
      PEOPLEASSIGNMENTS_RECIPIENTS
      PEOPLEASSIGNMENTS_STAKEHOLDERS
      PROCESSINSTANCEINFO
      PROCESSINSTANCELOG
      REASSIGNMENT
      REASSIGNMENT_POTENTIALOWNERS
      ROLES
      SESSIONINFO
      SUBTASKSSTRATEGY
      TASK
      TASK_COMMENT
      VARIABLEINSTANCELOG
      WORKITEMINFO


      Modification done for h2 database change to oracle 11 g r2

      1. Modified installer_home/db/persistence.xml


      <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>
          
      2.Modified installer_home/db/driver_jar_module.xml


      <module xmlns="urn:jboss:module:1.0" name="com.oracle.ojdbc6">
         <resources>
           <resource-root path="ojdbc6.jar"/>
         </resources>
        
        
      3. Modified  installer_home\task-service\resources\META-INF\persistence.xml
         <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>
            <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver"/>
            <property name="hibernate.connection.url" value="jdbc:oracle:thin:@IP:1521:SID" />
            <property name="hibernate.connection.username" value="USER"/>
            <property name="hibernate.connection.password" value="PASSWORD"/>

      4.Modified installer_home\task-service\resources\war\persistence.xml

      <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>

      5. Modified installer_home\build.xml

        <property name="db.driver.module.prefix" value="com/oracle/ojdbc6"/>
       
       
        <property name="db.driver.jar.name" value="ojdbc6.jar" />
       
       
        6. Modified installer_home\standalone.xml
       
       
         <datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
                          <connection-url>jdbc:oracle:thin:@IP:1521:SID</connection-url>
                          <driver>oracle</driver>
                          <pool>
                              <min-pool-size>1</min-pool-size>
                              <max-pool-size>4</max-pool-size>
                              <prefill>false</prefill>
                              <use-strict-min>false</use-strict-min>
                              <flush-strategy>FailingConnectionOnly</flush-strategy>
                          </pool>
                          <security>
                             <user-name>USER</user-name>
                             <password>PASSWORD</password>
                          </security>
                          <validation>
                             <check-valid-connection-sql>SELECT 1 from dual</check-valid-connection-sql>
                             <validate-on-match>false</validate-on-match>
                             <background-validation>false</background-validation>
                          </validation>
                      </datasource>
                      <drivers>
                          <driver name="oracle" module="com.oracle.ojdbc6">
                              <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
                              <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
                          </driver>
          </drivers>
                  </datasources>