Mybatis 다중 Datasource 설정

Mybatis 다중 Datasource 설정

통계치를 다른 서버 DB에 적재 할 일이 생겨 추가적으로 작업.

(소스상에 나와있는 수치는 예제이므로 절대치는 아닙니다.)


database.properties

  1. ## 이전접속 DB
  2. jdbc.main.driver=xxxx
  3. jdbc.main.url=xxxx
  4. jdbc.main.user=xxx
  5. jdbc.main.password=xxxx
  7. ## 신규접속 DB
  8. jdbc.main.driver.sts=yyyyy
  9. jdbc.main.url.sts=yyyyyyy
  10. jdbc.main.user.sts=yyyyy
  11. jdbc.main.password.sts=yyyyyy


context-datasource.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3. 	xmlns:context="http://www.springframework.org/schema/context"
  4. 	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
  5. 						http://www.springframework.org/schema/context	http://www.springframework.org/schema/context/spring-context-3.2.xsd">
  7. 	<context:property-placeholder location="classpath:config/properties/database.properties"/>
  8. 	
  9. 	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  10. 		<property name="driverClassName" value="${jdbc.main.driver}"/>
  11. 		<property name="url" value="${jdbc.main.url}" />
  12. 		<property name="username" value="${jdbc.main.user}"/>
  13. 		<property name="password" value="${jdbc.main.password}"/>
  14. 		<property name="validationQuery" value="select 1"/>
  15. 		<property name="timeBetweenEvictionRunsMillis" value="60000" />
  16. 		<property name="testWhileIdle" value="true" />
  17. 		<property name="maxWait" value="1000" />
  18. 		<property name="maxActive" value="200" />
  19. 		<property name="maxIdle" value="10" />
  20. 		<property name="minIdle" value="1" />
  21. 	</bean>
  23. 	
  24. 	<bean id="dataSourceSts" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  25. 		<property name="driverClassName" value="${jdbc.main.driver.sts}"/>
  26. 		<property name="url" value="${jdbc.main.url.sts}" />
  27. 		<property name="username" value="${jdbc.main.user.sts}"/>
  28. 		<property name="password" value="${jdbc.main.password.sts}"/>
  29. 		<property name="validationQuery" value="select 1"/>
  30. 		<property name="timeBetweenEvictionRunsMillis" value="60000" />
  31. 		<property name="testWhileIdle" value="true" />
  32. 		<property name="maxWait" value="1000" />
  33. 		<property name="maxActive" value="200" />
  34. 		<property name="maxIdle" value="10" />
  35. 		<property name="minIdle" value="1" />
  36. 	</bean>
  38. </beans>


