<!-- Hibernate SessionFactory -->
    <bean id="sessionFactoryFoo" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource"><ref local="dataSourceFoo"/></property>
        <property name="mappingResources">
            <list>
                <value>foo/model/FooA.hbm.xml</value>
                <value>foo/model/FooB.hbm.xml</value>
                <!-- ...... -->
            </list>
        </property>
        <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>            
        </props>
        </property>
    </bean>
<!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
    <bean id="transactionManagerFoo" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory"><ref local="sessionFactoryFoo"/></property>
    </bean>    

    <bean id="fooADAO" class="foo.dao.FooADAOHibernateImpl">
        <property name="sessionFactory"><ref local="sessionFactoryFoo"/></property>
    </bean>