{"id":1554,"date":"2014-06-16T02:37:57","date_gmt":"2014-06-16T02:37:57","guid":{"rendered":"http:\/\/brain.payzip.co.kr\/?p=1554"},"modified":"2014-06-16T02:37:57","modified_gmt":"2014-06-16T02:37:57","slug":"mybatis-%ec%bf%bc%eb%a6%ac-%eb%b0%98%ec%98%81spring-mybatis-%ed%99%98%ea%b2%bd%ec%97%90%ec%84%9c-xml-%ed%8c%8c%ec%9d%bc-%eb%b3%80%ea%b2%bd%ec%8b%9c-%ec%84%9c%eb%b2%84-%ec%9e%ac%ec%8b%9c%ec%9e%91","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=1554","title":{"rendered":"[mybatIs \ucffc\ub9ac \ubc18\uc601]Spring + mybatIs \ud658\uacbd\uc5d0\uc11c xml \ud30c\uc77c \ubcc0\uacbd\uc2dc \uc11c\ubc84 \uc7ac\uc2dc\uc791 \uc5c6\uc774 \ubc18\uc601 \ubc29\ubc95"},"content":{"rendered":"

 <\/p>\n

\ucd9c\ucc98 : http:\/\/sbcoba.tistory.com\/16<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\uc694\uc998 ORM\uc73c\ub85c\ub294 \ud558\uc774\ubc84\ub124\uc774\ud2b8, JPA\ub4f1 \ub9ce\uc774 \uc0ac\uc6a9\ud558\uace0 \uc788\uc73c\ub098, \uc5ed\uc2dc SI \ucabd\uc740 mybatis(ibatis)\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n

\ubb38\uc81c\ub294 mybatis\ub294 xml\ub85c sql\uc744 \uad00\ub9ac\ud558\uace0 \uc788\ub294\ub370 \ubcf4\ud1b5 \uc870\uae08 \ubc14\uafc0\ub54c \ub9c8\ub2e4 \uc11c\ubc84\ub97c \uc7ac\uad6c\ub3d9 \uc2dc\ucf1c\uc57c \ub418\ub294 \ubb38\uc81c\uac00 \ub41c\ub2e4.<\/p>\n

\uc2dc\uc2a4\ud15c\uc774 \ud074 \uacbd\uc6b0 \uc7ac\uc2dc\uc791\uc2dc \uc624\ub79c \uc2dc\uac04 \uac78\ub9ac\uace0 session \uc0ac\uc6a9\uc2dc \ub610 \ub85c\uadf8\uc778\uc744 \ud574\uc57c \ud558\ub294\ub4ef \uac1c\ubc1c\uc758 \ud750\ub984\uc774 \ub04a\uc5b4\uc9c0\ub294 \ubb38\uc81c\uac00 \ub9ce\uc774 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n

\uc608\uc804\uc5d0 ibatis\ub97c \uc0ac\uc6a9 \ud588\uc744\uc2dc\uc5d0\ub3c4 \uadf8\ub7f0 \ubd80\ubd84\uc774 \ub9ce\uc774 \ubd88\ud3b8\ud588\uc5c8\ub294\ub370, \uc608\uc804 \ub300\uc6b0\uc815\ubcf4\uc2dc\uc2a4\ud15c\uc758 JCF \ud504\ub808\uc784\uc6cc\ud06c\uc5d0\uc11c \uc0ac\uc6a9\ub41c\ub2e4\uace0 Refresh \ub418\ub294\u00a0\ud074\ub798\uc2a4 \uc18c\uc2a4\uac00 \ud55c\ubc88 \uacf5\uac1c \ub41c\uc801\uc774 \uc788\uc5c8\ub2e4. ( \uba87\ub144\uc804\uc778\uc9c0 \uae30\uc5b5\uc740 \uc548\ub098\uc9c0\ub9cc,\u00a0\ub2f9\uc2dc \uc778\ud130\ub137 \uac80\uc0c9\uc73c\ub85c \ucc3e\uc558\uc5c8\ub2e4. )<\/p>\n

\uadf8\uac83\uc774 \ubc84\uc804\uc774 \ubb38\uc81c\uc778\uc9c0 \ubc14\ub85c \uc0ac\uc6a9\uc774 \uc548\ub418\uc5b4\uc11c \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5\ud558\uace0 \uc0ac\uc6a9\uc744 \uc798\uc0ac\uc6a9 \ud588\uc5c8\ub2e4.<\/p>\n

\uadf8\ub7f0\ub370 \uc9c0\uae08 \ud504\ub85c\uc81d\ud2b8\uac00 mybatis\ub85c \uc9c4\ud589\ud558\uae30 \ub54c\ubb38\uc5d0 \uc608\uc804\uacfc \uac19\uc740 \ubd88\ud3b8\ud568\uc774 \ub610 \uc0dd\uae30\uac8c \ub418\uc5c8\ub294\ub370, \uc774 \ubc88\uc5d0\ub294 \uadf8 \uc18c\uc2a4\ub97c mybatis\uc5d0 \ub9de\ub3c4\ub85c \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5 \ud558\uae30\ub85c \ud588\ub2e4.<\/p>\n

\uc77c\ub2e8 \uc0ac\uc804 \uc870\uac74\uc740<\/p>\n

JDK 1.5 \uc774\uc0c1<\/b>,\u00a0Spring, mybatis,\u00a0spring-mybatis<\/b>\u00a0\ub77c\uc774\ube0c\ub7ec\ub9ac\uac00 \uc124\uce58\ub418\uc5b4 \uc788\ub294 \ud658\uacbd\uc5d0\uc11c\ub9cc \ub41c\ub2e4.<\/p>\n

 <\/p>\n

\uc77c\ub2e8 \uae30\uc874\u00a0Spring \uc5d0\uc11c mybatis \uc124\uc815\uc744 \ubcf4\uaca0\ub2e4.<\/p>\n

\ubcf4\ud1b5 sqlSessionFactory\ub97c \uc774\ub807\uac8c \uc124\uc815 \ud55c\ub2e4.<\/p>\n

\n

<bean id=”sqlSessionFactory” p:mapperLocations=”classpath*:\ud328\ud0a4\uc9c0\uacbd\ub85c\/**\/mapper.xml<\/b>” p:configLocation=”classpath:\/MapperConfig.xml” p:dataSource-ref=”dataSource”\/><\/p>\n<\/div>\n

classpath*:\ud328\ud0a4\uc9c0\uacbd\ub85c\/**\/mapper.xml\u00a0<\/b>\u00a0<-<\/b>\uc774\ubd80\ubd84\uc774 \uc7ac\ub85c\ub529 \ub420 xml \ud30c\uc77c\uacbd\ub85c\u00a0( \uc790\uc2e0\uc758 \ud504\ub85c\uc81d\ud2b8\uc5d0 \ub530\ub77c \ubcc0\uacbd )<\/b><\/p>\n

\uc774\ubd80\ubd84\uc5d0\uc11c\u00a0\uad75\uac8c \ud45c\uc2dc\ud55c class<\/b>\u00a0\ubd80\ubd84\ub9cc \uc0c8\ub85c \ub9cc\ub4e0 \ud074\ub798\uc2a4\ub85c \ubc14\uafb8\uba74 \ubaa8\ub4e0\uac8c \ud574\uacb0\ub41c\ub2e4.<\/p>\n

\n

<bean id=”sqlSessionFactory” p:mapperLocations=”classpath*:\ud328\ud0a4\uc9c0\uacbd\ub85c\/**\/mapper.xml<\/b>” p:configLocation=”classpath:\/MapperConfig.xml” p:dataSource-ref=”dataSource”\u00a0\/><\/p>\n<\/div>\n

RefreshableSqlSessionFactoryBean.java<\/b><\/p>\n

\n

import java.io.IOException;<\/p>\n

import java.lang.reflect.InvocationHandler;<\/p>\n

import java.lang.reflect.Method;<\/p>\n

import java.lang.reflect.Proxy;<\/p>\n

import java.util.ArrayList;<\/p>\n

import java.util.HashMap;<\/p>\n

import java.util.List;<\/p>\n

import java.util.Map;<\/p>\n

import java.util.Timer;<\/p>\n

import java.util.TimerTask;<\/p>\n

 <\/p>\n

import org.apache.commons.logging.Log;<\/p>\n

import org.apache.commons.logging.LogFactory;<\/p>\n

import org.apache.ibatis.session.SqlSessionFactory;<\/p>\n

import org.mybatis.spring.SqlSessionFactoryBean;<\/p>\n

import org.springframework.beans.factory.DisposableBean;<\/p>\n

import org.springframework.core.io.Resource;<\/p>\n

 <\/p>\n

import java.util.concurrent.locks.Lock;<\/p>\n

import java.util.concurrent.locks.ReentrantReadWriteLock;<\/p>\n

 <\/p>\n

\/**<\/p>\n

* mybatis mapper \uc790\ub3d9 \uac10\uc9c0 \ud6c4 \uc790\ub3d9\uc73c\ub85c \uc11c\ubc84 \uc7ac\uc2dc\uc791\uc774 \ud544\uc694 \uc5c6\uc774 \ubc18\uc601<\/p>\n

*<\/p>\n

* @author sbcoba<\/p>\n

*<\/p>\n

*\/<\/p>\n

public class RefreshableSqlSessionFactoryBean extends SqlSessionFactoryBean implements DisposableBean {<\/p>\n

 <\/p>\n

private static final Log log = LogFactory .getLog(RefreshableSqlSessionFactoryBean.class);<\/p>\n

 <\/p>\n

private SqlSessionFactory proxy;<\/p>\n

private int interval = 500;<\/p>\n

 <\/p>\n

private Timer timer;<\/p>\n

private TimerTask task;<\/p>\n

 <\/p>\n

private Resource[] mapperLocations;<\/p>\n

 <\/p>\n

\/**<\/p>\n

* \ud30c\uc77c \uac10\uc2dc \uc4f0\ub808\ub4dc\uac00 \uc2e4\ud589\uc911\uc778\uc9c0 \uc5ec\ubd80.<\/p>\n

*\/<\/p>\n

private boolean running = false;<\/p>\n

 <\/p>\n

private final ReentrantReadWriteLock rwl = new ReentrantReadWriteLock();<\/p>\n

private final Lock r = rwl.readLock();<\/p>\n

private final Lock w = rwl.writeLock();<\/p>\n

 <\/p>\n

public void setMapperLocations(Resource[] mapperLocations) {<\/p>\n

super.setMapperLocations(mapperLocations);<\/p>\n

this.mapperLocations = mapperLocations;<\/p>\n

}<\/p>\n

 <\/p>\n

public void setInterval(int interval) {<\/p>\n

this.interval = interval;<\/p>\n

}<\/p>\n

 <\/p>\n

\/**<\/p>\n

*<\/p>\n

* @throws Exception<\/p>\n

*\/<\/p>\n

public void refresh() throws Exception {<\/p>\n

if (log.isInfoEnabled()) {<\/p>\n

log.info(“refreshing sqlMapClient.”);<\/p>\n

}<\/p>\n

w.lock();<\/p>\n

try {<\/p>\n

super.afterPropertiesSet();<\/p>\n

 <\/p>\n

} finally {<\/p>\n

w.unlock();<\/p>\n

}<\/p>\n

}<\/p>\n

 <\/p>\n

\/**<\/p>\n

* \uc2f1\uae00\ud1a4 \uba64\ubc84\ub85c SqlMapClient \uc6d0\ubcf8 \ub300\uc2e0 \ud504\ub85d\uc2dc\ub85c \uc124\uc815\ud558\ub3c4\ub85d \uc624\ubc84\ub77c\uc774\ub4dc.<\/p>\n

*\/<\/p>\n

public void afterPropertiesSet() throws Exception {<\/p>\n

super.afterPropertiesSet();<\/p>\n

 <\/p>\n

setRefreshable();<\/p>\n

}<\/p>\n

 <\/p>\n

private void setRefreshable() {<\/p>\n

proxy = (SqlSessionFactory) Proxy.newProxyInstance(<\/p>\n

SqlSessionFactory.class.getClassLoader(),<\/p>\n

new Class[] { SqlSessionFactory.class },<\/p>\n

new InvocationHandler() {<\/p>\n

public Object invoke(Object proxy, Method method,<\/p>\n

Object[] args) throws Throwable {<\/p>\n

\/\/ log.debug(“method.getName() : ” + method.getName());<\/p>\n

return method.invoke(getParentObject(), args);<\/p>\n

}<\/p>\n

});<\/p>\n

 <\/p>\n

task = new TimerTask() {<\/p>\n

private Map<Resource, Long> map = new HashMap<Resource, Long>();<\/p>\n

 <\/p>\n

public void run() {<\/p>\n

if (isModified()) {<\/p>\n

try {<\/p>\n

refresh();<\/p>\n

} catch (Exception e) {<\/p>\n

log.error(“caught exception”, e);<\/p>\n

}<\/p>\n

}<\/p>\n

}<\/p>\n

 <\/p>\n

private boolean isModified() {<\/p>\n

boolean retVal = false;<\/p>\n

 <\/p>\n

if (mapperLocations != null) {<\/p>\n

for (int i = 0; i < mapperLocations.length; i++) {<\/p>\n

Resource mappingLocation = mapperLocations[i];<\/p>\n

retVal |= findModifiedResource(mappingLocation);<\/p>\n

}<\/p>\n

}<\/p>\n

 <\/p>\n

return retVal;<\/p>\n

}<\/p>\n

 <\/p>\n

private boolean findModifiedResource(Resource resource) {<\/p>\n

boolean retVal = false;<\/p>\n

List<String> modifiedResources = new ArrayList<String>();<\/p>\n

 <\/p>\n

try {<\/p>\n

long modified = resource.lastModified();<\/p>\n

 <\/p>\n

if (map.containsKey(resource)) {<\/p>\n

long lastModified = ((Long) map.get(resource))<\/p>\n

.longValue();<\/p>\n

 <\/p>\n

if (lastModified != modified) {<\/p>\n

map.put(resource, new Long(modified));<\/p>\n

modifiedResources.add(resource.getDescription());<\/p>\n

retVal = true;<\/p>\n

}<\/p>\n

} else {<\/p>\n

map.put(resource, new Long(modified));<\/p>\n

}<\/p>\n

} catch (IOException e) {<\/p>\n

log.error(“caught exception”, e);<\/p>\n

}<\/p>\n

if (retVal) {<\/p>\n

if (log.isInfoEnabled()) {<\/p>\n

log.info(“modified files : ” + modifiedResources);<\/p>\n

}<\/p>\n

}<\/p>\n

return retVal;<\/p>\n

}<\/p>\n

};<\/p>\n

 <\/p>\n

timer = new Timer(true);<\/p>\n

resetInterval();<\/p>\n

 <\/p>\n

}<\/p>\n

 <\/p>\n

private Object getParentObject() throws Exception {<\/p>\n

r.lock();<\/p>\n

try {<\/p>\n

return super.getObject();<\/p>\n

 <\/p>\n

} finally {<\/p>\n

r.unlock();<\/p>\n

}<\/p>\n

}<\/p>\n

 <\/p>\n

public SqlSessionFactory getObject() {<\/p>\n

return this.proxy;<\/p>\n

}<\/p>\n

 <\/p>\n

public Class<? extends SqlSessionFactory> getObjectType() {<\/p>\n

return (this.proxy != null ? this.proxy.getClass()<\/p>\n

: SqlSessionFactory.class);<\/p>\n

}<\/p>\n

 <\/p>\n

public boolean isSingleton() {<\/p>\n

return true;<\/p>\n

}<\/p>\n

 <\/p>\n

public void setCheckInterval(int ms) {<\/p>\n

interval = ms;<\/p>\n

 <\/p>\n

if (timer != null) {<\/p>\n

resetInterval();<\/p>\n

}<\/p>\n

}<\/p>\n

 <\/p>\n

private void resetInterval() {<\/p>\n

if (running) {<\/p>\n

timer.cancel();<\/p>\n

running = false;<\/p>\n

}<\/p>\n

if (interval > 0) {<\/p>\n

timer.schedule(task, 0, interval);<\/p>\n

running = true;<\/p>\n

}<\/p>\n

}<\/p>\n

 <\/p>\n

public void destroy() throws Exception {<\/p>\n

timer.cancel();<\/p>\n

}<\/p>\n

}<\/p>\n<\/div>\n

 <\/p>\n

 <\/p>\n

\ub9cc\uc57d\uc5d0 \uc7ac\ub85c\ub529 \ub418\ub294 \uc2dc\uac04\uc744 \ubc14\uafb8\uace0 \uc2f6\uc73c\uba74<\/p>\n

\n

<bean id=”sqlSessionFactory” p:mapperLocations=”classpath*:\ud328\ud0a4\uc9c0\uacbd\ub85c<\/b>\/**\/mapper.xml” :configLocation=”classpath:\/MapperConfig.xml” p:dataSource-ref=”dataSource”\u00a0p:interval=”1000″<\/span><\/b>\u00a0\/><\/p>\n<\/div>\n

p:interval=”1000″ \uc774\ubd80\ubd84\uc744 \uc218\uce58\ub97c \uc815\ud574\uc8fc\uba74\ub41c\ub2e4. ( \ub514\ud3f4\ud2b8\ub294 500,\u00a0\ub2e8\uc704 ms )<\/p>\n

 <\/p>\n

 <\/p>\n

\uc774\uc81c \uc124\uc815\uc744 \uc11c\ubc84\ub97c \uc2dc\uc791\ud574\uc11c \uc704\uc5d0 \ub85c\ucf00\uc774\uc158 \ud574\ub2f9\ud558\ub294 mapper.xml ( sql\uc774 \uc788\ub294 xml\u00a0, \uc124\uc815\uc5d0 \ub530\ub77c \ub2e4\ub984)\uc5d0\uc11c<\/p>\n

sql\uc744 \ubc14\uafd4 \ubcf4\uc790 \uadf8\ub9ac\uace0 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c \ubc14\ub010\uc9c0 \ud655\uc778\ud574\ubcf4\uc790<\/p>\n

\ud070 \ubb38\uc81c\uac00 \uc5c6\ub2e4\uba74 \ubc18\uc601\ub420\uac83\uc774\ub77c\uace0 \uc0dd\uac01\ub41c\ub2e4.<\/p>\n

 <\/p>\n

 <\/p>\n

\uc544 \ub2e8 \uc6b4\uc601 \uc2dc\uc2a4\ud15c\uc5d0 \uc0ac\uc6a9\uc740 \ubcf4\uc7a5 \ubabb\ud569\ub2c8\ub2e4~ \uac1c\ubc1c\uc2dc\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud558\uc138\uc694~<\/b><\/p>\n

 <\/p>\n

\uc774 \uc18c\uc2a4\ub294 \uc608\uc804\uc5d0 \uc778\ud130\ub137\uc5d0\uc11c \ub098\ub3cc\ub358\u00a0RefreshableSqlMapClientFactoryBean \uc18c\uc2a4\ub97c \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5\ud55c \uc18c\uc2a4\uc778\ub370 \ubb38\uc81c\uac00 \uc788\ub2e4\uba74 \uc5f0\ub77d\uc8fc\uc2dc\uae38\ubc14\ub78d\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

  \ucd9c\ucc98 : http:\/\/sbcoba.tistory.com\/16       \uc694\uc998 ORM\uc73c\ub85c\ub294 \ud558\uc774\ubc84\ub124\uc774\ud2b8, JPA\ub4f1 \ub9ce\uc774 \uc0ac\uc6a9\ud558\uace0 \uc788\uc73c\ub098, \uc5ed\uc2dc SI \ucabd\uc740 mybatis(ibatis)\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ub41c\ub2e4. \ubb38\uc81c\ub294 mybatis\ub294 xml\ub85c sql\uc744 \uad00\ub9ac\ud558\uace0 \uc788\ub294\ub370 \ubcf4\ud1b5 \uc870\uae08 \ubc14\uafc0\ub54c \ub9c8\ub2e4… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1554"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1554"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1554\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}