topic PostgreSQL-specific SQL configuration in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/postgresql-specific-sql-configuration/m-p/59368#M36490 <HTML><HEAD></HEAD><BODY><SPAN>For selectCommentsByProcessInstanceId_postgres the type is set as BINARY. Is this required or a typo?</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>&lt;select id="selectCommentsByProcessInstanceId" parameterType="string" resultMap="commentResultMap"&gt;<BR />&nbsp;&nbsp;&nbsp; select *<BR />&nbsp;&nbsp;&nbsp; from ACT_HI_COMMENT<BR />&nbsp;&nbsp;&nbsp; where PROC_INST_ID_ = #{processInstanceId,jdbcType=VARCHAR}<BR />&nbsp;&nbsp;&nbsp; order by TIME_ desc<BR />&nbsp; &lt;/select&gt;<BR /><BR />&nbsp; &lt;select id="selectCommentsByProcessInstanceId_postgres" parameterType="string" resultMap="commentResultMap_postgres"&gt;<BR />&nbsp;&nbsp;&nbsp; select *<BR />&nbsp;&nbsp;&nbsp; from ACT_HI_COMMENT<BR />&nbsp;&nbsp;&nbsp; where PROC_INST_ID_ = #{processInstanceId,jdbcType=BINARY}<BR />&nbsp;&nbsp;&nbsp; order by TIME_ desc<BR />&nbsp; &lt;/select&gt;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Wed, 12 Oct 2011 13:25:10 GMT lichtin 2011-10-12T13:25:10Z PostgreSQL-specific SQL configuration https://connect.hyland.com/t5/alfresco-archive/postgresql-specific-sql-configuration/m-p/59368#M36490 For selectCommentsByProcessInstanceId_postgres the type is set as BINARY. Is this required or a typo?&lt;select id="selectCommentsByProcessInstanceId" parameterType="string" resultMap="commentResultMap"&gt;&nbsp;&nbsp;&nbsp; select *&nbsp;&nbsp;&nbsp; from ACT_HI_COMMENT&nbsp;&nbsp;&nbsp; where PROC_INST_ID_ = #{processInstanceId,jdbcType=VARC Wed, 12 Oct 2011 13:25:10 GMT https://connect.hyland.com/t5/alfresco-archive/postgresql-specific-sql-configuration/m-p/59368#M36490 lichtin 2011-10-12T13:25:10Z Re: PostgreSQL-specific SQL configuration https://connect.hyland.com/t5/alfresco-archive/postgresql-specific-sql-configuration/m-p/59369#M36491 <HTML><HEAD></HEAD><BODY><SPAN>Hmm strange, yes I think it's a typo.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Sat, 15 Oct 2011 20:05:42 GMT https://connect.hyland.com/t5/alfresco-archive/postgresql-specific-sql-configuration/m-p/59369#M36491 trademak 2011-10-15T20:05:42Z