因为需求,需要从不同数据源中获取基础数据,原本想直接使用DB Link直接从一个数据源中获取,但种种原因还是只能以多数据源来实现了。在Spring2.5之前,@Transactional注解确实不支持多数据源,但是Spring3为其增加了value属性配置,可以指定当前事务通知对应的事务管理器。可惜目前用的版本是2.5。
1、配置多个数据源
<bean id="parentDataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource"
p:driverClassName="${jdbc.driverClassName}"/>
<!-- JNDI DataSource for J2EE environments -->
<bean id="dataSource" parent="parentDataSource" p:url="${jdbc.url}"
p:username="${jdbc.username}" p:password="${jdbc.password}" />
<bean id="dataSourceOA" parent="parentDataSource" p:url="${oa.jdbc.url}"
p:username="${oa.jdbc.username}" p:password="${oa.jdbc.password}" />
2、配置sessionFactory
<bean id="baseSessionFactory" class="itaf.framework.dao.util.CustomAnnotationSessionFactoryBean">
<property name="annotationLocations">
<list>
<value>com/**/model</value>
</list>
</property>
<property name="annotationInterfaces">
<list>
<value>com.model.BaseEntity</value>
</list>
</property>
<property name ="lobHandler" ref ="oracleLobHandler"/>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
${hibernate.dialect}
</prop>
<prop key="hibernate.show_sql">
${hibernate.show_sql}
</prop>
<prop key="hibernate.generate_statistics">
${hibernate.generate_statistics}
</prop>
<prop key="hibernate.query.substitutions">
true 1, false 0
</prop>
<prop key="hibernate.cache.use_query_cache">
${hibernate.use_query_cache}
</prop>
<prop key="hibernate.cache.use_second_level_cache">
${hibernate.use_second_level_cache}
</prop>
<prop key="hibernate.cache.provider_class">
${hibernate.cache_provider_class}
</prop>
<!--
<prop key="hibernate.cache.provider_configuration_file_resource_path">
${hibernate.cache_configuration_file}
</prop>
-->
</props>
</property>
</bean>
<bean id="sessionFactory" parent="baseSessionFactory">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="sessionFactoryOA" parent="baseSessionFactory">
<property name="dataSource" ref="dataSourceOA" />
</bean>
3、指定sessionFactory
@Repository("oaBasicInfoDao")
public class OaBasicInfoDaoImpl extends BaseDaoImpl<BasicInfo> implements IOaBasicInfoDao {
@Override
@Resource(name="sessionFactoryOA")
public void setHibernateSessionFactory(SessionFactory sessionFactory) {
// TODO Auto-generated method stub
super.setHibernateSessionFactory(sessionFactory);
}
}
BaseDaoImpl.java
/**
* @param sessionFactory
*/
@Autowired
public void setHibernateSessionFactory(SessionFactory sessionFactory) {
super.setSessionFactory(sessionFactory);
}
大致步骤就完成了,如果出现
org.springframework.beans.factory.NoSuchBeanDefinitionException: No unique bean of type...错误,则在aop文件中配置:
<aop:configproxy-target-class="true">
</aop:config>
后续可能需要配置多个事务管理器,以及使用了OpenSessionInView的问题
参考:http://www.blogjava.net/youxia/archive/2009/07/12/286454.html