I'm using activiti rest with mysql 5.6 when I call the rest service at INFO: 2013-10-14 14:18:52 0:0:0:0:0:0:0:1 eze-THINK\eze 0:0:0:0:0:0:0:1 8080 GET /dsaops/activiti/history/historic-variable-instances processInstanceId=33101&size=200 500 - 0 46 http://localhost:8080 Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.69 Safari/537.36 http://localhost:8080/dsaops/
then i get this stack
oct 14, 2013 2:18:52 PM org.restlet.resource.UniformResource doCatch WARNING: Exception or error caught in resource org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.hibernate.exception.SQLGrammarException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) from ACT_HI_VARINST RES WHERE RES.PROC_INST_ID_ = '33101'' at line 1 ### The error may exist in org/activiti/db/mapping/entity/HistoricVariableInstance.xml ### The error may involve org.activiti.engine.impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceCountByQueryCriteria-Inline ### The error occurred while setting parameters ### SQL: select count(RES.*) from ACT_HI_VARINST RES WHERE RES.PROC_INST_ID_ = ? ### Cause: org.hibernate.exception.SQLGrammarException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) from ACT_HI_VARINST RES WHERE RES.PROC_INST_ID_ = '33101'' at line 1 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.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62) at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:290)….
