首先,我不建议在一个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>