- 6.9.12.1 errorcode Module
- 6.9.12.2 errors.Error Exception
- 6.9.12.3 errors.DataError Exception
- 6.9.12.4 errors.DatabaseError Exception
- 6.9.12.5 errors.IntegrityError Exception
- 6.9.12.6 errors.InterfaceError Exception
- 6.9.12.7 errors.InternalError Exception
- 6.9.12.8 errors.NotSupportedError Exception
- 6.9.12.9 errors.OperationalError Exception
- 6.9.12.10 errors.PoolError Exception
- 6.9.12.11 errors.ProgrammingError Exception
- 6.9.12.12 errors.Warning Exception
- 6.9.12.13 errors.custom_error_exception() Function
Themysql.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 importmysql.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.
米ySQL Server errors are mapped with Python exception based on their SQLSTATE value (seeServer Error Message Reference). 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 isDatabaseError
.
Table 6.3 Mapping of Server Errors to Python Exceptions
SQLSTATE Class | Connector/Python Exception |
---|---|
02 |
DataError |
02 |
DataError |
07 |
DatabaseError |
08 |
OperationalError |
0A |
NotSupportedError |
21 |
DataError |
22 |
DataError |
23 |
IntegrityError |
24 |
ProgrammingError |
25 |
ProgrammingError |
26 |
ProgrammingError |
27 |
ProgrammingError |
28 |
ProgrammingError |
2A |
ProgrammingError |
2B |
DatabaseError |
2C |
ProgrammingError |
2D |
DatabaseError |
2E |
DatabaseError |
33 |
DatabaseError |
34 |
ProgrammingError |
35 |
ProgrammingError |
37 |
ProgrammingError |
3C |
ProgrammingError |
3D |
ProgrammingError |
3F |
ProgrammingError |
40 |
InternalError |
42 |
ProgrammingError |
44 |
InternalError |
HZ |
OperationalError |
XA |
IntegrityError |
0K |
OperationalError |
HY |
DatabaseError |