vikas k [https://community.jboss.org/people/vkn...] created the discussion "Getting error on retriving personal task for human task workflow with jbpm 5.3 and oracle 11g r2 database." To view the discussion, visit: https://community.jboss.org/message/793702#793702 -------------------------------------------------------------- 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> -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/793702#793702] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]