4 Replies Latest reply on May 5, 2006 11:39 AM by Enrique Ruiz

    Error parsing queries with jBPM 3.1

    Marcus Schulz Newbie

      Hi,

      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