@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:data.xml" })
@TestExecutionListeners({ DependencyInjectionTestExecutionListener.class,
        DirtiesContextTestExecutionListener.class,
        DbUnitTestExecutionListener.class })
public class HibernateUserDaoTest {

@Autowired
private UserDao userDao;

@Test
    @DatabaseSetup(value = { "classpath:my_user_tb.xml" })
    @ExpectedDatabase(value = "classpath:create_my_user_tb.xml", assertionMode = DatabaseAssertionMode.NON_STRICT)
    public void testCreate() throws Exception {
        System.out.println("1");
        User user = null;
        Role role1 = new Role();
        role1.setId(1);
        role1.setName("USER");
        user = new User(2, "Newman", "", "new@mail.ru", "Numan", "Lastman",
                Date.valueOf("1914-07-28"), role1);
        userDao.create(user);
    }
    ......
    }

<tx:annotation-driven />
        <mvc:annotation-driven />

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

        <bean
            class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping" />
        <bean
            class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" />

        <bean id="propertyConfigurer"
            class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
            p:location="jdbc.properties" />

        <bean id="dataSource"
            class="org.apache.commons.dbcp.BasicDataSource"
            p:driverClassName="${jdbc.driverClassName}" p:url="${jdbc.databaseurl}"
            p:username="${jdbc.username}" p:password="${jdbc.password}" />

        <bean id="sessionFactory"
            class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
            <property name="dataSource" ref="dataSource" />
            <property name="packagesToScan" value="com.entity" />
            <property name="hibernateProperties">
                <props>
                    <prop key="hibernate.show_sql">true</prop>
                    <prop key="hibernate.dialect">${jdbc.dialect}</prop>
                    <prop key="hibernate.connection.charSet">UTF-8</prop>
                    <prop key="hibernate.hbm2ddl.auto">create</prop>
                </props>
            </property>
        </bean>

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

        <bean name="userService"
            class="com.service.UserServiceImpl" />
        <bean name="roleService"
            class="com.service.RoleServiceImpl" />

        <bean name="userDao" class="com.dao.HibernateUserDao" />
        <bean name="roleDao" class="com.dao.HibernateRoleDao" />

<bean id="dataTypeFactory" class="org.dbunit.ext.h2.H2DataTypeFactory" />

<bean id="dbUnitDatabaseConfig" class="com.github.springtestdbunit.bean.DatabaseConfigBean">
    <property name="datatypeFactory" ref="dataTypeFactory"/>
</bean>

<bean id="dbUnitDatabaseConnection" class="com.github.springtestdbunit.bean.DatabaseDataSourceConnectionFactoryBean">
    <property name="databaseConfig" ref="dbUnitDatabaseConfig"/>
    <property name="dataSource" ref="dataSource"/>
</bean>

@Configuration
public class DbUnitConfiguration {

@Autowired
private DataSource dataSource;

@Bean
public DatabaseDataSourceConnectionFactoryBean dbUnitDatabaseConnection() {
    DatabaseConfigBean bean = new DatabaseConfigBean();
    bean.setDatatypeFactory(new H2DataTypeFactory());

    DatabaseDataSourceConnectionFactoryBean dbConnectionFactory = new DatabaseDataSourceConnectionFactoryBean(dataSource);
    dbConnectionFactory.setDatabaseConfig(bean);
    return dbConnectionFactory;
    }
}