Error Codes with Properties Files or Database

I'm about to implement Error codes for my company API, so, based on rfc7807 I will include a type which is an error type which is basically an error category, and inside those categories we have a bunch of error codes, so, I'm stuck thinking/searching what's the best approach to follow, I mean, if i handle these error categories/codes in database, I'll need to define an enum with the codes to lookup in database their descriptions.. So this doesn't sound maintainable, because although the codes are in DB and it doesn't depends on the application server to deploy, everytime i define an error code or category in database i'll need to define it in the enum which sucks. but seems like there's no other way to handle it, thing is, i need this error handling to work in several distributed units (microservices, some monoliths, etc) so what could be a good approach ?

Apr 1, 2025 - 22:19

I'm about to implement Error codes for my company API, so, based on rfc7807 I will include a type which is an error type which is basically an error category, and inside those categories we have a bunch of error codes, so, I'm stuck thinking/searching what's the best approach to follow, I mean, if i handle these error categories/codes in database, I'll need to define an enum with the codes to lookup in database their descriptions..

So this doesn't sound maintainable, because although the codes are in DB and it doesn't depends on the application server to deploy, everytime i define an error code or category in database i'll need to define it in the enum which sucks.

but seems like there's no other way to handle it, thing is, i need this error handling to work in several distributed units (microservices, some monoliths, etc) so what could be a good approach ?