Spring mvc konfiguracja z hibernate

Question

Witam mam problem z konfiguracja Springa z Hibernate ponizej przedstawiam kod i bledy
 
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
         http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
    version="3.1">
 
    <display-name>Archetype Created Web Application</display-name>
 
    <servlet>
        <servlet-name>dispatcher</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    </servlet>
 
    <servlet-mapping>
        <servlet-name>dispatcher</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
 
</web-app>
 
-----------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
 
    <context:component-scan base-package="forum.forum" />
 
    <context:component-scan base-package="config" />
 
    <mvc:annotation-driven />
 
    <bean id="viewResolver"
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix">
            <value>/WEB-INF/views/</value>
        </property>
        <property name="suffix">
            <value>.jsp</value>
        </property>
    </bean>
 
<mvc:resources location="/assets/" mapping="/resources/**" />
 
</beans>
 
-----------------------------------------------------------------------------------
project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>forum.forum</groupId>
    <artifactId>forum.forum</artifactId>
    <packaging>war</packaging>
    <version>0.0.1-SNAPSHOT</version>
    <name>forum.forum Maven Webapp</name>
    <url>http://maven.apache.org</url>
 
    <properties>
        <javaee.version>7.0</javaee.version>
        <spring.version>4.3.6.RELEASE</spring.version>
        <hibernate.version>5.2.7.Final</hibernate.version>
    </properties>
 
    <dependencies>
        <!-- Java EE -->
        <dependency>
            <groupId>javax</groupId>
            <artifactId>javaee-api</artifactId>
            <version>${javaee.version}</version>
            <scope>provided</scope>
        </dependency>
 
        <!-- Servlet -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>
 
        <!-- JUnit -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>3.8.1</version>
            <scope>test</scope>
        </dependency>
 
        <!-- Spring -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>${spring.version}</version>
        </dependency>
 
        <!-- JSTL -->
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
 
        <!-- Database -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.1.1</version>
        </dependency>
 
        <!-- Hibernate -->
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>${hibernate.version}</version>
        </dependency>
 
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                </configuration>
            </plugin>
        </plugins>
        <finalName>forum.forum</finalName>
    </build>
</project>
------------------------------------------------------------------------------------------------
package forum.forum.dao;
 
import java.util.List;
 
import forum.forum.dto.Kategoria;
 
public interface IKategoria {
 
    public List<Kategoria> pobierzKategorie();
 
------------------------------------------------------------------------------------------------    
package forum.forum.dao;
 
import java.util.ArrayList;
import java.util.List;
 
import javax.transaction.Transactional;
 
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
 
import forum.forum.dto.Kategoria;
 
@Repository
@Transactional
public class IKategoriaImpl implements IKategoria {
 
    @Autowired
    private SessionFactory sessionFactory;
 
    public IKategoriaImpl(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }
 
    @Override
    @Transactional
    public List<Kategoria> pobierzKategorie() {
        String pobierzKategorie = "from Kategoria";
        return sessionFactory
                .getCurrentSession()
                    .createQuery(pobierzKategorie, Kategoria.class)
                            .getResultList();
 
    }
 
}
--------------------------------------------------------------------------------
package forum.forum.dao;
 
import java.util.List;
 
import forum.forum.dto.Temat;
 
public interface ITemat {
 
    public List<Temat> pobierzTematy();
    public List<Temat> pobierzPoKategori(String id);
    public List pobierzIloscTematowWKategori(String id);
 
}
--------------------------------------------------------------------------------
package forum.forum.dao;
 
import java.util.List;
 
import javax.transaction.Transactional;
 
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
 
import forum.forum.dto.Temat;
 
@Repository
 
public class ITematImpl implements ITemat {
    @Autowired
    private SessionFactory sessionFactory;
 
    public ITematImpl(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }
    @Override
    @Transactional
    public List<Temat> pobierzTematy() {
        String pobierzTematy = "from Temat t ORDER BY t.data DESC";
        return sessionFactory
                .getCurrentSession()
                    .createQuery(pobierzTematy, Temat.class)
                        .getResultList();
    }
 
