[jboss-user] [jBPM] - Re: jbpm5 process instance persistence

[a_nat]

a_nat [http://community.jboss.org/people/a_nat] created the discussion

"Re: jbpm5 process instance persistence"

To view the discussion, visit: http://community.jboss.org/message/608419#608419

--------------------------------------------------------------
Hi,

The table processInstancelog, doesn't get truncated after server restart, but i get the follwoing error during server restart...

+2011-06-02 21:48:34,699 INFO  [org.hibernate.tool.hbm2ddl.SchemaValidator] (main) Running schema validator+
+2011-06-02 21:48:34,700 INFO  [org.hibernate.tool.hbm2ddl.SchemaValidator] (main) fetching database metadata+
+2011-06-02 21:48:34,759 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) table found: jbpm.eventtypes+
+2011-06-02 21:48:34,760 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) columns: [element, instanceid]+
+2011-06-02 21:48:34,786 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) table found: jbpm.nodeinstancelog+
+2011-06-02 21:48:34,787 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) columns: [id, log_date, nodeinstanceid, type, processid, processinstanceid, nodeid]+
+2011-06-02 21:48:34,798 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=persistence.unit:unitName=#org.jbpm.persistence.jpa state=Create+
+javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory+
+...+
+...+
+...+
+Caused by: org.hibernate.HibernateException: Missing column: nodeName in jbpm.nodeinstancelog+
 +at org.hibernate.mapping.Table.validateColumns(Table.java:277)+
 +at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1116)+
 +at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)+
 +at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:349)+
 +at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)+
 +at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)+
 +at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)+
 +... 61 more+
++ 
If i add the column manually to the table, it truncates the values in all the tables mentioned in the peristence.xml.
If I don't add the column, iam uanble to view the processOverview / execution history pages. It thows the aforementioned error.

I'm using jbpm 5.1.0 against mysql 5.5.8 (using ApacheFriends XAMPP (Basispaket) version 1.7.4)

All of my persistence.xml is configured like this --- <property name="hibernate.hbm2ddl.auto" value="validate" />

Am i missing anything / do you smell anything wrong?

Thanks & Regards,
Aparna
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/608419#608419]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110602/9368048d/attachment.html