Spring2.5 多数据源

          因为需求，需要从不同数据源中获取基础数据，原本想直接使用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