SpringSide3中多数据源配置-阿里云开发者社区

SpringSide3中多数据源配置

2016-05-19 1565

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

本文涉及的产品

RDS MySQL Serverless 基础系列，0.5-2RCU 50GB

云数据库 RDS MySQL，集群系列 2核4GB

云数据库 RDS MySQL，高可用系列 2核4GB

简介：

applicationContext.xml中配置

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

[html]view plain copy 
 print?
<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>  

多数据源配置：

[html]view plain copy 
 print?
<!-- 本地数据库配置 -->  
    <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配置：

[html]view plain copy 
 print?
<!-- 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>  

事务管理器配置：

[html]view plain copy 
 print?
<!-- 事务管理器配置,多数据源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文件：

[html]view plain copy 
 print?
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

[html]view plain copy 
 print?
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  

SpringSide3中多数据源配置

热门文章

最新文章

相关电子书