단풍의 블로그

로그인

Mybatis v3.2.1 에서 프로시져 호출 문제

단풍

<?xml version="1.0" encoding="UTF-8" ?> 
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="persistence.mysql.DocumentsMapper">

	<select id="BoardList" parameterType="requestBoardListVO"
		resultType="responseBoardListVO" statementType="CALLABLE">
		{
			CALL `SP_BOARD_LIST` (
				#{b mode=IN, jdbcType=INTEGER},
				#{c mode=IN, jdbcType=INTEGER},
				#{LISTSize mode=IN, jdbcType=INTEGER},
				#{p mode=IN, jdbcType=INTEGER},
				#{NOTICECount mode=IN, jdbcType=INTEGER},
				#{TOTALCOUNT mode=OUT, jdbcType=INTEGER},
				#{TOTALPAGE mode=OUT, jdbcType=INTEGER},
				#{WRITE_TODAY_COUNT mode=OUT, jdbcType=INTEGER},
				#{BOARDNAME mode=OUT, jdbcType=VARCHAR}
			)
		}
	</select>

</mapper>

<?xml version="1.0" encoding="UTF-8" ?> 
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="persistence.mysql.DocumentsMapper">

	<select id="BoardList" parameterType="requestBoardListVO"
		resultType="responseBoardListVO" statementType="CALLABLE">
		{
			CALL `SP_BOARD_LIST` (
				#{b, mode=IN, jdbcType=INTEGER},
				#{c, mode=IN, jdbcType=INTEGER},
				#{LISTSize, mode=IN, jdbcType=INTEGER},
				#{p, mode=IN, jdbcType=INTEGER},
				#{NOTICECount, mode=IN, jdbcType=INTEGER},
				#{TOTALCOUNT, mode=OUT, jdbcType=INTEGER},
				#{TOTALPAGE, mode=OUT, jdbcType=INTEGER},
				#{WRITE_TODAY_COUNT, mode=OUT, jdbcType=INTEGER},
				#{BOARDNAME, mode=OUT, jdbcType=VARCHAR}
			)
		}
	</select>

</mapper>

Mybatis v3.2.1 하위 버전에서는 파라미터 다음에 ,(콤마)를 안줘도 댔지만 버전이 올라가면서 콤마를 추가 해줘야 동작한다.
VO 매핑이 안되서 한참 두리번 두리번...T_T

이 게시물을