    @Override
    @Transactional
    public List<Temat> pobierzPoKategori(String id){
        String pobierzPoKategori = "from pl.forum.encje.Temat t where t.kategoria= :id ORDER BY t.data DESC";
        return sessionFactory
                .getCurrentSession()
                    .createQuery(pobierzPoKategori, Temat.class)
                        .setParameter("id", id)
                            .getResultList();
    }
    @Override
    @Transactional
    public List pobierzIloscTematowWKategori(String id){
        String pobierzIlosc = "select count(t) from pl.forum.encje.Temat t where t.kategoria= :id";
        return sessionFactory
                .getCurrentSession()
                    .createQuery(pobierzIlosc, Temat.class)
                        .setParameter("id", id)
                            .getResultList();
    }
}
----------------------------------------------------------------------------------------------
package forum.forum.controller;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;
 
import forum.forum.dao.IKategoria;
import forum.forum.dao.ITemat;
 
@Controller
public class PageController {
 
    @Autowired
    private IKategoria iKategoria;
    @Autowired
    private ITemat iTemat;
 
    @RequestMapping(value = {"/", "/home", "/index"})
    public ModelAndView index() {
        ModelAndView mv = new ModelAndView("page");
        mv.addObject("greeting", "welcome");
        return mv;
    }
    @RequestMapping(value = {"/login"})
    public ModelAndView login() {
        ModelAndView mv = new ModelAndView("login");
        mv.addObject("greeting", "welcome");
        return mv;
    }
    @RequestMapping(value = {"/start"}, method=RequestMethod.GET)
    public ModelAndView start() {
        ModelAndView mv = new ModelAndView("index");
 
        mv.addObject("kategorie", iKategoria.pobierzKategorie());
        mv.addObject("tematy", iTemat.pobierzTematy());
 
        return mv;
    }
 
}
---------------------------------------------------------------------------------------------
package config;
 
import java.util.Properties;
 
import javax.sql.DataSource;
 
import org.apache.commons.dbcp2.BasicDataSource;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.orm.hibernate5.HibernateTransactionManager;
import org.springframework.orm.hibernate5.LocalSessionFactoryBuilder;
import org.springframework.transaction.annotation.EnableTransactionManagement;
 
@Configuration
@ComponentScan(basePackages= {"forum.forum.dto"})
@EnableTransactionManagement
public class HibernateConfig {
 
    private final static String DATABASE_URL = "jdbc:mysql://localhost:3306/mojabaza?useSSL=false";
    private final static String DATABASE_DRIVER = "com.mysql.jdbc.Driver";
    private final static String DATABASE_DIALECT = "org.hibernate.dialect.MySQLDialect";
    private final static String DATABASE_USERNAME = "root";
    private final static String DATABASE_PASSWORD = "Mz8jpg5a1";
 
    @Bean
    public DataSource getDataSource() {
        BasicDataSource dataSource = new BasicDataSource();
 
        dataSource.setDriverClassName(DATABASE_DRIVER);
        dataSource.setUrl(DATABASE_URL);
        dataSource.setUsername(DATABASE_USERNAME);
        dataSource.setPassword(DATABASE_PASSWORD);
 
        return dataSource;
    }
 
    @Bean
    public SessionFactory getSessionFactory(DataSource dataSource) {
        LocalSessionFactoryBuilder builder = new LocalSessionFactoryBuilder(dataSource);
        builder.addProperties(getHibernateProperties());
        builder.scanPackages("forum.forum.dto");
 
        return builder.buildSessionFactory();
    }
 
    private Properties getHibernateProperties() {
        Properties properties = new Properties();
 
        properties.put("hibernate.dialect", DATABASE_DIALECT);
        properties.put("hibernate.show_sql", "true");
        properties.put("hibernate.format_sql", "true");
 
        return properties;
    }
    @Bean
    @Autowired
    public HibernateTransactionManager getTransactionManager(SessionFactory sessionFactory) {
        HibernateTransactionManager transactionManager = new HibernateTransactionManager(sessionFactory);
 
        return transactionManager;
    }
}