使用Hibernate调用存储过程(Call stored procedure with Hibernate)

 我想用hibernate从PostgreSQL调用存储过程。 但是，如果我通过entitymanager.getResultList调用此过程，它将返回一个具有奇怪属性名称的对象列表。 程序： 
 
CREATE OR REPLACE FUNCTION public.show_top10()
  RETURNS SETOF users
AS
$BODY$
  SELECT * FROM users
    ORDER BY message_count DESC
    LIMIT 10;
$BODY$
LANGUAGE sql VOLATILE;
 
 用户的属性： 
 
private Integer id;
private String login;
private String password;
private Timestamp dateCreated;
private Long messageCount;
private Integer role;
private Collection<Message> messagesById;
 
 呼叫： 
 
List<Users> result = null;
            StoredProcedureQuery storedProcedureQuery= entityManager.createStoredProcedureQuery("show_top10");
            storedProcedureQuery.execute();
            result = storedProcedureQuery.getResultList();
            entityManager.getTransaction().commit();
 
 结果： 
 

I want to call stored procedure from PostgreSQL with hibernate. But, if i call this procedure throught entitymanager.getResultList, it's return me a list of objects with strange names of attributes. Procedure:
 
CREATE OR REPLACE FUNCTION public.show_top10()
  RETURNS SETOF users
AS
$BODY$
  SELECT * FROM users
    ORDER BY message_count DESC
    LIMIT 10;
$BODY$
LANGUAGE sql VOLATILE;
 
User's atributes:
 
private Integer id;
private String login;
private String password;
private Timestamp dateCreated;
private Long messageCount;
private Integer role;
private Collection<Message> messagesById;
 
Calling:
 
List<Users> result = null;
            StoredProcedureQuery storedProcedureQuery= entityManager.createStoredProcedureQuery("show_top10");
            storedProcedureQuery.execute();
            result = storedProcedureQuery.getResultList();
            entityManager.getTransaction().commit();
 
And result:
 

原文：https://stackoverflow.com/questions/29327866