JBoss Community

Actually I successfully persisted the PROCESSINSTANCEINFO, WORKITEMINFO, SESSIONINFO, TASK in Oracle 10g by running jBPM5.1 in JBosss

My issue is the tables:- PROCESSINSTANCELOG, NODEINSTANCELOG, VARIABLEINSTANCELOG are not persisted or we can say no data is showing in these tables:

Below are my "jbpm-bam-5.1.0.Final.jar" files:

AuditLoghbm.xml

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC

        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

    <class name="org.jbpm.process.audit.ProcessInstanceLog" >

        <id name="id">

            <generator class="native"/>

        </id>

        <property name="processInstanceId"/>

        <property name="processId"/>

        <property name="start" type="timestamp" column="START_DATE"/>

        <property name="end" type="timestamp" column="END_DATE"/>

    </class>

    <class name="org.jbpm.process.audit.NodeInstanceLog" >

        <id name="id">

            <generator class="native"/>

        </id>

        <property name="type"/>

        <property name="nodeInstanceId"/>

        <property name="nodeId"/>

        <property name="processInstanceId"/>

        <property name="processId"/>

        <property name="date" type="timestamp" column="LOG_DATE"/>

    </class>

</hibernate-mapping>

hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>

<!DOCTYPE hibernate-configuration PUBLIC

        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"

        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->

        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>

        <property name="connection.url">jdbc:oracle:thin:@172.25.8.251:1521:lupin</property>

        <!--property name="connection.url">jdbc:h2:file:/NotBackedUp/data/mydb</property-->

        <property name="connection.username">jbpm5</property>

        <property name="connection.password">lupin</property>

        <!-- JDBC connection pool (use the built-in) -->

        <property name="connection.pool_size">5</property>

        <!-- SQL dialect -->

        <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>

        <!-- Enable Hibernate's automatic session context management -->

        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->

        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->

        <property name="show_sql">true</property>

        <!-- Drop and re-create the database schema on startup -->

        <property name="hbm2ddl.auto">validate</property>

        <mapping resource="AuditLog.hbm.xml"/>

    </session-factory>

</hibernate-configuration>

and my Persistence.xml present in jbpm-persistence-jpa.jar is

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<persistence version="1.0"

             xsi:schemaLocation="http://java.sun.com/xml/ns/persistence

                                 http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd

                                 http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"

             xmlns:orm="http://java.sun.com/xml/ns/persistence/orm"

             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

             xmlns="http://java.sun.com/xml/ns/persistence">

<persistence-unit name="org.jbpm.persistence.jpa" transaction-type="JTA">

    <provider>org.hibernate.ejb.HibernatePersistence</provider>

<jta-data-source>java:/testDS1</jta-data-source>

        <class>org.drools.persistence.info.SessionInfo</class>

        <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>

        <class>org.jbpm.persistence.processinstance.ProcessInstanceEventInfo</class>

        <class>org.drools.persistence.info.WorkItemInfo</class>

        <class>org.jbpm.process.audit.ProcessInstanceLog</class>

        <class>org.jbpm.process.audit.NodeInstanceLog</class>

        <class>org.jbpm.process.audit.VariableInstanceLog</class> 

        <class>org.jbpm.task.Task</class>

      <class>org.jbpm.task.Comment</class>

      <class>org.jbpm.task.Attachment</class>

      <class>org.jbpm.task.I18NText</class>

      <class>org.jbpm.task.SubTasksStrategy</class>

      <class>org.jbpm.task.Deadline</class>

      <class>org.jbpm.task.Escalation</class>

      <class>org.jbpm.task.Reassignment</class>

      <class>org.jbpm.task.Notification</class>

      <class>org.jbpm.task.BooleanExpression</class>

      <class>org.jbpm.task.User</class>

      <class>org.jbpm.task.PeopleAssignments</class>

   <properties>

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

      <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver"/>

      <property name="hibernate.max_fetch_depth" value="3"/>

      <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup"/>

      <property name="hibernate.hbm2ddl.auto" value="validate" />

      <property name="hibernate.show_sql" value="true" />

    </properties>

  </persistence-unit>

</persistence>

Give your suggestions please...