Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- org.postgresql.util.PSQLException: Колонки id не найдено в этом ResultSet’’е.
- CREATE OR REPLACE FUNCTION lease_objects.get_lease_object(cleint_uid text)
- RETURNS refcursor
- LANGUAGE plpgsql
- AS $$
- declare
- cur refcursor;
- query text;
- begin
- query :=
- 'select
- l.id as id,
- l.client_uid as client_uid,
- l.equipment_uid as equipment_uid,
- l.lease_contract_uid as lease_contract_uid,
- l.product_uid as product_uid
- from lease_objects.lease_object l
- where l.client_uid = $1';
- open cur for
- execute query using cleint_uid;
- return cur;
- END;
- $$
- @Data
- @Entity
- @Table(name = "lease_object", schema = "lease_objects")
- public class LeaseObject implements Serializable {
- @Id
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- @Column(name = "id")
- @JsonIgnore
- private String id;
- @Column(name = "client_uid")
- private String clientUid;
- @Column(name = "equipment_uid")
- private String equipmentUid;
- @OneToOne(cascade = CascadeType.ALL)
- @JoinColumn(name = "product_uid", referencedColumnName = "uid")
- private Product product;
- @OneToOne(cascade = CascadeType.ALL)
- @JoinColumn(name = "lease_contract_uid", referencedColumnName = "uid")
- private LeaseContract leaseContract;
- }
- @Override
- public List getLeaseObject(@NonNull String clientUid, String equipmentUid, String productUid, String productStatus) {
- return entityManager
- .createStoredProcedureQuery("lease_objects.get_lease_object", LeaseObject.class)
- .registerStoredProcedureParameter("clientUid", String.class, ParameterMode.IN)
- .setParameter("clientUid", clientUid)
- .getResultList();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement