springside3.3.4，hibernate，Atomikos多数据源整合

1。applicationContext.xml 配置

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="" xmlns:xsi=""
    >
        xmlns:jee="" xmlns:tx=""
        xmlns:context=""
        xsi:schemaLocation="
        /spring-beans-3.0.xsd

        /spring-tx-3.0.xsd

        /spring-jee-3.0.xsd

        /spring-context-3.0.xsd"
        default-autowire="byName" default-lazy-init="true">

        <description>Spring公共配置 </description>

        <!-- 定义受环境影响易变的变量 -->
        <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="locations">
                <list>
                    <value>classpath*:/jdbc.properties</value>
                </list>
            </property>
        </bean>

        <!-- 使用annotation 自动注册bean,并保证@Required,@Autowired的属性被注入 -->
        <context:component-scan base-package="org.gyfbao.office" />

        <!-- 数据源配置,使用应用内的DBCP数据库连接池 -->
        <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>oracle.jdbc.xa.client.OracleXADataSource</value>
            </property>
            <property name="xaProperties">
                <props>
                    <prop key="URL">jdbc:oracle:thin:@localhost:1521:orcl</prop>
                    <prop key="user">multiple</prop>
                    <prop key="password">admin</prop>
                </props>
            </property>
            <property name="poolSize">
                <value>3</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>net.sourceforge.jtds.jdbcx.JtdsDataSource</value>
            </property>
            <property name="xaProperties">
                <props>
                    <prop key="serverName">localhost</prop>
                    <prop key="portNumber">2433</prop>
                    <prop key="databaseName">allinpay</prop>
                    <prop key="user">sa</prop>
                    <prop key="password">gyfbao</prop>
                </props>
            </property>
            <property name="poolSize">
                <value>3</value>
            </property>
        </bean>


        <!-- 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">${hibernate.orcl.dialect}</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="org.gyfbao.office" />
        </bean>
        <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">${hibernate.dialect}</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="org.gyfbao.office" />
        </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" />

    </beans>

2。web.xml修改

<filter>
           <filter-name>hibernateOpenSessionInViewFilterContent</filter-name>
           <filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>
           <init-param>
               <param-name>excludeSuffixs</param-name>
               <param-value>js,css,jpg,gif</param-value>
           </init-param>
           <init-param>
                  <param-name>sessionFactoryBeanName</param-name>
               <param-value>sessionFactoryContent</param-value>
           </init-param>
    </filter>
    <filter>
           <filter-name>hibernateOpenSessionInViewFilterIndex</filter-name>
           <filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>
           <init-param>
               <param-name>excludeSuffixs</param-name>
               <param-value>js,css,jpg,gif</param-value>
           </init-param>
           <init-param>
                  <param-name>sessionFactoryBeanName</param-name>
               <param-value>sessionFactoryIndex</param-value>
           </init-param>
    </filter>

      <filter-mapping>
           <filter-name>hibernateOpenSessionInViewFilterContent</filter-name>
           <url-pattern>

3。Dao代码中sessionFactory选择

@Repository
    public class BrandDao extends HibernateDao<Brand,Long>{
    @Override
    @Resource(name = "sessionFactoryContent")
    public void setSessionFactory(SessionFactory sessionFactory) {
         super.setSessionFactory(sessionFactory);
    }