context-datasource.xml 설정 파일

/* context-datasource.xml */

멀티 DB 환경 설정 파일입니다. 

java

닫기 줄바꿈

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
‌xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
‌xmlns:util="http://www.springframework.org/schema/util"
‌xmlns:context="http://www.springframework.org/schema/context"
‌xmlns:jdbc="http://www.springframework.org/schema/jdbc"
‌xmlns:jpa="http://www.springframework.org/schema/data/jpa"
‌xmlns:tx="http://www.springframework.org/schema/tx"
‌xsi:schemaLocation="http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.3.xsd
‌‌http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
‌‌http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
‌‌http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.8.xsd
‌‌http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
‌‌http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.3.xsd">

​​​​​<!-- 환경설정 기본정보를 globals.properties 에서 참조하도록 propertyConfigurer 설정  -->
​​​​<util:properties id="propertyConfigurer" location="classpath:/egovframework/egovProps/globals.properties"/>
‌<context:property-placeholder properties-ref="propertyConfigurer" />
‌
​​
‌<bean id="egov.propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
​​​​​​​​<property name="locations">
​​​​​​​​​​​​<list>
​​​​​​​​​​​​​​​​<value>classpath*:/egovframework/egovProps/globals.properties</value>
​​​​​​​​​​​​</list>
​​​​​​​​</property>
​​​​</bean>

‌<!-- DataSource --> 
‌<alias name="postgreDataSource" alias="egov.postgreDataSource" />
‌<alias name="tiberoDataSource" alias="egov.tiberoDataSource" />
‌
‌<!-- 개발 -->
‌<beans profile="DEV">
‌​​​​
‌​​​​<!-- postgreSql -->
‌​​​​<bean id="postgreDataSource-Spied" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
‌‌‌<property name="driverClassName" value="${Globals.postgresql.DriverClassName}"/>
‌‌‌<property name="url" value="${Globals.postgresql.Url}" />
‌‌‌<property name="username" value="${Globals.postgresql.UserName}"/>
‌‌‌<property name="password" value="${Globals.postgresql.Password}"/>
‌‌</bean>
‌
‌‌<bean id="postgreDataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
‌‌​​​​<constructor-arg ref="postgreDataSource-Spied"/>
‌‌‌<property name="logFormatter">
‌‌‌‌<bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">
‌‌‌‌‌<property name="loggingType" value="MULTI_LINE"/>
‌‌‌‌‌<property name="sqlPrefix" value="SQL   :"/>
‌‌‌‌</bean>
‌‌‌</property>
‌‌</bean>
​
​​​​​​​​<!-- tibero -->
‌‌<bean id="tiberoDataSource-Spied" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
‌‌‌<property name="driverClassName" value="${Globals.tibero.DriverClassName}"/>
‌‌‌<property name="url" value="${Globals.tibero.Url}" />
‌‌‌<property name="username" value="${Globals.tibero.UserName}"/>
‌‌‌<property name="password" value="${Globals.tibero.Password}"/>
‌‌</bean>
‌
‌‌<bean id="tiberoDataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
‌‌​​​​<constructor-arg ref="tiberoDataSource-Spied"/>
‌‌‌<property name="logFormatter">
‌‌‌‌<bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">
‌‌‌‌‌<property name="loggingType" value="MULTI_LINE"/>
‌‌‌‌‌<property name="sqlPrefix" value="SQL   :"/>
‌‌‌‌</bean>
‌‌‌</property>
‌‌</bean>
‌
‌‌‌‌‌‌​
‌</beans>
‌
‌<!-- 운영 -->
‌<beans profile="RUN">
‌​​​​
‌​​​​<!-- postgreSql -->
‌​​​​<bean id="postgreDataSource-Spied" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
‌‌‌<property name="driverClassName" value="${Globals.postgresql.DriverClassName}"/>
‌‌‌<property name="url" value="${Globals.postgresql.Url}" />
‌‌‌<property name="username" value="${Globals.postgresql.UserName}"/>
‌‌‌<property name="password" value="${Globals.postgresql.Password}"/>
‌‌</bean>
‌
‌‌<bean id="postgreDataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
‌‌​​​​<constructor-arg ref="postgreDataSource-Spied"/>
‌‌‌<property name="logFormatter">
‌‌‌‌<bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">
‌‌‌‌‌<property name="loggingType" value="MULTI_LINE"/>
‌‌‌‌‌<property name="sqlPrefix" value="SQL   :"/>
‌‌‌‌</bean>
‌‌‌</property>
‌‌</bean>
​
​​​​​​​​<!-- tibero -->
‌‌<bean id="tiberoDataSource-Spied" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
‌‌‌<property name="driverClassName" value="${Globals.tibero.DriverClassName}"/>
‌‌‌<property name="url" value="${Globals.tibero.Url}" />
‌‌‌<property name="username" value="${Globals.tibero.UserName}"/>
‌‌‌<property name="password" value="${Globals.tibero.Password}"/>
‌‌</bean>
‌
‌‌<bean id="tiberoDataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
‌‌​​​​<constructor-arg ref="tiberoDataSource-Spied"/>
‌‌‌<property name="logFormatter">
‌‌‌‌<bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">
‌‌‌‌‌<property name="loggingType" value="MULTI_LINE"/>
‌‌‌‌‌<property name="sqlPrefix" value="SQL   :"/>
‌‌‌‌</bean>
‌‌‌</property>
‌‌</bean>
‌
‌‌‌‌‌‌​
‌</beans>
‌
‌
​​​
​​​​
</beans>