4 Replies Latest reply on Aug 12, 2009 11:55 AM by kukeltje

Problem with Errors in named queries when deploying jbpm wit

gerry78 Aug 2, 2009 1:59 PM

Hi All,

I am trying to use jbpm 3.3.1 with oracle 10g and weblogic 10.3. I get the following exception from hibernate when i deploy the application:

org.hibernate.HibernateException: Errors in named queries: GraphSession.deleteJobsForProcessInstance, JobSession.deleteTimersForProcessInstance, GraphSession.AllProcessNames, JobSession.suspendJobs, JobSession.deleteExecuteNodeJobsForProcessInstance, GraphSession.deleteTaskInstancesById, JobSession.deleteTimersByName, JobSession.resumeJobs

I tried to chenge the server to a tomcat server or the database to mysql and the same problem exists. I saw in some post that using the latest version of hibernate will solve the problem but this haven't done the trick.
The problem exists in the

org/jbpm/db/hibernate.queries.hbm.xml

but i don't know how to change the queries there.

Is anyone that experienced a simular problem and solve it that can help?

Thanks a lot.

1. Re: Problem with Errors in named queries when deploying jbpm

kukeltje Aug 3, 2009 4:54 AM (in response to gerry78)

I don't think you should change the queries. Changing to the correct hibernate version is the most likely thing
Actions
2. Re: Problem with Errors in named queries when deploying jbpm

gerry78 Aug 3, 2009 6:59 AM (in response to gerry78)
Thank for the reply, I tried various versions and the problem was the same.

I actually found the sollution: Because of weblogic we had to use the
<property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>

After removing this line jbpm work prefectly.
Actions
3. Re: Problem with Errors in named queries when deploying jbpm

kukeltje Aug 3, 2009 9:12 AM (in response to gerry78)

STILL? This was an issue LLLLLOOOOOONNNNNGGGGG ago... (in 8.x) wow... still because of antlr or?
Actions
4. Re: Problem with Errors in named queries when deploying jbpm

kukeltje Aug 12, 2009 11:55 AM (in response to gerry78)

thanks for reporting back
Actions

Go to original post