<?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 myBatis compatibility in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199149#M152279</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;I am new to Apache Activiti BPM tool.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;We are planning to define processes using Activiti BPM tool.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;When we integrated Activiti process with our application, we found that the invocation singleResult() method (on ExecutionQuery and TaskQuery) failed every time with below exception,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;HTTP Status 500 - &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### The error may exist in org/activiti/db/mapping/entity/Execution.xml &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.selectExecutionsByQueryCriteria-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 * from &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;( &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;select a.*, ROWNUM rnum &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;from &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;( &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;select distinct RES.* , P.KEY_ as ProcessDefinitionKey, P.ID_ as ProcessDefinitionId &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&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_RU_EXECUTION RES &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;inner join ACT_RE_PROCDEF P on RES.PROC_DEF_ID_ = P.ID_ &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;WHERE RES.PROC_INST_ID_ = ? &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&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 order by RES.ID_ asc &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;) a &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;where ROWNUM &amp;lt; ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;) &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;where rnum &amp;gt;= ? &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;### Cause: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;(The order by clause was getting appended twice)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;We understand that the activiti internal calls to database is made only using myBatis framework.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Upon analysis we found that the issue occurred due to the incompatible myBatis jar. Our application uses myBatis-3.3.0 but activiti works fine with myBatis3.2.5.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I need clarification for the below, &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1. Is there any option to support latest myBatis version(as we are not supposed to downgrade myBatis)?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2. Is there any method that supports JDBC instead of myBatis, which would not impact if we upgrade to newer versions of myBatis in future?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Please help me here.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 21 Oct 2015 04:09:57 GMT</pubDate>
    <dc:creator>logasram</dc:creator>
    <dc:date>2015-10-21T04:09:57Z</dc:date>
    <item>
      <title>myBatis compatibility</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199149#M152279</link>
      <description>Hi,I am new to Apache Activiti BPM tool.We are planning to define processes using Activiti BPM tool.When we integrated Activiti process with our application, we found that the invocation singleResult() method (on ExecutionQuery and TaskQuery) failed every time with below exception,HTTP Status 500 -</description>
      <pubDate>Wed, 21 Oct 2015 04:09:57 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199149#M152279</guid>
      <dc:creator>logasram</dc:creator>
      <dc:date>2015-10-21T04:09:57Z</dc:date>
    </item>
    <item>
      <title>Re: myBatis compatibility</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199150#M152280</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;Forgot to mention the Activiti version.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;We are using 5.18.0&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 21 Oct 2015 05:49:36 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199150#M152280</guid>
      <dc:creator>logasram</dc:creator>
      <dc:date>2015-10-21T05:49:36Z</dc:date>
    </item>
    <item>
      <title>Re: myBatis compatibility</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199151#M152281</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;Could you please help me here?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 22 Oct 2015 06:09:32 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199151#M152281</guid>
      <dc:creator>logasram</dc:creator>
      <dc:date>2015-10-22T06:09:32Z</dc:date>
    </item>
    <item>
      <title>Re: myBatis compatibility</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199152#M152282</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;There is an improvement request for this upgrade.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;see: &lt;/SPAN&gt;&lt;A href="https://activiti.atlassian.net/browse/ACT-4081" rel="nofollow noopener noreferrer"&gt;https://activiti.atlassian.net/browse/ACT-4081&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;1. I cannot see any possibility to use the latest myBatis except upgrading it to the latest version &lt;img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /&gt; (and all the necessary code changes..)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2. considering you are using 5.18 I there is no option for using other persistence frameworks&amp;nbsp; (such possibility will be available in Activiti 6 &lt;img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /&gt; )&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Would be nice if you could upgrade myBatis to the latest version and create a PR. (what do you think, are you in ?)&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Oct 2015 08:25:02 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199152#M152282</guid>
      <dc:creator>vasile_dirla</dc:creator>
      <dc:date>2015-10-26T08:25:02Z</dc:date>
    </item>
    <item>
      <title>Re: myBatis compatibility</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199153#M152283</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi Vasile,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks for your response.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I am unable to access the atlassian link provided by you.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Please correct me if my understanding is wrong,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;1. Until I upgrade the Activiti, there is no possibility to use the latest myBatis .&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;2. There is no option to use any other framework except myBatis&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;"Would be nice if you could upgrade myBatis to the latest version and create a PR." - Sorry I am missing your context here. &lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Oct 2015 12:03:51 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199153#M152283</guid>
      <dc:creator>logasram</dc:creator>
      <dc:date>2015-10-26T12:03:51Z</dc:date>
    </item>
    <item>
      <title>Re: myBatis compatibility</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199154#M152284</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;1. About the JIRA link you cannot access: is about a improvement request starting from this conversation:&amp;nbsp; &lt;/SPAN&gt;&lt;A href="https://github.com/Activiti/Activiti/issues/597#issuecomment-150505937" rel="nofollow noopener noreferrer"&gt;https://github.com/Activiti/Activiti/issues/597#issuecomment-150505937&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;In version 5.18 we use myBatis&amp;nbsp; 3.2.5 and the only way to benefit of the latest version of myBatis is to upgrade myBatis library in Activiti.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;If you think you can handle this myBatis upgrade you are welcome to do it and then create a pull request. (since it's a open source engine we're happy to see the community is bigger and the number of committers is growing)&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I don't know what to say about when Activiti will use a newer version of myBatis but if a pull request will come, then for sure it's much probably to have it.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Oct 2015 14:47:41 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199154#M152284</guid>
      <dc:creator>vasile_dirla</dc:creator>
      <dc:date>2015-10-26T14:47:41Z</dc:date>
    </item>
    <item>
      <title>Re: myBatis compatibility</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199155#M152285</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;BR /&gt;&lt;SPAN&gt;This is related so tagging onto this thread. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;We have been (happily) using Activiti 5.10 for a number of years now in a large application. Currently we are facing an integration issue with an external library that depends on mybatis 3.3.0 .. I understand that this version is not supported in Activiti it uses 3.1.1 : we get this exception &lt;/SPAN&gt;&lt;A href="https://forums.activiti.org/content/activiti-5121-not-compatiable-mybatis-322" rel="nofollow noopener noreferrer"&gt;https://forums.activiti.org/content/activiti-5121-not-compatiable-mybatis-322&lt;/A&gt;&lt;SPAN&gt; &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;What are our options to get around this ? Could 5.10 be easily patched to use mybatis 3.3 ? What would the upgrade effort be for activiti 5.10 to the latest (assuming a more recent version of mybatis is indeed supported there)&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thanks,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Jorg&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 19 Jan 2016 14:29:28 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199155#M152285</guid>
      <dc:creator>jorgheymans</dc:creator>
      <dc:date>2016-01-19T14:29:28Z</dc:date>
    </item>
    <item>
      <title>Re: myBatis compatibility</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199156#M152286</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi Jorg,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;There's a PR waiting to be merged, to support MyBatis 3.3.0:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;A href="https://github.com/Activiti/Activiti/pull/774" rel="nofollow noopener noreferrer"&gt;https://github.com/Activiti/Activiti/pull/774&lt;/A&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 15:52:57 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/mybatis-compatibility/m-p/199156#M152286</guid>
      <dc:creator>trademak</dc:creator>
      <dc:date>2016-01-19T15:52:57Z</dc:date>
    </item>
  </channel>
</rss>

