'selectExclusiveJobsToExecute' does not work for DB2 and MSSQL

<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>

<select id="selectExclusiveJobsToExecute_custom" 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_ = 1)
	  and (PROCESS_INSTANCE_ID_ = #{pid})
  </select>