读书人

Spring 配备Oracle和MySql双数据源

发布时间: 2012-10-16 09:57:37 作者: rapoo

Spring 配置Oracle和MySql双数据源
Spring DataSource配置:

<?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:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-2.0.xsdhttp://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsdhttp://www.springframework.org/schema/tx            http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"><!--#########################################################################################################   datasource配置      ########################################################################################################--><bean id="dataSource" destroy-method="close">        <!-- Connection Info -->        <property name="driverClassName" value="${database.mysql.driver}" />        <property name="url" value="${database.mysql.url}" />        <property name="username" value="${database.mysql.username}" />        <property name="password" value="${database.mysql.password}" />        <!-- Connection Pooling Info -->        <property name="initialSize" value="5" />        <property name="maxActive" value="100" />        <property name="maxIdle" value="30" />        <property name="maxWait" value="1000" />        <property name="poolPreparedStatements" value="true" />        <property name="defaultAutoCommit" value="false" />    </bean><bean id="daoConfigBase" abstract="true"><property name="sqlMapClient"><ref bean="sqlMapClient" /></property></bean><bean id="daoConfigBaseMySql" abstract="true"><property name="sqlMapClient"><ref bean="sqlMapClientMySql" /></property></bean><bean id="sqlMapClient" /><property name="dataSource" ref="dataSource" /></bean><bean id="sqlMapClientMySql" /><property name="dataSource" ref="dataSourceMySql" /></bean></beans>

DAO继承配置:
<bean id="ipDAO"parent="daoConfigBaseMySql" /><bean id="ipDAO"parent="daoConfigBase" />

读书人网 >Mysql

热点推荐