vikas k
2013-01-23 08:48:45 UTC
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&containerType=14&container=2034]
"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&containerType=14&container=2034]