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

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&...]