From the course: Advanced SQL for Application Development

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Database errors

Database errors

- [Narrator] An important key to ensuring that our applications are reliable is handling database errors. We're probably all familiar with Murphy's Law that whatever can go wrong will go wrong, and let's just take a look at how many different ways things can go wrong in a database application. First of all, there can be interface errors and that has to do with interfaces to the database. There could be errors within the database itself. It could have errors regarding how we work with the data. There could be operational errors, integrity errors, especially around how we're handling data and working with constraints. There could be some internal error to the RDBMS. There could also be programming errors on our part, and we may try to do things that actually aren't supported by that particular database, so let's take a look at each of these in a little more detail. Now, here are some examples of interface and database…

Contents