Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Referring specifically to the choice of whether to use DECLARE EXIT HANDLER FOR SQLEXCEPTION. If you use it, you swallow errors and there doesn't seem to be any way to access them programmatically, at least up to 5.5. If you don't use it, you leak transactions, and drivers such as JDBC auto-commit them instead of aborting them.

What gives? This sounds... awful.

share|improve this question

migrated from Sep 17 '13 at 20:50

This question came from our site for professional programmers interested in conceptual questions about software development.

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.