@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:test-context.xml",
"classpath:/META-INF/spring/applicationContext.xml"})
 
public class CourseTest
{
    @Autowired
    private CoursesDAOImpl coursesDao;

    @Test
    public void testFindCourseById()
    {
    	Course course = coursesDao.findCourseById(322);

        Assert.assertEquals("Python", course.getName());
        Assert.assertEquals("Development Manager", course.getCategory());
        Assert.assertEquals("python.com", course.getLinks());
        return;
}    }

<?xml version="1.0" encoding="UTF-8"?>
 
<beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
 
    <!-- the test application context definition for the jdbc based tests -->
 
  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close"
		p:driverClassName="org.h2.Driver"
		p:url="jdbc:h2:tcp://localhost:9092/~/QWE;INIT=create schema if not exists QWE\;"
		p:username="sa"
		p:password=""
		 />
 
    <bean id="coursesDao" class="com.epam.edu.jtc.dao.CoursesDAOImpl">
        <property name="dataSource" ref="dataSource"/>
    </bean>
 
    <bean id="propertyConfigurer"
          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>classpath:jdbc.properties</value>
            </list>
        </property>
    </bean>

@Repository
public class CoursesDAOImpl implements CoursesDAO {
 
	 @Autowired
 	 private SessionFactory sessionFactory;
  
	public Course findCourseById(Integer id) {
		
		Session session = sessionFactory.getCurrentSession();
		session.beginTransaction();
		Course course = (Course) session.get(Course.class, id);
		session.getTransaction().commit();
		
		return course;
	}