ZK MVVM Form Binding CRUD with Spring and Hibernate - Part 3

Spring Integration with Hibernate

        

In Part 2, we have created our domain, DAO and service Layer. In this part 3, we will see how to integrate spring and Hibernate. There are different way you can integrate. In this example, I am going to show by using Hibernate API. For more information, please check here.

Step 1:
First let us update our web.xml under the web-inf folder. Just add the following section in the top of the web.xml file.

<!-- Spring can be easily integrated into any Java-based web framework. 
		All you need to do is to declare the ContextLoaderListener in your web.xml 
		and use a contextConfigLocation <context-param> to set which context files 
		to load. If you don't specify the contextConfigLocation context parameter, 
		the ContextLoaderListener will look for a /WEB-INF/applicationContext.xml 
		file to load. Once the context files are loaded, Spring creates a WebApplicationContext 
		object based on the bean definitions and puts it into the ServletContext. -->

	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>
		            /WEB-INF/applicationContext.xml
         </param-value>
	</context-param>
	<!-- Loads the Spring web application context -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>


	<filter>
		<filter-name>OpenSessionInViewFilter</filter-name>
		<filter-class>org.springframework.orm.hibernate4.support.OpenSessionInViewFilter</filter-class>
	</filter>
	<filter-mapping>
		<filter-name>OpenSessionInViewFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>

Step 2:
Next we will create applicationContext.xml under web-inf folder.

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:p="http://www.springframework.org/schema/p" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="
           http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-3.0.xsd
           http://www.springframework.org/schema/tx
                   http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/addressbook" />
		<property name="username" value="root" />
		<property name="password" value="1234" />
	</bean>


	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="packagesToScan" value="zkexample.domain" />
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.format_sql">true</prop>
				<prop key="hibernate.use_sql_comments">true</prop>
				<prop key="hibernate.zeroDateTimeBehavior">convertToNull</prop>
			</props>
		</property>
	</bean>

	<bean id="transactionManager"
		class="org.springframework.orm.hibernate4.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>

	<context:annotation-config />
	<context:component-scan base-package="zkexample" />

	<tx:annotation-driven transaction-manager="transactionManager" />

	<!-- This will ensure that hibernate or jpa exceptions are automatically 
		translated into Spring's generic DataAccessException hierarchy for those 
		classes annotated with Repository -->

	<bean
		class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />

	<bean id="CRUDService" class="zkexample.service.CRUDServiceImpl" />

</beans>

Reference
1. MIGRATING TO SPRING 3.1 AND HIBERNATE 4.1
2. Spring Integration with Hibernate
3. Object Relational Mapping (ORM) data access
4. Spring and Hibernate ORM Framework Integration
5. The Persistence Layer with Spring 3.1 and Hibernate

In the next part 4, we will create UI for our CRUD operation using ZK.