search

STBGFC / footy

Football club management app and modules (developed for kid's footy club/leagues)
2 stars 0 forks source link

Still unable to delete a team from the UI (constraint violations) #107

Closed davison closed 9 years ago

davison commented 10 years ago

2014-10-14 12:42:43,853 [http-bio-8080-exec-12] ERROR util.JDBCExceptionReporter - ERROR: update or delete on table "match_resource" violates foreign key constraint "fk6d4b4a3ec3ab8 1f6" on table "fixture_match_resource" Detail: Key (id)=(6) is still referenced from table "fixture_match_resource". 2014-10-14 12:42:43,853 [http-bio-8080-exec-12] ERROR def.AbstractFlushingEventListener - Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: could not delete: [org.davisononline.footy.match.MatchResource#6] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ... Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "match_resource" violates foreign key constraint "fk6d4b4a3ec3ab81f6" on table "fixture_match_resource" Detail: Key (id)=(6) is still referenced from table "fixture_match_resource". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)

davison commented 9 years ago

now removes MatchResource instances explicity