82 lines
3.7 KiB
XML
82 lines
3.7 KiB
XML
<?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-3.0.xsd
|
|
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd">
|
|
<!--CTI DB (Oracle) -->
|
|
<bean id="dataSource_O_CTI" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
|
|
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
|
|
<property name="url" value="jdbc:oracle:thin:@172.168.30.3:1521/KIHASA"/>
|
|
<property name="username" value="KIHASA"/>
|
|
<property name="password" value="KIHASA"/>
|
|
<property name="defaultAutoCommit" value="true"/>
|
|
<property name="maxActive" value="5"/>
|
|
<property name="maxIdle" value="3"/>
|
|
<property name="maxWait" value="60000"/>
|
|
<property name="validationQuery" value="select 1 from dual"/>
|
|
<property name="testWhileIdle" value="true"/>
|
|
<property name="timeBetweenEvictionRunsMillis" value="1800000"/>
|
|
</bean>
|
|
|
|
<bean id="dataSource_CTI" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
|
|
<constructor-arg ref="dataSource_O_CTI" />
|
|
<property name="logFormatter">
|
|
<bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">
|
|
<property name="loggingType" value="MULTI_LINE" />
|
|
<property name="sqlPrefix" value="SQL : "/>
|
|
</bean>
|
|
</property>
|
|
</bean>
|
|
|
|
<!--Framework DB (Oracle) -->
|
|
<bean id="dataSource_O_FW" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
|
|
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
|
|
<property name="url" value="jdbc:oracle:thin:@172.168.30.3:1521/KIHASA"/>
|
|
<property name="username" value="KIHASA"/>
|
|
<property name="password" value="KIHASA"/>
|
|
<property name="defaultAutoCommit" value="true"/>
|
|
<property name="maxActive" value="5"/>
|
|
<property name="maxIdle" value="3"/>
|
|
<property name="maxWait" value="60000"/>
|
|
<property name="validationQuery" value="select 1 from dual"/>
|
|
<property name="testWhileIdle" value="true"/>
|
|
<property name="timeBetweenEvictionRunsMillis" value="1800000"/>
|
|
</bean>
|
|
|
|
<bean id="dataSource_FW" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
|
|
<constructor-arg ref="dataSource_O_FW" />
|
|
<property name="logFormatter">
|
|
<bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">
|
|
<property name="loggingType" value="MULTI_LINE" />
|
|
<property name="sqlPrefix" value="SQL : "/>
|
|
</bean>
|
|
</property>
|
|
</bean>
|
|
|
|
<!--ERP DB (Oracle) -->
|
|
<bean id="dataSource_O_ERP" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
|
|
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
|
|
<property name="url" value="jdbc:oracle:thin:@172.168.30.3:1521/KIHASA"/>
|
|
<property name="username" value="KIHASA"/>
|
|
<property name="password" value="KIHASA"/>
|
|
<property name="defaultAutoCommit" value="true"/>
|
|
<property name="maxActive" value="5"/>
|
|
<property name="maxIdle" value="3"/>
|
|
<property name="maxWait" value="60000"/>
|
|
<property name="validationQuery" value="select 1 from dual"/>
|
|
<property name="testWhileIdle" value="true"/>
|
|
<property name="timeBetweenEvictionRunsMillis" value="1800000"/>
|
|
</bean>
|
|
|
|
<bean id="dataSource_ERP" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
|
|
<constructor-arg ref="dataSource_O_ERP" />
|
|
<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>
|
|
|