Red Hat Bugzilla – Bug 1261078
REST Query API: SQLGrammarException when executing task queries
Last modified: 2016-09-20 01:12:27 EDT
Created attachment 1071380 [details]
Description of problem:
When you try to execute any task query, you will get SQLGrammarException in the response.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Try for example http://localhost:8080/business-central/rest/query/runtime/task?processInstanceId=1
2. See the response and server log.
There is SQLGrammarException. You can find full stack trace in the attached server log. It seems there are some inconsistencies in database schema.
Valid result without any exception.
This probably affects all task queries.
Tomas, could you verify that you're experiencing this on any platform that uses hibernate 4.2.19-redhat-1 or 4.2.20?
In particular, EAP 6.4.0+.
Marco, I used EAP 6.4.0 GA which contains Hibernate 4.2.18.Final-redhat-2. I will try it with BPMS 6.2.0 ER2 on EAP 6.4.3 and Hibernate 4.2.20.Final-redhat-1 and let you know.
I have just tried it on EAP 6.4.3 with Hibernate 4.2.20.Final-redhat-1 and there is no SQLGrammarException anymore.
Verified on BPMS 6.2.0 ER2