topic Mysql syntax error in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/mysql-syntax-error/m-p/211157#M164287 <HTML><HEAD></HEAD><BODY><SPAN>hi all, </SPAN><BR /><SPAN>i am new to activiti, and after i set up the environment and try some simple code, but meet some strange error.</SPAN><BR /><SPAN>here is my code:</SPAN><BR /><SPAN>ProcessEngine processEngine = factoryBean.getObject(); //factoryBean is type of ProcessEngineFactoryBean</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task task = processEngine.getTaskService().createTaskQuery().singleResult(); //throw exception here</SPAN><BR /><BR /><SPAN>error message:</SPAN><BR /><SPAN>org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.exceptions.PersistenceException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'order by RES.ID_ asc&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; LIMIT 2147483647 OFFSET 0' at line 15</SPAN><BR /><SPAN>### The error may exist in org/activiti/db/mapping/entity/Task.xml</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### SQL: select distinct RES.*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from ACT_RU_TASK RES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order by&nbsp; order by RES.ID_ asc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LIMIT ? OFFSET ?</SPAN><BR /><SPAN>### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'order by RES.ID_ asc&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; LIMIT 2147483647 OFFSET 0' at line 15</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;javax.servlet.http.HttpServlet.service(HttpServlet.java:620)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;javax.servlet.http.HttpServlet.service(HttpServlet.java:727)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</SPAN><BR /><BR /><SPAN>environment:</SPAN><BR /><SPAN>spring: 4.0.2.RELEASE</SPAN><BR /><SPAN>mysql-connector-java: 5.1.18</SPAN><BR /><SPAN>activiti-engine: 5.17.0</SPAN><BR /><SPAN>mybatis: 3.3.0</SPAN><BR /><BR /><SPAN>my question is: why a simple task query generate a sql including 'order by' twice and throw a sql syntax exception of cause?</SPAN></BODY></HTML> Thu, 25 Jun 2015 14:00:49 GMT hair888 2015-06-25T14:00:49Z Mysql syntax error https://connect.hyland.com/t5/alfresco-archive/mysql-syntax-error/m-p/211157#M164287 hi all, i am new to activiti, and after i set up the environment and try some simple code, but meet some strange error.here is my code<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />rocessEngine processEngine = factoryBean.getObject(); //factoryBean is type of ProcessEngineFactoryBean&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Task task = processEngine.getTaskService().createTask Thu, 25 Jun 2015 14:00:49 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-syntax-error/m-p/211157#M164287 hair888 2015-06-25T14:00:49Z Re: Mysql syntax error https://connect.hyland.com/t5/alfresco-archive/mysql-syntax-error/m-p/211158#M164288 <HTML><HEAD></HEAD><BODY><SPAN>The problem is that the mybatis version does not match that of Activiti. We haven't upgraded to that version yet.</SPAN></BODY></HTML> Tue, 30 Jun 2015 19:41:04 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-syntax-error/m-p/211158#M164288 jbarrez 2015-06-30T19:41:04Z Re: Mysql syntax error https://connect.hyland.com/t5/alfresco-archive/mysql-syntax-error/m-p/211159#M164289 <HTML><HEAD></HEAD><BODY><SPAN>yes, thank you! And after I comment the mybatis pom dependency, it works fine.</SPAN></BODY></HTML> Wed, 01 Jul 2015 02:04:31 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-syntax-error/m-p/211159#M164289 hair888 2015-07-01T02:04:31Z