Currently, the application has two sessionfactory for online tables and history tables


<bean id="oracleSessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="foxDS"/>
<property name="mappingResources">
<list>
<value>OrderVO.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<value>
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
hibernate.format_sql=true
hibernate.show_sql=false
</value>
</property>
</bean>

<bean id="historySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="foxDS"/>
<property name="mappingResources">
<list>
<value>OrderVO_Hist.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<value>
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
hibernate.format_sql=true
hibernate.show_sql=false
</value>
</property>
</bean>


But, the transaction manager can reference to ONE sessionFactory only

<bean id="myTxManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory" ref="oracleSessionFactory"/>
</bean>

Therefore, is it possible to have the transaction manager handle TWO session factory? It is because the application will work on the online table and history table and would like to make the operation in a transaction, so that once roll-back, the operations on two session factory will be rolled back.

Thanks!

Your question is best posed in the spring forums located here:

http://forum.springframework.org/

But to answer your question: No, HibernateTransactionManager can only manage the transactions of one session factory. If you need more functionality, ask in the spring forums how to pull it off. (Or read up on JTATransactionManager, which I think will work but I haven't used it myself.)

-B