From the course: Advanced SQL for Application Development

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Database errors

Database errors

From the course: Advanced SQL for Application Development

Start my 1-month free trial

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