topic Re: Problem calling historyService.createHistoricDetailQuery() in Alfresco Archive

Problem calling historyService.createHistoricDetailQuery()

wolpert — Mon, 18 Apr 2011 23:14:59 GMT

Folks- Using activiti 5.4, I'm getting an error when I try to generate a createHistoricDetailQuery() request. Specific code calling is this:historyService.createHistoricDetailQuery().activityInstanceId(instance.getId()).orderByTime().desc().list()though I've tried different ways to call it, all wit

Re: Problem calling historyService.createHistoricDetailQuery()

jbarrez — Tue, 19 Apr 2011 10:15:44 GMT

Are you using the out of the box Activiti. More specifically, are you using a different version of MyBatis?

Re: Problem calling historyService.createHistoricDetailQuery()

wolpert — Tue, 19 Apr 2011 15:49:39 GMT

Its stock activiti, but via the grails-activiti-plugin. It should be the same version of MyBatis that ships with activiti 5.4.

Re: Problem calling historyService.createHistoricDetailQuery()

jbarrez — Wed, 20 Apr 2011 08:32:01 GMT

We have a test suite, which would certainly have catched this error.
Any chance you can retry it on a stock activiti without Grails?

Re: Problem calling historyService.createHistoricDetailQuery()

wolpert — Wed, 20 Apr 2011 16:25:11 GMT

The grails plugin uses activiti-engine-5.4.jar and mybatis-3.0.1.jar… is this the correct version?

Re: Problem calling historyService.createHistoricDetailQuery()

wolpert — Wed, 20 Apr 2011 16:51:50 GMT

I can verify that the grails activiti plugin works fine. Specifically, using the 5.4 version of the grails activiti plugin and the sample vacation app, adding the historyDetailQuery() usage doesn't cause the same problem. So its probably something I'm doing…

But what could I do that causes this error? What should I look for?

Re: Problem calling historyService.createHistoricDetailQuery()

wolpert — Wed, 20 Apr 2011 17:18:47 GMT

One question on the test case… does it run for each database supported? I.E., postgres in my case?

Re: Problem calling historyService.createHistoricDetailQuery()

wolpert — Wed, 20 Apr 2011 17:21:04 GMT

(Sorry for writing so many separate posts)

I can't find the test case you have that executes createHistoricDetailQuery() with live data. Can you point it out to me?

Re: Problem calling historyService.createHistoricDetailQuery()

limcheekin — Thu, 21 Apr 2011 02:28:06 GMT

(Sorry for writing so many separate posts)

I can't find the test case you have that executes createHistoricDetailQuery() with live data. Can you point it out to me?

Hi Ned,

Please look into test cases shipped with Activiti 5.4 distribution instead activiti examples in the grails plugin. Sorry to tell you that I didn't upgrade the activiti examples to 5.4 due to time constraints.

Best regards,
Chee Kin

Re: Problem calling historyService.createHistoricDetailQuery()

wolpert — Thu, 21 Apr 2011 03:14:25 GMT

Actually, I did do that. I couldn't find any example that called createHistoricDetailQuery() in the svn repo here:

http://svn.codehaus.org/activiti/activiti/tags/activiti-5.4/modules/activiti-engine/src/test/java/org/activiti/engine/test/history/

I may have missed it, so I figure I'd ask… but searching for Detail or detail comes up blank…so it looks like its not tested. I'll download the whole src and give it a grep…

Re: Problem calling historyService.createHistoricDetailQuery()

wolpert — Thu, 21 Apr 2011 03:18:34 GMT

Found it…

http://svn.codehaus.org/activiti/activiti/tags/activiti-5.4/modules/activiti-engine/src/test/java/org/activiti/standalone/history/FullHistoryTest.java

So I'm not doing anything different… still could use pointers for where to look.

Re: Problem calling historyService.createHistoricDetailQuery()

jbarrez — Thu, 21 Apr 2011 08:24:07 GMT

All our test cases run on all the databases we support, hence why I'm so certain.

The error is really strange - as the mapped statement has nothing to do with your query … I'm actually puzzled :s