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