<resultMap id="voyageIdResult" type="java.lang.String" > <result column="voyage_id" property="voyageId" jdbcType="VARCHAR" /> </resultMap> <select id="findAll" resultMap="voyageIdResult" parameterType="java.lang.String"> select voyage_id from load_discharg where supplier_code = #{supplierCode}; </select>