Hibernate Interview Questions

Q: How to integrate Spring with Hibernate?
A: A: The most important part is the spring bean configuration. This config file should contains

1.      dataSource

2.      sessionfactory

     3.  DAOImpl

Sample config file

<bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

<property name="driverClassName" value="org.hsqldb.jdbcDriver"/>

<property name="url" value="jdbc:hsqldb:hsql://localhost:9001"/>

<property name="username" value="sa"/>

<property name="password" value=""/>

</bean>

<bean id="mySessionFactory" class="org.springframework.orm.hibernate3.

annotation.AnnotationSessionFactoryBean">

OR

<bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="dataSource" ref="myDataSource" />

<property name="annotatedClasses">

<list>

<value>com.vaannila.domain.User</value>

</list>

</property>

<property name="hibernateProperties">

<props>

<prop key="hibernate.dialect"> org.hibernate.dialect.HSQLDialect</prop>

<prop key="hibernate.show_sql">true</prop>

<prop key="hibernate.hbm2ddl.auto">create</prop>

</props>

</property>

</bean>

<bean id="myUserDAO" class="com.vaannila.dao.UserDAOImpl">

<property name="sessionFactory" ref="mySessionFactory"/>

</bean>

Sample DAOImpl

public class UserDAOImpl implements UserDAO {

private HibernateTemplate hibernateTemplate;

public void setSessionFactory(SessionFactory sessionFactory){

this.hibernateTemplate = new HibernateTemplate(sessionFactory);

}

public void saveUser(User user) {

hibernateTemplate.saveOrUpdate(user);

}

DAOImpl should extend HibernateDaoSupport or we can set the session using the setter method as above