Sqlgrammarexception

Question

Good night! Someone can help me with the error in my code, I followed the teacher’s steps but presents error in mine and not in his example. I am using the same dependencies. Follow the method snippet and the error.

public List<Person> findByLastName(String lastName){
    String jpql = "from Person p where p.lastName like ?";

    return find(jpql, lastName);
}   

private static void findByLastName() {
    List<Person> persons = new PersonDAO().findByLastName("Figueira");

    for (Person person : persons) {
        System.out.println(person.toString());      
    }
}

Makes that mistake:

com.mysql.jdbc.exceptions.jdbc4.Mysqlsyntaxerrorexception: You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server version for the right syntax to use near 'from Person p Where p.lastname like 'Figueira'' at line 1

Answer 1

How are you using JPQL ofJPA you have to put the SELECT for your JPQL. The HQL is the one who agrees to omit the SELECT.

public List<Person> findByLastName(String lastName){
    String jpql = "SELECT p FROM Person p WHERE p.lastName LIKE ?";

    return find(jpql, lastName);
}   

https://docs.spring.io/spring-data/jpa/docs/1.5.0.RELEASE/reference/html/jpa.repositories.html