Supporting multiple Databases in Hibernate

Data Source definition

<bean id="oracleDataSource" >
    <property name="jndiName" value="jdbc/oracleDSName"/>
</bean>

<bean id="mySqlDataSource" >
    <property name="jndiName" value="jdbc/mySqlDSName"/>
</bean>
    
        
Session Factory Configuration

<bean id="oracleSessionFactory" >
    <property name="dataSource" ref="oracleDataSource" />
    <property name="packagesToScan">
        <list>
            <value>com.feature.entities.db</value>
        </list>
    </property>        
 
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>
            <prop key="hibernate.show_sql">false</prop>
        </props>
    </property>
 </bean>    
    
<bean id="mySQLSessionFactory" >
    <property name="dataSource" ref="mySqlDataSource" />
    <property name="annotatedClasses">
        <list>
            <value>com.feature.entities.db.ClassA</value>
            <value>com.feature.entities.db.ClassB</value>
        </list>
    </property>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
            <prop key="hibernate.show_sql">false</prop>
        </props>
    </property>
</bean>    
    

Configure the DAOs. 

<bean id="oracleBaseDAO" >
    <property name="sessionFactory" ref="oracleSessionFactory"/>
</bean>
<bean id="mySqlBaseDAO" >
    <property name="sessionFactory" ref="mySQLSessionFactory"/>    
</bean>   ​