PostgreSQL-specific SQL configuration

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

lichtin

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

trademak

Hmm strange, yes I think it's a typo.

Best regards,