topic Re: Asynchronous Process with DB2 in Alfresco Archive

Asynchronous Process with DB2

kirek — Wed, 07 Mar 2012 09:44:22 GMT

Hi,i have a problem with an asynchronous service task.I built a very simple process..[attachment=0]process.JPG[/attachment]..with an asynchronous serviceTask.The process fails all the time with db2 and throws this exception: :roll: ### Error querying database. Cause: com.ibm.db2.jcc.am.SqlSyntaxEr

Re: Asynchronous Process with DB2

kirek — Thu, 08 Mar 2012 14:19:26 GMT

I found the problem.

There is a bug in the activiti-engine-5.9.jar/org.activiti.db.mapping.entity/job.xml

  <select id="selectExclusiveJobsToExecute" parameterType="map" resultMap="jobResultMap">
    select * 
    from ACT_RU_JOB     
    where (RETRIES_ &gt; 0)
      and (DUEDATE_ is null or DUEDATE_ &lt; #{now, jdbcType=TIMESTAMP})
      and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ &lt; #{now, jdbcType=TIMESTAMP})
      and (RETRIES_ &gt; 0)
      and (EXCLUSIVE_ = TRUE)
      and (PROCESS_INSTANCE_ID_ = #{pid})  
  </select>

This sql tries to compare the EXCLUSIVE_ with "TRUE". But in DB2 "EXCLUSIVE_" is created as a smallint and should be compared with "1" (like oracle)

I fixed the problem by replacing "TRUE" with "1"

Re: Asynchronous Process with DB2

meyerd — Fri, 09 Mar 2012 10:13:21 GMT

Hi kirek,

Nice catch, would you be willing to attach a patch to ACT-1131 ?

Re: Asynchronous Process with DB2

kirek — Mon, 12 Mar 2012 07:00:23 GMT

see more here..

https://jira.codehaus.org/browse/ACT-1131

but only use the attaced file, if you only work with DB2.
The changed Methods are used by every database (excluded oracle), so you cannot
work with other databases anymore.