mybatis 캐쉬설정
- 작성자 :
- 김*덕
- 작성일 :
- 2017-11-13 09:33:51
- 조회수 :
- 1,166
- 구분 :
- 개발환경
- 진행상태 :
- 완료
Q
<cacheModel id="testList_D_Cache" type="LRU" readOnly="true" serialize="false">
<flushInterval seconds="1"/>
<property name="cache-size" value="50" />
<flushOnExecute statement="test.testDAO.insertTest_S"/>
<flushOnExecute statement="Test.testDAO.updateTest_S"/>
<flushOnExecute statement="Test.testDAO.deleteTest_S"/>
</cacheModel>
<select id="testDAO.selectTestList_D" cacheModel="selectTestList_D_Cache" parameterClass="testSerarchVO" resultClass="egovMap">
SELECT
CODE
, TYPE
, NAME
, VALUE
FROM CODE
WHERE 1=1
AND TYPE = #type#
AND (VALUE LIKE CONCAT('%',#searchKeyword#,'%')
OR NAME LIKE CONCAT('%',#searchKeyword#,'%'))
ORDER BY
<dynamic>
<isEqual property="type" compareValue="SC">
NAME ASC
</isEqual>
<isNotEqual property="type" compareValue="SC">
CAST(CODE AS UNSIGNED) DESC
</isNotEqual>
</dynamic>
</select>
위에꺼가 ibatis인데 저걸 mybatis에서 캐시 설정할려는데 어떻게 해야하나요??.. 아무리찾아보도 없네요
<flushInterval seconds="1"/>
<property name="cache-size" value="50" />
<flushOnExecute statement="test.testDAO.insertTest_S"/>
<flushOnExecute statement="Test.testDAO.updateTest_S"/>
<flushOnExecute statement="Test.testDAO.deleteTest_S"/>
</cacheModel>
<select id="testDAO.selectTestList_D" cacheModel="selectTestList_D_Cache" parameterClass="testSerarchVO" resultClass="egovMap">
SELECT
CODE
, TYPE
, NAME
, VALUE
FROM CODE
WHERE 1=1
AND TYPE = #type#
AND (VALUE LIKE CONCAT('%',#searchKeyword#,'%')
OR NAME LIKE CONCAT('%',#searchKeyword#,'%'))
ORDER BY
<dynamic>
<isEqual property="type" compareValue="SC">
NAME ASC
</isEqual>
<isNotEqual property="type" compareValue="SC">
CAST(CODE AS UNSIGNED) DESC
</isNotEqual>
</dynamic>
</select>
위에꺼가 ibatis인데 저걸 mybatis에서 캐시 설정할려는데 어떻게 해야하나요??.. 아무리찾아보도 없네요
A
안녕하세요 김재덕님
표준프레임워크센터입니다.
mybatis 캐시 설정은 mybatis 레퍼런스를 참고하시면 될 것 같습니다.
http://www.mybatis.org/mybatis-3/ko/sqlmap-xml.html#cache
감사합니다.
표준프레임워크센터입니다.
mybatis 캐시 설정은 mybatis 레퍼런스를 참고하시면 될 것 같습니다.
http://www.mybatis.org/mybatis-3/ko/sqlmap-xml.html#cache
감사합니다.