Documentation Home
MySQL Connector/Python Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb
EPUB - 138.0Kb
HTML Download (TGZ) - 85.6Kb
HTML Download (Zip) - 103.4Kb


10.12 Errors and Exceptions

The mysql.connector.errors module defines exception classes for errors and warnings raised by MySQL Connector/Python. Most classes defined in this module are available when you import mysql.connector.

The exception classes defined in this module mostly follow the Python Database API Specification v2.0 (PEP 249). For some MySQL client or server errors it is not always clear which exception to raise. It is good to discuss whether an error should be reclassified by opening a bug report.

MySQL Server errors are mapped with Python exception based on their SQLSTATE value (see Server Error Codes and Messages). The following table shows the SQLSTATE classes and the exception Connector/Python raises. It is, however, possible to redefine which exception is raised for each server error. The default exception is DatabaseError.

Table 10.1 Mapping of Server Errors to Python Exceptions

SQLSTATE ClassConnector/Python Exception
02DataError
02DataError
07DatabaseError
08OperationalError
0ANotSupportedError
21DataError
22DataError
23IntegrityError
24ProgrammingError
25ProgrammingError
26ProgrammingError
27ProgrammingError
28ProgrammingError
2AProgrammingError
2BDatabaseError
2CProgrammingError
2DDatabaseError
2EDatabaseError
33DatabaseError
34ProgrammingError
35ProgrammingError
37ProgrammingError
3CProgrammingError
3DProgrammingError
3FProgrammingError
40InternalError
42ProgrammingError
44InternalError
HZOperationalError
XAIntegrityError
0KOperationalError
HYDatabaseError


User Comments
Sign Up Login You must be logged in to post a comment.