Rajan Bansal [http://community.jboss.org/people/rajan01] created the discussion
"Log tables not persisted" To view the discussion, visit: http://community.jboss.org/message/632660#632660 -------------------------------------------------------------- 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 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 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> an*d 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 http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd 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 http://java.sun.com/xml/ns/persistence/orm_1_0.xsd http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"; xmlns:orm=" http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm"; xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance http://www.w3.org/2001/XMLSchema-instance"; xmlns=" http://java.sun.com/xml/ns/persistence 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... -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/632660#632660] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