context-mybatis.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3. 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4. 	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
  6. 	<!-- 이전DB -->
  7. 	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  8. 		<property name="dataSource" ref="dataSource" />
  9. 		<property name="configLocation" value="classpath:config/mybatis/mybatis-config.xml" />
  10. 		<property name="mapperLocations">
  11. 			<list>
  12. 				<value>classpath:sqlmap/**/*.xml</value>
  13. 			</list>
  14. 		</property>
  15. 	</bean>
  17. 	<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
  18. 		<constructor-arg ref="sqlSessionFactory"/>
  19. 	</bean>
  22. 	<!-- 신규DB -->
  23. 	<bean id="sqlSessionFactorySts" class="org.mybatis.spring.SqlSessionFactoryBean">
  24. 		<property name="dataSource" ref="dataSourceSts" />
  25. 		<property name="configLocation" value="classpath:config/mybatis/mybatis-config.xml" />
  26. 		<property name="mapperLocations">
  27. 			<list>
  28. 				<value>classpath:sqlmap/sts/*.xml</value>
  29. 			</list>
  30. 		</property>
  31. 	</bean>
  33. 	<bean id="sqlSessionTemplateSts" class="org.mybatis.spring.SqlSessionTemplate">
  34. 		<constructor-arg ref="sqlSessionFactorySts"/>
  35. 	</bean>
  37. </beans>


mybatis-config.xml

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
  4. <configuration>
  6. 	<settings>
  7. 		<setting name="cacheEnabled" value="false" />
  8. 		<setting name="useGeneratedKeys" value="true" />
  9. 		<setting name="callSettersOnNulls" value="true"/>
  10. 		<setting name="mapUnderscoreToCamelCase" value="true" />
  11. 		<setting name="defaultExecutorType" value="REUSE" />
  12. 		<setting name="localCacheScope" value="STATEMENT" />
  13. 	</settings>
  15. </configuration>


context-transaction.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3. 	xmlns:tx="http://www.springframework.org/schema/tx"
  4. 	xmlns:aop="http://www.springframework.org/schema/aop"
  5. 	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
  6. 						http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
  7. 						http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">
  8. 	
  9. 	<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  10. 		<property name="dataSource" ref="dataSource"/>
  11. 	</bean>
  13. 	<tx:advice id="txAdvice" transaction-manager="txManager">
  14. 		<tx:attributes>
  15. 			<tx:method name="select*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="true"/>
  16. 			<tx:method name="insert*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="false"/>
  17. 			<tx:method name="update*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="false"/>
  18. 			<tx:method name="delete*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="false"/>
  19. 			<tx:method name="save*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="false"/>
  20. 			<tx:method name="*" rollback-for="Exception"/>
  21. 		</tx:attributes>
  22. 	</tx:advice>
  24. 	<aop:config>
  25. 		<aop:pointcut id="requiredTx" expression="execution(* platform.stownbus.business..impl.*Impl.*(..))"/>
  26. 		<aop:advisor advice-ref="txAdvice" pointcut-ref="requiredTx" />
  27. 	</aop:config>
  30. 	
  31. 	<bean id="txManagerSts" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  32. 		<property name="dataSource" ref="dataSourceSts"/>
  33. 	</bean>
  35. 	<tx:advice id="txAdviceSts" transaction-manager="txManagerSts">
  36. 		<tx:attributes>
  37. 			<tx:method name="select*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="true"/>
  38. 			<tx:method name="insert*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="false"/>
  39. 			<tx:method name="update*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="false"/>
  40. 			<tx:method name="delete*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="false"/>
  41. 			<tx:method name="save*" propagation="REQUIRED" isolation="DEFAULT" rollback-for="Exception" read-only="false"/>
  42. 			<tx:method name="*" rollback-for="Exception"/>
  43. 		</tx:attributes>
  44. 	</tx:advice>
  46. 	<aop:config>
  47. 		<aop:pointcut id="requiredTxSts" expression="execution(* platform.stownbus.api..impl.*Impl.*(..))"/>
  48. 		<aop:advisor advice-ref="txAdviceSts" pointcut-ref="requiredTxSts" />
  49. 	</aop:config>
  51. </beans>


Dao

  1. // 기존 Dao
  2. @Repository("oldDao")
  3. public class OldDao extends AbstractDao {
  4. ..
  5. ..
  6. }
  7. // 신규Dao
  8. @Repository("newDao")
  9. public class NewDao extends AbstractStsDao {
  10. ..
  11. ..
  12. }

  1. // 이전 AbstractDao
  2. public class AbstractDao {
  3. 	@Autowired
  4. 	@Resource(name="sqlSessionTemplate")
  5. 	private SqlSessionTemplate sqlSessionTemplate;
  6. ..
  7. ..
  8. }
  10. // 신규 AbstractStsDao
  11. public class AbstractStsDao {
  12. 	@Autowired
  13. 	@Resource(name="sqlSessionTemplateSts")
  14. 	private SqlSessionTemplate sqlSessionTemplate;
  15. ..
  16. ..
  17. }


## 적용방법은 다양하나 현 시스템 기준으로 작성 하였습니다.

태그
첨부
profile

systemddc (조현)

    Gravatar란?

    Gravatar는 블로그에 글을 쓰거나 댓글을 쓰는 것 같은 일을 할 때 이름 옆에 나타나서

    사이트마다 당신을 따라다니는 그림이에요.

    Gravatar를 설정하고 난다음 블로그에 글을쓰거나 댓글을쓸경우 이메일 주소를 입력하고

    글을쓰게 되면 Gravatar설정된 자신의 프로필 이미지를 가져오게 됩니다.

    Gravatar설정 -> 링크

댓글









댓글작성