Map Database exception to Http status code

Question

When I try to delete an entity in my database I get a ForeignKey Constraint Exception.

I expect that exception, handle it on the server but also want to handle it on the client.

What status code should I use to say: You can not delete this entity and prevent on the client side the deletion of the entity in the UI.

Something in the 4xx range. My suggestion would be `>= 470`. — Sam Axe, Feb 03 '16 at 21:59
What I wanted to say is: https://en.wikipedia.org/wiki/List_of_HTTP_status_codes There is no 470 status code or higher in 4xx range. — Pascal, Feb 03 '16 at 22:19
That is a list of status codes that have either w3c definitions, or industry accepted definitions. You don't wasn't to have your custom code conflicting with a "defined" code - that would lead to insanity! Choose a code that doesn't have an existing definition. — Sam Axe, Feb 03 '16 at 22:21
aaahhh. you mean a custom http code just for my purpose? Ok understand. — Pascal, Feb 03 '16 at 22:39

score 1 · Answer 1 · edited Feb 03 '16 at 22:12

1

There is only one real "exception" code - 500.

For some operations code from 4xx range may be suitable. Maybe "403-forbidden" wold be ok for this case.

If you need to have more comprehensive client side handling - send 200 with response including error information with empty value instead of result.

edited Feb 03 '16 at 22:12

Sam Axe

answered Feb 03 '16 at 22:00

Alexei Levenkov

Hey Alexei, This exception is valid. I expect it. This can not be 500. – Pascal Feb 03 '16 at 22:04

1 Answers1