5 Replies Latest reply on Sep 22, 2009 4:18 PM by Torsten R

    HistoryTaskQuery.startedBefore() and startedAfter() dont wor

    Jorge Lugo Newbie

      I'm using jBPM 4.0. When I use HistoryTaskQuery.startedBefore() or HistoryTaskQuery.startedAfter(), I get the following exception ...

      2009-09-09 14:30:17,483 INFO [org.jbpm.pvm.internal.svc.DefaultCommandService] (http-127.0.0.1-8080-6) exception while executing command org.jbpm.pvm.internal.query.HistoryTaskQueryImpl@171cb33
      org.hibernate.QueryException: could not resolve property: startTime of: org.jbpm.pvm.internal.history.model.HistoryTaskImpl [select ht from org.jbpm.pvm.internal.history.model.HistoryTaskImpl as ht where ht.startTime < :startedBefore and ht.startTime > :startedAfter ]
      at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67)
      at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61)
      at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1385)
      at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:302)
      at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:407)
      at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:589)
      at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:264)
      at org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:211)
      at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:117)
      at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:113)
      at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:750)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1216)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4041)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3573)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1762)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1687)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:577)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
      at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:251)
      at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
      at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
      at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101)
      at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:80)
      at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
      at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
      at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
      at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)
      at org.jbpm.pvm.internal.query.AbstractQuery.execute(AbstractQuery.java:85)
      at org.jbpm.pvm.internal.query.AbstractQuery.execute(AbstractQuery.java:80)
      at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
      at org.jbpm.pvm.internal.tx.jta.JtaTransactionInterceptor.executeInNewTx(JtaTransactionInterceptor.java:79)
      at org.jbpm.pvm.internal.tx.jta.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:61)
      at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
      at org.jbpm.pvm.internal.tx.jta.JtaRetryInterceptor.executeWithRetry(JtaRetryInterceptor.java:52)
      at org.jbpm.pvm.internal.tx.jta.JtaRetryInterceptor.execute(JtaRetryInterceptor.java:45)
      at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
      at org.jbpm.pvm.internal.query.AbstractQuery.untypedList(AbstractQuery.java:61)
      at org.jbpm.pvm.internal.query.HistoryTaskQueryImpl.list(HistoryTaskQueryImpl.java:113)
      ...