hibernate 配置多个数据源

场景：

A系统使用的是mysql数据库，需要使用sqlserver用户数据库

方案：采用hibernate配置多个数据源,sqlserver只用于查询。

配置数据源

<!--本地库 -->
      <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">  
        <property name="jndiName">  
            <value>java:comp/env/jdbc/bing</value>
        </property>  
    </bean>
    
    <!-- 用户中心库 -->
    <bean id="dataSourceUser" class="org.springframework.jndi.JndiObjectFactoryBean">  
        <property name="jndiName">  
            <value>java:comp/env/jdbc/user</value>  
        </property>  
    </bean>

  <!-- SessionFactory配置 -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="packagesToScan" value="${application.domain.packages.bing}"/>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>
   

<!--用户sessionFactory-->
    <bean id="sessionFactoryUser" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSourceUser"/>
        <property name="packagesToScan" value="${application.domain.packages.user}"/>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.SQLServer2005Dialect</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>

<!--事务控制-->

<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
            
    <bean id="transactionManagerUser" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactoryUser" />
    </bean>

    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="insert*" rollback-for="Exception"/>
            <tx:method name="save*"   rollback-for="Exception"/>
            <tx:method name="update*" rollback-for="Exception"/>
            <tx:method name="remove*" rollback-for="Exception"/>
            <tx:method name="delete*" rollback-for="Exception"/>
             <tx:method name="add*"    rollback-for="Exception"/>
            <tx:method name="modify*" rollback-for="Exception"/>
            <tx:method name="deploy*" rollback-for="Exception"/>            
            <tx:method name="*" read-only="true" rollback-for="Exception"/>
        </tx:attributes>
    </tx:advice>    
    
   <tx:advice id="txAdviceUser" transaction-manager="transactionManagerUser">
        <tx:attributes>
            <tx:method name="insert*" rollback-for="Exception"/>
            <tx:method name="save*"   rollback-for="Exception"/>
            <tx:method name="update*" rollback-for="Exception"/>
            <tx:method name="remove*" rollback-for="Exception"/>
            <tx:method name="delete*" rollback-for="Exception"/>
             <tx:method name="add*"    rollback-for="Exception"/>
            <tx:method name="modify*" rollback-for="Exception"/>
            <tx:method name="deploy*" rollback-for="Exception"/>              
            <tx:method name="*" read-only="true" rollback-for="Exception"/>
        </tx:attributes>
    </tx:advice>

   
    <aop:config proxy-target-class="true">
        <aop:pointcut id="txPointcut" expression="execution(* *..*Service.*(..))" />
        <aop:advisor advice-ref="txAdvice"  pointcut-ref="txPointcut" />
        <aop:advisor advice-ref="txAdviceUser" pointcut-ref="txPointcut"  />
    </aop:config>