Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 programmers.stackexchange.com Sep 17 '13 at 20:50

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

add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.