JBoss Community

Re: jbpm5 process instance persistence

created by a_nat in jBPM - View the full discussion

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

Start a new discussion in jBPM at Community