HTTP Status 500 – Internal Server Error

Type Exception Report

Message Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
    org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

-- MySQL Script generated by MySQL Workbench
-- Thu Jul  6 11:34:33 2017
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema Form
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema Form
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `Form` DEFAULT CHARACTER SET latin1 ;
USE `Form` ;

-- -----------------------------------------------------
-- Table `Form`.`users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Form`.`users` (
  `id` INT(11) NOT NULL,
  `name` VARCHAR(30) NOT NULL,
  `email` VARCHAR(50) NOT NULL,
  `address` VARCHAR(255) NOT NULL,
  `password` VARCHAR(20) NOT NULL,
  `newsletter` TINYINT(1) NOT NULL,
  `framework` VARCHAR(500) NOT NULL,
  `sex` VARCHAR(1) NOT NULL,
  `number` INT(11) NOT NULL,
  `country` VARCHAR(10) NOT NULL,
  `skill` VARCHAR(500) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

@Controller
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping(value = "/", method = RequestMethod.GET)
    public String showHome() {

        logger.debug("showHome()");
        return "redirect:/users";
    }

    @RequestMapping(value = "/users", method = RequestMethod.GET)
    public String showAllUsers(Model model) {

        logger.debug("showAllUsers()");
        model.addAttribute("users", userService.findAllUsers());
        return "users/list";
    }
}

public interface UserService {

    User findByID(Integer id);

    List<User> findAllUsers();

    void saveOrUpdate(User user);

    void delete(Integer id);
}


@Service("userService")
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDao userDao;

    public User findByID(Integer id) {

        return null;
    }

    public List<User> findAllUsers() {

        return userDao.getAllUsers();
    }

    public void saveOrUpdate(User user) {

    }

    public void delete(Integer id) {

    }
}

public abstract class HibernateDaoSupport {

    @Autowired
    private SessionFactory sessionFactory;

    public SessionFactory getSessionFactory(){
        return sessionFactory;
    }
}


public interface UserDao {

    User findById(Integer id);

    List<User> getAllUsers();

    void save(User user);

    void update(User user);

    void delete(Integer id);
}



@Repository
public class UserDaoImpl extends HibernateDaoSupport implements UserDao {

    public User findById(Integer id) {
        return null;
    }

    public List<User> getAllUsers() {

        try {
            Session session = getSessionFactory().openSession();
             List<User> users = session.createQuery("from User").getResultList();

            return users;
        } catch (HibernateException e) {
            e.printStackTrace();
        }

        return null;
    }

    public void save(User user) {

    }

    public void update(User user) {

    }

    public void delete(Integer id) {

    }
}