Error related to hibernate.queries.hbm.xml,Issue with deploy

[aryavishrut]

Hi,

While migrating from 3.0 to 3.1, I'm trying to deploy a Procesdefinition.xml, This XML is valid against the 3.1 Schema, It gives me an error saying :

org.hibernate.HibernateException: Errors in named queries: SchedulerSession.deleteTimersForProcessInstance, SchedulerSession.suspendTimersForToken, MessagingSession.suspendMessagesForToken, SchedulerSession.resumeTimersForToken, MessagingSession.resumeMessagesForToken
at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:338)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1154)
at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:90)
at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:74)
at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:78)
at org.jbpm.persistence.db.DbPersistenceService.getGraphSession(DbPersistenceService.java:216)
at org.jbpm.JbpmContext.getGraphSession(JbpmContext.java:427)
at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:166)
at gov.cdc.pems.jbpm.process.ScanImportMacroProcess.storeProcessDefinition(ScanImportMacroProcess.java:39)
at gov.cdc.pems.jbpm.process.ScanImportMacroProcess.main(ScanImportMacroProcess.java:26)


The code which I use is :

JbpmContext jbpmContext = jbpmConfig.createJbpmContext();
ProcessDefinition processDefinition = ProcessDefinition.parseXmlResource("ProcessDefinition.xml");
jbpmContext.deployProcessDefinition(processDefinition);

I have created the new SQL DB, and I'm using same jar files(for JBOSS and Hibernate, which come with the starter kit )

Can anyone help me resolve this?

Thanks
Vishrut

[lucmedina]

Hi Vishrut,

I'm having the same problem. Have you solved it?

Luciano

[lucmedina]

Ok, I found it: just needed to upgrade hibernate3.jar from the 3.0.5 to the 3.1 version. Now everything works fine.
It's there at the jBPM user guide, chapter 5, section 5.3:

jBPM is distributed with hibernate 3.1 final. But it can also work with 3.0.x. In that case, you might have to update a few hibernate queries in the hibernate.queries.hbm.xml configuration file.

[aryavishrut]

Hi Luciano,

Thanks for the solution.I didn't try it yet.Will do that today.

Thanks so much again,for the reply.

Vishrut