As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
Recently we got this error:### Error querying database. Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl'### Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl'
The issue got resolved after restarting the service.
I see that same error was reported more than three years back here:https://community.alfresco.com/message/786956-re-there-is-no-getter-for-property-named-limitbefore-in-class-orgactivitiengineimplprocessinstancequeryimpl
We have been using Activiti V5.15 since long & faced this error for the first time. Hence databaseType should not be an issue as discussed in above question. Also we have adequate database processes.
As question was reported more than 3 years back. Just wanted to check if anybody has faced this recently or any changes thereafter would have addressed it?
How often are you experiencing this problem? Is it intermittent or a "hard" error?
If it is intermittent, it may be difficult to locate the exact cause of the error.
Do you have a full stack?
Thanks,greg
Hi Greg,
This is a hard to get error, came across for the first time.
The error stack is as below:
Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl'### Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl' at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98) at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:332) at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:323) at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:313) at org.activiti.engine.impl.persistence.entity.ModelEntityManager.findModelsByQueryCriteria(ModelEntityManager.java:125) at org.activiti.engine.impl.ModelQueryImpl.executeList(ModelQueryImpl.java:219) at org.activiti.engine.impl.AbstractQuery.executeSingleResult(AbstractQuery.java:158) at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:141) at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24) at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57) at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133) at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45) at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35) at org.activiti.engine.impl.AbstractQuery.singleResult(AbstractQuery.java:104) ... 125 moreCaused by: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl' at org.apache.ibatis.reflection.Reflector.getGetInvoker(Reflector.java:377) at org.apache.ibatis.reflection.MetaClass.getGetInvoker(MetaClass.java:167) at org.apache.ibatis.reflection.wrapper.BeanWrapper.getBeanProperty(BeanWrapper.java:149) at org.apache.ibatis.reflection.wrapper.BeanWrapper.get(BeanWrapper.java:45) at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:113) at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextMap.get(DynamicContext.java:94) at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextAccessor.getProperty(DynamicContext.java:113) at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1657) at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:92) at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170) at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210) at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:333) at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:413) at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:395) at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:45) at org.apache.ibatis.scripting.xmltags.TextSqlNode$BindingTokenParser.handleToken(TextSqlNode.java:61) at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:50) at org.apache.ibatis.scripting.xmltags.TextSqlNode.apply(TextSqlNode.java:38) at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:29) at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:37) at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:275) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:79) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104) ... 143 more
ThanksRakesh
I assumed this was something that was at best intermittent.
Not sure this is something we will be able to debug without a reproduction.
This isn't an uncommon error in the MyBatis/iBatis forums.
Greg
