[spring framework] 전자정부프레임워크 다중 DB 사용 multi datasource 셋팅

@ globals.properties

#mysql
AppConf.db.DbType = mysql
AppConf.db.DriverClassName=com.mysql.cj.jdbc.Driver
AppConf.db.Url=jdbc:mysql://127.0.0.1:3306/mysql
AppConf.db.UserName=mysql
AppConf.db.Password=mysql

#postgresql
AppConf.dbp.DbType = postgresql
AppConf.dbp.DriverClassName=org.postgresql.Driver
AppConf.dbp.Url=jdbc:postgresql://127.0.0.1:5432/postgres
AppConf.dbp.UserName=postgres
AppConf.dbp.Password=postgres


@ context-datasource.xml

<!-- MySQL --> 
<bean id="dataSource-mysql" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${AppConf.db.DriverClassName}"/>
<property name="url" value="${AppConf.db.Url}" />
<property name="username" value="${AppConf.db.UserName}"/>
<property name="password" value="${AppConf.db.Password}"/>
</bean>

<!-- PostgreSQL -->
<bean id="dataSource-postgres" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${AppConf.dbp.DriverClassName}"/>
<property name="url" value="${AppConf.dbp.Url}" />
<property name="username" value="${AppConf.dbp.UserName}"/>
<property name="password" value="${AppConf.dbp.Password}"/>
</bean>


@ context-mybatis.xml

<bean id="sqlSessionMysql" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource-mysql" />
<property name="configLocation" value="classpath:/config/mybatis/mybatis-config.xml" />
<property name="mapperLocations" value="classpath:/config/mybatis/mappers/mysql/*/*.xml" /> 
</bean>

<bean id="scannerMysql" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.namu.**.mapper"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionMysql"/>
</bean>

<bean id="sqlSessionPostgres" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource-postgres" />
<property name="configLocation" value="classpath:/config/mybatis/mybatis-config-postgres.xml" />
<property name="mapperLocations" value="classpath:/config/mybatis/mappers/postgres/*/*.xml" />
</bean>

<bean id="sqlSessionTemplatePostgres" class="org.mybatis.spring.SqlSessionTemplate" destroy-method="clearCache">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionPostgres" />
</bean>

<bean id="scannerPostgres" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.test.**.mapper"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionPostgres"/>
</bean>

<bean class="egovframework.rte.psl.dataaccess.mapper.MapperConfigurer">
<property name="basePackage" value="com.namu.**.mapper, com.test.**.mapper" />
</bean>

<context:component-scan base-package="com.namu.**.service, com.test.**.service"/>


@ context-transaction.xml

<bean id="txManagerMysql" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource-mysql"/>
</bean>

<bean id="txManagerPostgre" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource-postgres"/>
</bean>

<tx:advice id="txAdviceMysql" transaction-manager="txManagerMysql">
   <tx:attributes>  
       <tx:method name="*" propagation="REQUIRED" rollback-for="Exception"/>
   </tx:attributes>
</tx:advice>

<tx:advice id="txAdvicePostgre" transaction-manager="txManagerPostgre">
   <tx:attributes>
       <tx:method name="*" propagation="REQUIRED" rollback-for="Exception"/>
   </tx:attributes>
</tx:advice>

@ logback.xml

<logger name="com" level="DEBUG">
<appender-ref ref="CONSOLE" />
</logger>