context-mapper.xml

마이바티스에서 멀티 db 설정하기 위해서 2개의 db 설정 파일입니다.

데이터베이스트 티베로와 postgresq입니다. 티베로 db를 사용하기 위해서 tibero mapper 클래스를 만들어서 설정을 하였습니다.

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">

    <!-- 실행환경에서 빈이름 참조(EgovAbstractDAO) -->
	<bean id="egov.lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true" />
    
	<!-- postgresql db -->
	<bean id="egov.sqlSession" class="org.mybatis.spring.SqlSessionFactoryBean">		
		<property name="dataSource" ref="egov.postgreDataSource"/>
		<property name="configLocation" value="classpath:/egovframework/sqlmap/mapper/postgre/config/mapper-config.xml" />
		<property name="mapperLocations">
			<list>
				<value>classpath:/egovframework/sqlmap/mapper/postgre/invako/**/*.xml</value>
			</list>
		</property>
	</bean>

	<!-- Mybatis Session Template -->
	<bean id="egov.sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg ref="egov.sqlSession"/>
	</bean>

	<!-- MapperConfigurer setup for MyBatis Database Layer with @Mapper("deptMapper") in DeptMapper Interface -->
 	<bean class="egovframework.rte.psl.dataaccess.mapper.MapperConfigurer">
 	     <property name="basePackage" value="egovframework.invako.**.mybatis.mapper" />
 	     <property name="sqlSessionFactoryBeanName" value="egov.sqlSession"/>
	</bean>
	
 	 <alias name="egov.sqlSession" alias="sqlSession" />
 	 
 	 
 	 <!-- tibero db -->
	<bean id="sqlSessionTibero" class="org.mybatis.spring.SqlSessionFactoryBean">		
		<property name="dataSource" ref="egov.tiberoDataSource"/>
		<property name="configLocation" value="classpath:/egovframework/sqlmap/mapper/postgre/config/mapper-config.xml" />
		<property name="mapperLocations">
			<list>
				<value>classpath:/egovframework/sqlmap/mapper/tibero/invako/**/*.xml</value>
			</list>
		</property> 
	</bean>

	<!-- Tibero Mapper Interface -->
 	<bean class="egovframework.rte.psl.dataaccess.mapper.MapperConfigurer">
 	     <property name="basePackage" value="egovframework.invako.**.mybatisTibero.mapper" />
 	     <property name="sqlSessionFactoryBeanName" value="sqlSessionTibero"/>
 	     <property name="annotationClass" value="egovframework.invako.util.TiberoMapper"/>
	</bean>
 	 
 	 
</beans>