Ola, é possível configurar o Spring e o Hibernate juntos para trabalhar com 2 banco de dados?
No caso esta configurado assim para o DB2:
<bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="mappingResources">
<list>
....
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.DB2Dialect</prop>
<prop key="hibernate.connection.driver_class">com.ibm.db2.jcc.DB2Driver</prop>
<prop key="hibernate.connection.url">jdbc:db2://xx.x.x.xx:50010/banco</prop>
<prop key="hibernate.connection.username">user</prop>
<prop key="hibernate.connection.password">pass</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="hibernate.jdbc.batch_size">0</prop>
</props>
</property>
</bean>
<!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
<bean id="myTransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory"><ref local="mySessionFactory"/></property>
</bean>
A minha segunda conexao será no Oracle para uso de native query, qual a maneira correta de fazer isso?