Announcement Announcement Module
Collapse
No announcement yet.
Hibernate_SessionFactories_ Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Hibernate_SessionFactories_

    Hi,

    If a datasource contains lot's of tables, should we make a sessionFactory for that datasource and write all the mappings for the tables OR should we define more sessionFactories for the datasource and write table mappings seperately...
    Example: Are there any performance gains when using seperate sessionfactories as in the first example instead of the second one...

    Ex1:
    Code:
     <bean id="sessionFactoryDB2" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
            <property name="dataSource"><ref local="DB2DataSource"/></property>
            <property name="mappingResources">
                <list>
                    <value>com/aaa/springtemplate/model/mapping/User.hbm.xml</value>
    <value>com/aaa/springtemplate/model/mapping/Order.hbm.xml</value>
    <value>com/aaa/springtemplate/model/mapping/Customer.hbm.xml</value>
                </list>
            </property>
    </bean>
    Ex2:
    Code:
     <bean id="sessionFactoryDB2" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
            <property name="dataSource"><ref local="DB2DataSource"/></property>
            <property name="mappingResources">
                <list>
                    <value>com/aaa/springtemplate/model/mapping/User.hbm.xml</value>
                </list>
            </property>
    </bean>
    
     <bean id="sessionFactory_2_DB2" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
            <property name="dataSource"><ref local="DB2DataSource"/></property>
            <property name="mappingResources">
                <list>
                    <value>com/aaa/springtemplate/model/mapping/Order.hbm.xml</value>
                </list>
            </property>
    </bean>
    
     <bean id="sessionFactory_3_DB2" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
            <property name="dataSource"><ref local="DB2DataSource"/></property>
            <property name="mappingResources">
                <list>
                    <value>com/aaa/springtemplate/model/mapping/Customer.hbm.xml</value>
                </list>
            </property>
    </bean>
Working...
X