Hibernate: delete from facility where id=?
2021-09-11 02:43:39.384  WARN 7 --- [nio-8080-exec-6] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23503
2021-09-11 02:43:39.384 ERROR 7 --- [nio-8080-exec-6] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: update or delete on table "facility" violates foreign key constraint "fk_borehole_facility_id" on table "borehole"
  Detail: Key (id)=(117) is still referenced from table "borehole".
2021-09-11 02:43:39.384  INFO 7 --- [nio-8080-exec-6] o.h.e.j.b.internal.AbstractBatchImpl     : HHH000010: On release of batch it still contained JDBC statements
2021-09-11 02:43:39.388 ERROR 7 --- [nio-8080-exec-6] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [fk_borehole_facility_id]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause

org.postgresql.util.PSQLException: ERROR: update or delete on table "facility" violates foreign key constraint "fk_borehole_facility_id" on table "borehole"
  Detail: Key (id)=(117) is still referenced from table "borehole".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2505) ~[postgresql-42.2.9.jar!/:42.2.9]