topic taskService.createTaskQuery().orderByExecutionId().desc().list() -invalid query getting created in Alfresco Archive

taskService.createTaskQuery().orderByExecutionId().desc().list() -invalid query getting created

devesh — Sun, 10 Jan 2016 19:45:39 GMT

Activiti Engine : 5.19.0Usage : taskService.createTaskQuery().orderByExecutionId().desc().list() ;Database MySQL : Logs rg.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL s

Re: taskService.createTaskQuery().orderByExecutionId().desc().list() -invalid query getting created

vasile_dirla — Mon, 11 Jan 2016 20:37:18 GMT

Hi, did you upgrade any library (for example mybatis) or this happens with the out of the box version ?

Re: taskService.createTaskQuery().orderByExecutionId().desc().list() -invalid query getting created

devesh — Tue, 12 Jan 2016 19:08:07 GMT

I have just started with activiti and not updated any library.
Mybatis version I have used : 3.3

The Sample code I am using is :
<java>
TaskService taskService = processEngine.getTaskService();
ManagementService managementService = processEngine.getManagementService();
IdentityService identityService = processEngine.getIdentityService();
HistoryService historyService = processEngine.getHistoryService();
FormService formService = processEngine.getFormService();
System.out.println(identityService);

System.out.println("Number of process definitions : " + repositoryService.createProcessDefinitionQuery().count());
System.out.println("Number of tasks : " + taskService.createTaskQuery().count());
// runtimeService.startProcessInstanceByKey("holidayVacationRequest");
System.out.println("Number of tasks after process start: " + taskService.createTaskQuery().count());

Map<String, Object> variables = new HashMap<String, Object>();
variables.put("employeeName", "Kermit");
variables.put("numberOfDays", new Integer(4));
variables.put("vacationMotivation", "I'm really tired!");

ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("holidayVacationRequest", variables);

List<Task> tasks = taskService.createTaskQuery().orderByExecutionId().desc().list();
for (Task task : tasks) {
System.out.println(task);
}
</java>

Output I am getting as :

org.activiti.engine.impl.IdentityServiceImpl@3542162a
Number of process definitions : 11
Number of tasks : 90
Number of tasks after process start: 90

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. 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.EXECUTION_ID_ desc
LIMIT 2147483647 OFFSET 0' at line 15
### The error may exist in org/activiti/db/mapping/entity/Task.xml
### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria-Inline
### The error occurred while setting parameters

Re: taskService.createTaskQuery().orderByExecutionId().desc().list() -invalid query getting created

devesh — Wed, 13 Jan 2016 05:08:38 GMT

Just few points to highlight,
1) The order by clause its repeated
2) The activiti-explorer is using mybatis 3.2 version and the out of the box version that I have deployed is using mybatis 3.3 .
3) The code works if I downgrade the mybatis version to 3.2 for out of the box activiti engine .

Re: taskService.createTaskQuery().orderByExecutionId().desc().list() -invalid query getting created

jbarrez — Wed, 20 Jan 2016 22:08:26 GMT

@Devesh: correct.

Mybatis has been upgraded to 3.3 on master: https://github.com/Activiti/Activiti/commit/647e92b667e98e4cf3d063dd9ff05952a3e87e13

Re: taskService.createTaskQuery().orderByExecutionId().desc().list() -invalid query getting created

devesh — Thu, 21 Jan 2016 04:41:31 GMT

Hi,
Thank you for updating the mybatis version, saved my research and time to use the JBOSS Drools .
Would I be able to download this version (5.20-Snapshot) from http://activiti.org/download.html , or I need to build from git hub.
I searched on http://activiti.org/download.html but the 5.20-Snapshot is not present for download.

Re: taskService.createTaskQuery().orderByExecutionId().desc().list() -invalid query getting created

jbarrez — Thu, 21 Jan 2016 09:18:24 GMT

No, snapshots are not published. You will need to build from source after cloning the root repository (i think a 'mvn -Pcheck -DskipTests clean install' will give you the jars you want)

Re: taskService.createTaskQuery().orderByExecutionId().desc().list() -invalid query getting created

devesh — Thu, 21 Jan 2016 10:32:25 GMT

Thank You ,
Will build it from source and would be ready for version 6 with the current changes to be present in the upcoming version.