SpringSide3中多数据源配置

applicationContext.xml中配置

下面是加载外部配置文件：application.properties

<bean
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="systemPropertiesModeName" value="SYSTEM_PROPERTIES_MODE_OVERRIDE" />
		<property name="ignoreResourceNotFound" value="true" />
		<property name="locations">
			<list>
				<!-- 标准配置 -->
				<value>classpath*:/application.properties</value>
		</property>
</bean>

多数据源配置：

<!-- 本地数据库配置 -->
	<bean id="dataSourceContent" class="com.atomikos.jdbc.AtomikosDataSourceBean" init-method="init" destroy-method="close">      
        <property name="uniqueResourceName">      
            <value>jdbc/dataSourceContent</value>      
        </property>      
        <property name="xaDataSourceClassName">      
            <value>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</value>      
        </property>      
        <property name="xaProperties">
            <props>    
                <prop key="serverName">${jdbc.servername}</prop>
                <prop key="portNumber">${jdbc.portnumber}</prop>    
                <prop key="databaseName">${jdbc.databasename}</prop>
                <prop key="user">${jdbc.username}</prop>    
                <prop key="password">${jdbc.password}</prop>    
            </props>          
        </property>          
        <property name="poolSize">      
            <value>5</value>      
        </property>
        <property name="maxPoolSize">
			<value>15</value>
		</property>
        <property name="testQuery">        
			<value>select 1</value>    
		</property>   
    </bean>
    <bean id="dataSourceIndex" class="com.atomikos.jdbc.AtomikosDataSourceBean" init-method="init" destroy-method="close">      
        <property name="uniqueResourceName">      
            <value>jdbc/dataSourceIndex</value>      
        </property>      
        <property name="xaDataSourceClassName">      
            <value>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</value>      
        </property>      
        <property name="xaProperties">      
            <props>    
                <prop key="serverName">${jdbc.servername_index}</prop>    
                <prop key="portNumber">${jdbc.portnumber_index}</prop>    
                <prop key="databaseName">${jdbc.databasename_index}</prop>    
                <prop key="user">${jdbc.username_index}</prop>    
                <prop key="password">${jdbc.password_index}</prop>    
            </props>     
        </property>           
        <property name="poolSize">      
            <value>5</value>      
        </property>
        <property name="maxPoolSize">
			<value>15</value>
		</property>
        <property name="testQuery">        
			<value>select 1</value>    
		</property>        
    </bean>

Hibernate sessionFactory配置：

<!-- Hibernate配置 -->
	<!-- 本地数据库Hibernate配置 -->
    <bean id="sessionFactoryContent" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource" ref="dataSourceContent" />
        <property name="namingStrategy">
            <bean class="org.hibernate.cfg.ImprovedNamingStrategy" />
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop>
                <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
                <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
                <prop key="hibernate.cache.provider_configuration_file_resource_path">ehcache/ehcache-hibernate-local.xml</prop>
            </props>
        </property>
        <property name="packagesToScan" value="com.wiseweb.pom.entity" />
    </bean>
    <!-- 远程数据库Hibernate配置 -->
    <bean id="sessionFactoryIndex" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource" ref="dataSourceIndex" />
        <property name="namingStrategy">
            <bean class="org.hibernate.cfg.ImprovedNamingStrategy" />
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop>
                <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
                <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
                <prop key="hibernate.cache.provider_configuration_file_resource_path">ehcache/ehcache-hibernate-local.xml</prop>
            </props>
        </property>
        <property name="packagesToScan" value="com.wiseweb.pom.entity" />
    </bean>

事务管理器配置：

<!-- 事务管理器配置,多数据源JTA事务-->
    <bean id="atomikosTransactionManager" class="com.atomikos.icatch.jta.UserTransactionManager" init-method="init" destroy-method="close">   
        <property name="forceShutdown"><value>true</value></property>   
    </bean>   
       
    <bean id="atomikosUserTransaction" class="com.atomikos.icatch.jta.UserTransactionImp">   
        <property name="transactionTimeout" value="300"/>
    </bean>   
    <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager">
        <property name="transactionManager" ref="atomikosTransactionManager" />
        <property name="userTransaction" ref="atomikosUserTransaction"/>
    </bean>

	<!-- 使用annotation定义事务 -->
	<tx:annotation-driven transaction-manager="transactionManager"
		proxy-target-class="true" />

application.properties文件：

jdbc.driver=com.mysql.jdbc.Driver
jdbc.servername=host
jdbc.portnumber=port
jdbc.databasename=databasename
jdbc.url=jdbc\:mysql\://host\:port/databaseName?useUnicode\=true&zeroDateTimeBehavior\=convertToNull&characterEncoding\=utf-8
jdbc.username=username
jdbc.password=password
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

#mysql version database setting
jdbc.servername_index=host
jdbc.portnumber_index=port
jdbc.databasename_index=databaseName
jdbc.url_index=jdbc\:mysql\://host\:port/databaseName?useUnicode\=true&zeroDateTimeBehavior\=convertToNull&characterEncoding\=utf-8
jdbc.username_index=username
jdbc.password_index=password

#hibernate settings
hibernate.show_sql=false 
hibernate.format_sql=false
hibernate.use_second_level_cache=false
hibernate.use_query_cache=false

#dbcp settings
dbcp.maxIdle=5
dbcp.maxActive=40

jta.properties

com.atomikos.icatch.service=com.atomikos.icatch.standalone.UserTransactionServiceFactory
com.atomikos.icatch.console_file_name = sm.out
com.atomikos.icatch.log_base_name = smlog.log
com.atomikos.icatch.tm_unique_name = com.atomikos.spring.jdbc.tm
com.atomikos.icatch.serializable_logging=false