spring 注入两个transactionManager问题

Question

我配置两个DATASOURCE
bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName"><value>com.p6spy.engine.spy.P6SpyDriver</value></property>
<property name="url"><value>jdbc:oracle:thin:@localhost:1521:orcl</value></property>
<property name="username"><value>test1</value></property>
<property name="password"><value>test1</value></property>
<property name="maxWait" value="4000"/>
<property name="poolPreparedStatements" value="false"/>
        <property name="defaultAutoCommit" value="false"/>
</bean>

<bean id="dataSourceOracle" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName"><value>com.p6spy.engine.spy.P6SpyDriver</value></property>
<property name="url"><value>jdbc:oracle:thin:@localhost:1521:orcl</value></property>
<property name="username"><value>test</value></property>
<property name="password"><value>test</value></property>
<property name="maxWait" value="4000"/>
<property name="poolPreparedStatements" value="false"/>
        <property name="defaultAutoCommit" value="false"/>
</bean>
        
        <bean id="hibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
<property name="properties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
<prop key="hibernate.query.substitutions">true 1, false 0</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>
</props>
</property>
</bean>

<!-- Hibernate Properties COnfiguation -->
<bean id="hibernatePropertiesOracle" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
<property name="properties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
<prop key="hibernate.query.substitutions">true 1, false 0</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>
</props>
</property>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean" depends-on="hibernateProperties">
<property name="dataSource"><ref local="dataSource" /></property> <property name="mappingResources">
<list>
<value>entity/user/Userinfo.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties"><ref local="hibernateProperties"/></property>
<property name="lobHandler"><ref bean="defaultLobHandler"/></property>
</bean>
<bean id="sessionFactoryOracle" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean" depends-on="hibernatePropertiesOracle">
<property name="dataSource"><ref local="dataSourceOracle" /></property>
<!-- Mapping files -->
<property name="mappingResources">
<list>
<value>entity/oracle/Usertest.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties"><ref local="hibernatePropertiesOracle"/></property>
<property name="lobHandler"><ref bean="defaultLobHandlerOracle"/></property>
</bean>
然后配置两个transactionManager
<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory"><ref bean="sessionFactory"/></property>
</bean>
<bean id="transactionManagerOracle" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory"><ref bean="sessionFactoryOracle"/></property>
</bean><tx:annotation-driven transaction-manager="transactionManager" />
<tx:annotation-driven transaction-manager="transactionManagerOracle" />我在测试的时候为什么总是取到第一个transactionManager,取不到这个transactionManagerOracleApplicationContext context = null;
context = new ClassPathXmlApplicationContext("applicationContext.xml");
HibernateTransactionManager manager = (HibernateTransactionManager)context.getBean("transactionManagerOracle");
DataSource ds = manager.getDataSource();
java.sql.Connection conn = ds.getConnection();
PreparedStatement ps = conn.prepareStatement("update USERTEST set name = 2");
ps.execute();
conn.commit();

Answer 1

<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory"><ref bean="sessionFactory"/></property>
    </bean>
    <bean id="transactionManagerOracle" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory"><ref bean="sessionFactoryOracle"/></property>
    </bean>

Answer 2

这个sessionFactory不是属性名吗，应该是一样的呀