Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer

Springboot项目，使用postgresql数据库，mybatis做持久层框架，

 <select id="select" resultMap="BaseResultMap" parameterType="com.vo.TestVo">

         select

             <include refid="Base_Column_List" />

         from test

         where state='2'

         <if test="comCode != null" >

             and com_code=${comCode}

         </if>

     </select>

comcode的形式如：'1100'

执行查询时报错:

### The error may exist in file [D:\workspaceAll\eclipseWorkspace\test\target\classes\mapper\custom\test\QcTestDao.xml]

### The error may involve com.dao.TestDao.select-Inline

### The error occurred while setting parameters

### SQL: select          id, comcode,name   from test   where state='2'        and com_code=00000000

### Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer

  建议：No operator matches the given name and argument type(s). You might need to add explicit type casts.

  位置：286

; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer

  建议：No operator matches the given name and argument type(s). You might need to add explicit type casts.

  位置：286] with root cause

org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer

  建议：No operator matches the given name and argument type(s). You might need to add explicit type casts.

  位置：286

解决方法：

 <if test="comCode != null" >

       and com_code=#{comCode,jdbcType=VARCHAR}

 </if>

Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer的相关教程结束。