SQL Return Codes
The framework generally returns the database-specific return codes from SQL execution. However, the framework returns SPL-specific return codes for commonly-used SQL execution result messages. These SPL-specific return codes are the same regardless of the database. This allows programs to be portable across different databases.
The following lists the SPL-specific return codes:
SQL Execution Result | SPL Return Code |
---|
OK | 0 |
* Unnumbered SQL Error | 999999990 |
Warning | 999999991 |
End / no (more) row retrieved | 999999992 |
Duplicate / unique index violation | 999999993 |
More / multiple rows retrieved in single-row select | 999999994 |
Deadlock | 999999995 |
No connection | 999999996 |
* Application Error | 999999997 |
* Hibernate Error | 999999998 |
* Programmatic Error | 999999999 |
Note:
The SQL return codes marked with an asterisk ("*") are for errors peripheral to the actual execution of the SQL and do not have equivalent database return codes.
Parent topic