Is this right way to Initiaize Hibernate configuration?

[Kishor Joshi]

Hi there

I am designing a web application using Spring+Hibernate web application.

I am injecting these property in each bean I Intialize here is a example of one bean

<bean id="registerEmployeeBean"  class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
   <property name="dataSource" ref="dataSource"></property>
    <property name="annotatedClasses">
    <list>
        <value>MyDaoClass</value>
    </list>
    </property>
    <property name="hibernateProperties">
                <props>
                  <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                  <prop key="hibernate.show_sql">false</prop>
                  <prop key="hibernate.current_session_context_class">thread</prop>
                  <prop key="hibernate.hbm2ddl.auto">create</prop>
                </props>
    </property>
</bean>

I am using this hibernatePropertis configuration in many beans in Spring is this right approach to use Hibernate in Spring?

Thanks

[Mark Spritzler]

No. You should only create one SessionFactory/EntitnyManagerFactory for your entire application. And you "registerEmployeeBean" Is not of type LocalSessionFactoryBean.

In A Spring Application you use a layered approach. Service layer for your business use case code and transaction demarcation at methods level. Repository Layer that stores your queries to run. And then there is the SessionFactory underneath. The sessionFactory gets injected into your repository classes. So one bean for sessionFactory and one bean per repository class with dependency injection injecting the sessionFactory into the repository classes. Then the repository classes are injected into the Service layer classes.

Mark

[Kishor Joshi]

@Mark

Thanks