Spring+ibatis配置多数据源连接池说明.docVIP

项目中需要从多个数据库中存取数据，这时不得不配置多个数据源才能系统需求。先贴上来spring文件里的主要配置，接下来将分不同的篇幅讲解各个配置之间的关系。我这可是项目中正在使用的，若有需要帮助的朋友可在线留言或加qq。 ?xml version=1.0 encoding=UTF-8?beans xmlns=/schema/beans?xmlns:xsi=/2001/XMLSchema-instance?xmlns:context=/schema/context?xmlns:aop=/schema/aop?xmlns:tx=/schema/tx?xsi:schemaLocation=/schema/beans?????????? /schema/beans/spring-beans-2.5.xsd?????????? /schema/context?????????? /schema/context/spring-context-2.5.xsd?????????? /schema/aop /schema/aop/spring-aop-2.5.xsd?????????? /schema/tx /schema/tx/spring-tx-2.5.xsd??? ?bean id=parentdataSource??class=mons.dbcp.BasicDataSource??destroy-method=close??property name=driverClassName???valuecom.mysql.jdbc.Driver/value??/property??property name=initialSize???value5/value??/property??property name=maxActive???value300/value??/property??property name=maxIdle???value5/value??/property??property name=maxWait???value100000/value??/property??property name=testOnBorrow???valuetrue/value??/property??property name=validationQuery???valueSELECT COUNT(*) FROM DUAL/value??/property?/bean? !-- =========================================== 数据源一（data1）=========================================== --bean id=dataSource1 parent=parentdataSource??property name=url???valuejdbc:mysql://:3306/data1?rewriteBatchedStatements=trueamp;autoReconnect=trueamp;useUnicode=trueamp;characterEncoding=UTF-8/value??/property??property name=username???valuewzh/value??/property??property name=password???valuewzh/value??/property?/bean??bean id=transactionManager1??class=org.springframework.jdbc.datasource.DataSourceTransactionManager??property name=dataSource ref=dataSource1 /?/bean??bean id=sqlMapClient1??class=org.springframework.orm.ibatis.SqlMapClientFactoryBean??property name=configLocation???valueclasspath:dao/sqlMapConfig1.xml/value??/property??property name=dataSource ref=dataSource1 /?/bean??bean id=transactionInterceptor1??class=erceptor.TransactionInterceptor??property name=tran