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.