使用Spring+Hibernate同时操作两个数据库

 

 

首先，我不建议在一个DAO中操作两个session，而是设计两个DAO（假设为DatabaseADao和DatabaseBDao），在一个BO(Bussiness Object)中调用这两个DAO，并实现事务。

对两个数据库的操作，我们需要两个数据源(DatasourceA 和 DatasourceB)，并且，要在两个数据库中保证事务，就要使用JTA。

下面是两个DAO：
DatabaseADaoImpl.java

public class DatabaseADaoImpl extends HibernateDaoSupport implements DatabaseADao {
    public void addUser(User user) throws DataAccessException {
        getHibernateTemplate().saveOrUpdate(user);
    }
}

DatabaseBDaoImpl.java

public class DatabaseBDaoImpl extends HibernateDaoSupport implements DatabaseBDao {
    public void addUser(User user) throws DataAccessException {
        getHibernateTemplate().saveOrUpdate(user);
    }
}

有一个BO，包含一个添加用户的方法addUser:

public class UserBO {

    DatabaseADao databaseADao;
    DatabaseBDao databaseBDao;

    //....................... getter and setter 

    public void addUser(User user) {
        getDatabaseADao().addUser(user);
        getDatabaseBDao().addUser(user);
    }
}

下面是大致的spring config file:

applicationContext-hibernate.xml

        <!-- define datasource -->
  <bean id="dataSourceA" class="org.springframework.jndi.JndiObjectFactoryBean">
    <property name="jndiName"><value>java:comp/env/jdbc/databaseA</value></property>
  </bean>

  <bean id="dataSourceB" class="org.springframework.jndi.JndiObjectFactoryBean">
    <property name="jndiName"><value>java:comp/env/jdbc/databaseB</value></property>
  </bean>

  <!-- Hibernate SessionFactory -->
  <bean id="sessionFactoryA" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
    <property name="dataSource"><ref local="dataSourceA"/></property>
    <property name="mappingResources">
      <value>exampleA.hbm.xml</value>
    </property>
    <property name="hibernateProperties">
      <props>
        <prop key="hibernate.dialect">${hibernate.dialect}</prop>
      </props>
    </property>
  </bean>

  <bean id="sessionFactoryB" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
    <property name="dataSource"><ref local="dataSourceB"/></property>
    <property name="mappingResources">
      <value>exampleB.hbm.xml</value>
    </property>
    <property name="hibernateProperties">
      <props>
        <prop key="hibernate.dialect">${hibernate.dialect}</prop>
      </props>
    </property>
  </bean>

  <!-- dao -->
  <bean id="databaseADao" class="examples.DatabaseADaoImpl">
    <property name="sessionFactory"><ref local="sessionFactoryA"/></property>  
  </bean>

  <bean id="databaseBDao" class="examples.DatabaseBDaoImpl">
    <property name="sessionFactory"><ref local="sessionFactoryB"/></property>  
  </bean>

  <!-- Transaction manager that delegates to JTA (for a transactional JNDI DataSource) -->
  <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager"/>
  

  <bean id="userBOTarget" class="examples.UserBO">
    <property name="databaseADao"><ref local="databaseADao"/></property>
    <property name="databaseBDao"><ref local="databaseBDao"/></property>  
  </bean>

  <bean id="userBO" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
    <property name="transactionManager"><ref bean="transactionManager"/></property>
    <property name="transactionAttributes">
      <props>
        <prop key="addUser">PROPAGATION_REQUIRED</prop>
      </props>
    </property>
    <property name="target">
      <ref local="userBOTarget"></ref>
    </property>
  </bean>