<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic repositoryService.createProcessDefinitionQuery().list() Query Bug? in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/repositoryservice-createprocessdefinitionquery-list-query-bug/m-p/233086#M186216</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I use activiti 5.17&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;When invoke below:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;List&amp;lt;ProcessDefinition&amp;gt; processDefinitionList = repositoryService.createProcessDefinitionQuery().list();&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;this is two "order by"?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;the Exception :&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;org.apache.ibatis.exceptions.PersistenceException: &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### Error querying database.&amp;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&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; LIMIT 2147483647 OFFSET 0' at line 7&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### The error may exist in org/activiti/db/mapping/entity/ProcessDefinition.xml&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionsByQueryCriteria_mysql-Inline&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### The error occurred while setting parameters&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### SQL: select distinct RES.*&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; from ACT_RE_PROCDEF RES&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; order by&amp;nbsp; order by RES.ID_ asc&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; LIMIT ? OFFSET ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### 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&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; LIMIT 2147483647 OFFSET 0' at line 7&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:426)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:417)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:407)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntityManager.findProcessDefinitionsByQueryCriteria(ProcessDefinitionEntityManager.java:57)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;at org.activiti.engine.impl.ProcessDefinitionQueryImpl.executeList(ProcessDefinitionQueryImpl.java:288)&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 15 Jan 2016 03:13:59 GMT</pubDate>
    <dc:creator>tangwei</dc:creator>
    <dc:date>2016-01-15T03:13:59Z</dc:date>
    <item>
      <title>repositoryService.createProcessDefinitionQuery().list() Query Bug?</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/repositoryservice-createprocessdefinitionquery-list-query-bug/m-p/233086#M186216</link>
      <description>I use activiti 5.17When invoke below:List&amp;lt;ProcessDefinition&amp;gt; processDefinitionList = repositoryService.createProcessDefinitionQuery().list();this is two "order by"?the Exception &lt;IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" /&gt;rg.apache.ibatis.exceptions.PersistenceException: ### Error querying database.&amp;nbsp; Cause: com.mysql.jdbc.exceptions.j</description>
      <pubDate>Fri, 15 Jan 2016 03:13:59 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/repositoryservice-createprocessdefinitionquery-list-query-bug/m-p/233086#M186216</guid>
      <dc:creator>tangwei</dc:creator>
      <dc:date>2016-01-15T03:13:59Z</dc:date>
    </item>
    <item>
      <title>Re: repositoryService.createProcessDefinitionQuery().list() Query Bug?</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/repositoryservice-createprocessdefinitionquery-list-query-bug/m-p/233087#M186217</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;It is not support mybatis 3.3?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;using mybatis 3.2 will be ok.&lt;/SPAN&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 15 Jan 2016 03:23:50 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/repositoryservice-createprocessdefinitionquery-list-query-bug/m-p/233087#M186217</guid>
      <dc:creator>tangwei</dc:creator>
      <dc:date>2016-01-15T03:23:50Z</dc:date>
    </item>
    <item>
      <title>Re: repositoryService.createProcessDefinitionQuery().list() Query Bug?</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/repositoryservice-createprocessdefinitionquery-list-query-bug/m-p/233088#M186218</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp; It would be big change for me to use the downgraded version of MyBatis now.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp; I may need to take a look at JBOSS one now …&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thank You for the replies .&lt;/SPAN&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 15 Jan 2016 07:19:30 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/repositoryservice-createprocessdefinitionquery-list-query-bug/m-p/233088#M186218</guid>
      <dc:creator>devesh</dc:creator>
      <dc:date>2016-01-15T07:19:30Z</dc:date>
    </item>
    <item>
      <title>Re: repositoryService.createProcessDefinitionQuery().list() Query Bug?</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/repositoryservice-createprocessdefinitionquery-list-query-bug/m-p/233089#M186219</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;We have a PR outstanding to upgrade to MyBatis 3.3.0, so we'll support the latest MyBatis in the next version of Activiti.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Best regards,&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 19 Jan 2016 16:19:20 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/repositoryservice-createprocessdefinitionquery-list-query-bug/m-p/233089#M186219</guid>
      <dc:creator>trademak</dc:creator>
      <dc:date>2016-01-19T16:19:20Z</dc:date>
    </item>
  </channel>
</rss>

