Error parsing queries with jBPM 3.1
polarbaerhh Feb 15, 2006 6:04 AMHi,
I recently changed from jBPM 3.0.2 to jBPM 3.1. When hibernate configures its SessionFactory, the following errors occur:
2006-02-15 11:57:01,239 [main] ERROR org.hibernate.hql.PARSER (35) - *** ERROR: line 3:43: expecting "set", found 't'
2006-02-15 11:57:04,036 [main] ERROR org.hibernate.hql.PARSER (35) - *** ERROR: line 3:43: expecting "set", found 't'
2006-02-15 11:57:04,192 [main] ERROR org.hibernate.hql.PARSER (35) - *** ERROR: line 3:48: unexpected token: t
2006-02-15 11:57:04,286 [main] ERROR org.hibernate.impl.SessionFactoryImpl (300) - Error in named query: SchedulerSession.deleteTimersForProcessInstance
org.hibernate.hql.ast.QuerySyntaxError: unexpected token: t near line 3, column 48 [
delete from org.jbpm.scheduler.exe.Timer t
where t.processInstance = :processInstance
]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:63)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:215)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:388)
at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:291)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1005)
at de.innuce.database.toolbox.DBToolBox.GenerateAlterScript(DBToolBox.java:159)
at de.innuce.database.toolbox.DBToolBox.GenerateAlterScriptForPostGres(DBToolBox.java:121)
at de.innuce.database.GenerateAllUpdateScripts.main(GenerateAllUpdateScripts.java:36)
Caused by: line 3:48: unexpected token: t
at org.hibernate.hql.antlr.HqlBaseParser.deleteStatement(HqlBaseParser.java:242)
at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:139)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:209)
... 9 more
2006-02-15 11:57:04,302 [main] ERROR org.hibernate.impl.SessionFactoryImpl (300) - Error in named query: SchedulerSession.suspendTimersForToken
org.hibernate.hql.ast.QuerySyntaxError: expecting "set", found 't' near line 3, column 43 [
update org.jbpm.scheduler.exe.Timer t
set t.isSuspended = true
where t.token = :token
]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:63)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:215)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:388)
at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:291)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1005)
at de.innuce.database.toolbox.DBToolBox.GenerateAlterScript(DBToolBox.java:159)
at de.innuce.database.toolbox.DBToolBox.GenerateAlterScriptForPostGres(DBToolBox.java:121)
at de.innuce.database.GenerateAllUpdateScripts.main(GenerateAllUpdateScripts.java:36)
Caused by: line 3:43: expecting "set", found 't'
at antlr.Parser.match(Parser.java:211)
at org.hibernate.hql.antlr.HqlBaseParser.setClause(HqlBaseParser.java:337)
at org.hibernate.hql.antlr.HqlBaseParser.updateStatement(HqlBaseParser.java:183)
at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:133)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:209)
... 9 more
2006-02-15 11:57:04,317 [main] ERROR org.hibernate.impl.SessionFactoryImpl (300) - Error in named query: SchedulerSession.resumeTimersForToken
org.hibernate.hql.ast.QuerySyntaxError: expecting "set", found 't' near line 3, column 43 [
update org.jbpm.scheduler.exe.Timer t
set t.isSuspended = false
where t.token = :token
]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:63)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:215)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:388)
at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:291)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1005)
at de.innuce.database.toolbox.DBToolBox.GenerateAlterScript(DBToolBox.java:159)
at de.innuce.database.toolbox.DBToolBox.GenerateAlterScriptForPostGres(DBToolBox.java:121)
at de.innuce.database.GenerateAllUpdateScripts.main(GenerateAllUpdateScripts.java:36)
Caused by: line 3:43: expecting "set", found 't'
at antlr.Parser.match(Parser.java:211)
at org.hibernate.hql.antlr.HqlBaseParser.setClause(HqlBaseParser.java:337)
at org.hibernate.hql.antlr.HqlBaseParser.updateStatement(HqlBaseParser.java:183)
at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:133)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:209)
... 9 more
Any hints where I can start searching? Changed the antlr-2.7.5.jar to the one deliveres. I am using Hibernate 3.0.5.
Thanks for any help.
Marcus