Is There a Way to Retry a Database?

If you've got sort of networked error or something, all the retries in the world aren't going to work. And also sometimes retrying isn't going to help at all. This is actually a time when it makes sense to have an error trapping so that if I get a constraint exception from the database? Because if I did, then I know that this thing's never going to work again.