topic Error: double quotes in HistoricVariableInstance query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-double-quotes-in-historicvariableinstance-query/m-p/165377#M119063 <HTML><HEAD></HEAD><BODY><SPAN>I'm using activiti rest with mysql 5.6</SPAN><BR /><SPAN>when I call the rest service at </SPAN><BR /><SPAN>INFO: 2013-10-14&nbsp;&nbsp;&nbsp;14:18:52&nbsp;&nbsp;&nbsp;0:0:0:0:0:0:0:1&nbsp;&nbsp;&nbsp;eze-THINK\eze&nbsp;&nbsp;&nbsp;0:0:0:0:0:0:0:1&nbsp;&nbsp;&nbsp;8080&nbsp;&nbsp;&nbsp;GET&nbsp;&nbsp;&nbsp;/dsaops/activiti/history/historic-variable-instances&nbsp;&nbsp;&nbsp;processInstanceId=33101&amp;size=200&nbsp;&nbsp;&nbsp;500&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;46&nbsp;&nbsp;&nbsp;</SPAN><A href="http://localhost:8080" rel="nofollow noopener noreferrer">http://localhost:8080</A><SPAN>&nbsp;&nbsp;&nbsp;Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.69 Safari/537.36&nbsp;&nbsp;&nbsp;</SPAN><A href="http://localhost:8080/dsaops/" rel="nofollow noopener noreferrer">http://localhost:8080/dsaops/</A><BR /><BR /><SPAN>then i get this stack</SPAN><BR /><BR /><SPAN>oct 14, 2013 2:18:52 PM org.restlet.resource.UniformResource doCatch</SPAN><BR /><SPAN>WARNING: Exception or error caught in resource</SPAN><BR /><SPAN>org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; 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 '*)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; from ACT_HI_VARINST RES</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE RES.PROC_INST_ID_ = '33101'' at line 1</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/HistoricVariableInstance.xml</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceCountByQueryCriteria-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select count(RES.*)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from ACT_HI_VARINST RES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE RES.PROC_INST_ID_ = ?</SPAN><BR /><SPAN>### 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 '*)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; from ACT_HI_VARINST RES</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; WHERE RES.PROC_INST_ID_ = '33101'' at line 1</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectOne(DbSqlSession.java:290)….</SPAN></BODY></HTML> Mon, 14 Oct 2013 17:30:59 GMT barula 2013-10-14T17:30:59Z Error: double quotes in HistoricVariableInstance query https://connect.hyland.com/t5/alfresco-archive/error-double-quotes-in-historicvariableinstance-query/m-p/165377#M119063 I'm using activiti rest with mysql 5.6when I call the rest service at INFO: 2013-10-14&nbsp;&nbsp;&nbsp;14:18:52&nbsp;&nbsp;&nbsp;0:0:0:0:0:0:0:1&nbsp;&nbsp;&nbsp;eze-THINK\eze&nbsp;&nbsp;&nbsp;0:0:0:0:0:0:0:1&nbsp;&nbsp;&nbsp;8080&nbsp;&nbsp;&nbsp;GET&nbsp;&nbsp;&nbsp;/dsaops/activiti/history/historic-variable-instances&nbsp;&nbsp;&nbsp;processInstanceId=33101&amp;size=200&nbsp;&nbsp;&nbsp;500&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;46&nbsp;&nbsp;&nbsp;http://localhost:8080&nbsp; Mon, 14 Oct 2013 17:30:59 GMT https://connect.hyland.com/t5/alfresco-archive/error-double-quotes-in-historicvariableinstance-query/m-p/165377#M119063 barula 2013-10-14T17:30:59Z Re: Error: double quotes in HistoricVariableInstance query https://connect.hyland.com/t5/alfresco-archive/error-double-quotes-in-historicvariableinstance-query/m-p/165378#M119064 <HTML><HEAD></HEAD><BODY><SPAN>Any reason you're still on 5.6? It's quite old (the rest api was completely different back then!), why not upgrade to the latest?</SPAN></BODY></HTML> Mon, 21 Oct 2013 10:34:23 GMT https://connect.hyland.com/t5/alfresco-archive/error-double-quotes-in-historicvariableinstance-query/m-p/165378#M119064 jbarrez 2013-10-21T10:34:23Z