Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. org.postgresql.util.PSQLException: Колонки id не найдено в этом ResultSet’’е.
  2.  
  3. CREATE OR REPLACE FUNCTION lease_objects.get_lease_object(cleint_uid text)
  4. RETURNS refcursor
  5. LANGUAGE plpgsql
  6. AS $$
  7. declare
  8. cur refcursor;
  9. query text;
  10. begin
  11. query :=
  12. 'select
  13. l.id as id,
  14. l.client_uid as client_uid,
  15. l.equipment_uid as equipment_uid,
  16. l.lease_contract_uid as lease_contract_uid,
  17. l.product_uid as product_uid
  18. from lease_objects.lease_object l
  19. where l.client_uid = $1';
  20. open cur for
  21. execute query using cleint_uid;
  22. return cur;
  23. END;
  24. $$
  25.  
  26. @Data
  27. @Entity
  28. @Table(name = "lease_object", schema = "lease_objects")
  29. public class LeaseObject implements Serializable {
  30.  
  31. @Id
  32. @GeneratedValue(strategy = GenerationType.IDENTITY)
  33. @Column(name = "id")
  34. @JsonIgnore
  35. private String id;
  36.  
  37. @Column(name = "client_uid")
  38. private String clientUid;
  39.  
  40. @Column(name = "equipment_uid")
  41. private String equipmentUid;
  42.  
  43. @OneToOne(cascade = CascadeType.ALL)
  44. @JoinColumn(name = "product_uid", referencedColumnName = "uid")
  45. private Product product;
  46.  
  47. @OneToOne(cascade = CascadeType.ALL)
  48. @JoinColumn(name = "lease_contract_uid", referencedColumnName = "uid")
  49. private LeaseContract leaseContract;
  50. }
  51.  
  52. @Override
  53. public List getLeaseObject(@NonNull String clientUid, String equipmentUid, String productUid, String productStatus) {
  54. return entityManager
  55. .createStoredProcedureQuery("lease_objects.get_lease_object", LeaseObject.class)
  56. .registerStoredProcedureParameter("clientUid", String.class, ParameterMode.IN)
  57. .setParameter("clientUid", clientUid)
  58. .getResultList();
  59. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement