在HIbernate中调用存储过程时未找到列“id”

Question

我在Mysql中创建了一个存储过程，并尝试使用J2EE/Hibernate调用该存储过程。在执行存储过程时，其显示me错误。

2018年03月04日上午12:06:18 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions错误：找不到列“ID”。

执行SP:org.hibernate.exception.sqlgrammareXception时发生错误：无法执行查询

我没有在存储过程中提到id，但它仍然显示关于id的错误。

@Entity
public class User {

@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private int id;
private String firstName;
private String lastName;

public int getId() {
    return id;
}
public void setId(int id) {
    this.id = id;
}
public String getFirstName() {
    return firstName;
}
public void setFirstName(String firstName) {
    this.firstName = firstName;
}
public String getLastName() {
    return lastName;
}
public void setLastName(String lastName) {
    this.lastName = lastName;
}
}

public List<User> searchUserListWithSP(String firstName,String lastName) {

    List<User> userList = new ArrayList<>();
    try{
        SessionFactory factory = HibernateUtility.getSessionFactory();
        Session session = factory.getCurrentSession();
        session.beginTransaction();

        Query query = session.createSQLQuery("call getUserData(:firstName,:lastName)")      
                .addEntity(User.class)
                .setParameter("firstName", firstName)
                .setParameter("lastName", lastName);

        userList = query.list();

        System.out.println(userList);

    } catch(Exception e) {
        System.out.println("Error occured while executing SP : "+e);
    }
    System.out.println("UserDao @searchUserListWithSP -- END");
    return userList;
}

getUserData.sql（存储过程）

delimiter //

drop procedure if exists getUserData//
create procedure getUserData(
in firstName varchar(50),
in lastName varchar(50)
)
begin

declare queryString text default "";

set queryString = concat(queryString, 'select u.firstName, u.lastName from user u where 1=1');

if (firstName is not null and firstName != '') then
    set queryString = concat(queryString," and firstName like '%", firstName,"%' ");
end if;

if (lastName is not null and lastName != '') then
    set queryString = concat(queryString," and lastName like '%", lastName,"%' ");
end if;

set queryString = concat(queryString, ";");

-- select queryString;
SET @SQL := queryString;
prepare stmt from @SQL;
execute stmt;
deallocate prepare stmt;

end//

因此，在从UserDao执行存储过程时，我得到了这个错误。我已经找过了，但没有找到任何具体的东西。如果我在存储过程select语句中添加id，那么它将解决问题，但是对于其他字段显示错误。

Answer 1

请参阅本文，这将有助于理解addEntity（）方法的概念

http://www.programering.com/a/mdm0ajmwaty.html