topic Activiti 5.11: wrong historicDetailResultMap_postgres in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-5-11-wrong-historicdetailresultmap-postgres/m-p/122603#M86334 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>After upgrade to Activiti 5.11 the query:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />List&lt;HistoricDetail&gt; hds = historyService.createHistoricDetailQuery().processInstanceId(processInstanceId).variableUpdates().orderByTime().desc().list();<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>return HistoricDetail that not implements HistoricVariableUpdate , then is impossible access variable informations (via cast).</SPAN><BR /><BR /><SPAN>I use POSTGRES as DB and I think only this db is affected, indeed after some investigation I found a problem in HistoricDetail.xml:</SPAN><BR /><BR /><SPAN>The "createHistoricDetailQuery" use "historicDetailResultMap" that in case of POSTGRES is remapped to "historicDetailResultMap_postgres". </SPAN><BR /><SPAN>In "historicDetailResultMap_postgres" definition there is:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;discriminator javaType="string" column="TYPE_"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;case value="VariableUpdate" resultMap="historicVariableUpdateResultMap_postgres"/&gt; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;case value="FormProperty" resultMap="historicFormPropertyResultMap"/&gt; <BR />&lt;/discriminator&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>but "historicVariableUpdateResultMap_postgres" is not defined, then the MyBatis fails to map data.</SPAN><BR /><BR /><SPAN>My workaround is change "historicVariableUpdateResultMap_postgres" in "historicVariableUpdateResultMap" that is defined after in HistoricDetail.xml.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;discriminator javaType="string" column="TYPE_"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;case value="VariableUpdate" resultMap="historicVariableUpdateResultMap"/&gt; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;case value="FormProperty" resultMap="historicFormPropertyResultMap"/&gt; <BR />&lt;/discriminator&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Now query works and is possible to cast returned HistoricDetail to HistoricVariableUpdate.</SPAN><BR /><BR /><SPAN>Can you apply patch on next release please?</SPAN><BR /><BR /><SPAN>Best regards!</SPAN></BODY></HTML> Mon, 31 Dec 2012 07:38:22 GMT xandros 2012-12-31T07:38:22Z Activiti 5.11: wrong historicDetailResultMap_postgres https://connect.hyland.com/t5/alfresco-archive/activiti-5-11-wrong-historicdetailresultmap-postgres/m-p/122603#M86334 Hi,After upgrade to Activiti 5.11 the query:List&lt;HistoricDetail&gt; hds = historyService.createHistoricDetailQuery().processInstanceId(processInstanceId).variableUpdates().orderByTime().desc().list();‍‍‍return HistoricDetail that not implements HistoricVariableUpdate , then is impossible access v Mon, 31 Dec 2012 07:38:22 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-5-11-wrong-historicdetailresultmap-postgres/m-p/122603#M86334 xandros 2012-12-31T07:38:22Z Re: Activiti 5.11: wrong historicDetailResultMap_postgres https://connect.hyland.com/t5/alfresco-archive/activiti-5-11-wrong-historicdetailresultmap-postgres/m-p/122604#M86335 <HTML><HEAD></HEAD><BODY><SPAN>Hi, thanks for reporting this. I stumbled upon this issue today an will get it fixed asap…</SPAN><BR /><BR /><A href="https://jira.codehaus.org/browse/ACT-1512" rel="nofollow noopener noreferrer">https://jira.codehaus.org/browse/ACT-1512</A></BODY></HTML> Thu, 03 Jan 2013 09:39:19 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-5-11-wrong-historicdetailresultmap-postgres/m-p/122604#M86335 frederikherema1 2013-01-03T09:39:19Z Re: Activiti 5.11: wrong historicDetailResultMap_postgres https://connect.hyland.com/t5/alfresco-archive/activiti-5-11-wrong-historicdetailresultmap-postgres/m-p/122605#M86336 <HTML><HEAD></HEAD><BODY><SPAN>OK, thanks!</SPAN></BODY></HTML> Sun, 06 Jan 2013 21:44:06 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-5-11-wrong-historicdetailresultmap-postgres/m-p/122605#M86336 xandros 2013-01-06T21:44:06Z