AnsweredAssumed Answered

PostgreSQL-specific SQL configuration

Question asked by lichtin on Oct 12, 2011
Latest reply on Oct 15, 2011 by trademak
For selectCommentsByProcessInstanceId_postgres the type is set as BINARY. Is this required or a typo?

<select id="selectCommentsByProcessInstanceId" parameterType="string" resultMap="commentResultMap">
    select *
    from ACT_HI_COMMENT
    where PROC_INST_ID_ = #{processInstanceId,jdbcType=VARCHAR}
    order by TIME_ desc
  </select>

  <select id="selectCommentsByProcessInstanceId_postgres" parameterType="string" resultMap="commentResultMap_postgres">
    select *
    from ACT_HI_COMMENT
    where PROC_INST_ID_ = #{processInstanceId,jdbcType=BINARY}
    order by TIME_ desc
  </select>

Outcomes