HistoryTaskQuery.startedBefore() and startedAfter() dont wor

[jnlugo]

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)
...

[kukeltje]

Can you try 4.1 first?

[jnlugo]

How do I get version 4.1?

[kukeltje]

You can find my response here here and the answer here

[jnlugo]

The same problem occurs with jbpm 4.1.

[tcr]

Hi,
I had the same problem. I checked the hibernate config for HistoryTask (jbpm.history.hbm.xml) and could not find an attribute called startTime. Additionally I could find a member of that name in the HistoryTask class. But I found a member and a mapping for CreateTime!

After I changed the hql() method in HistoryTaskQueryImpl it worked:

if (startedBefore!=null) {
 appendWhereClause(" ht.createTime < :startedBefore ", hql);
 }

 if (startedAfter!=null) {
 appendWhereClause(" ht.createTime > :startedAfter ", hql);
 }

HTH
Torsten