LispWorks User Guide and Reference Manual > 19 Common SQL > 19.8 Error handling in Common SQL

NextPrevUpTopContentsIndex

19.8.1 SQL condition classes

An sql-user-error is an error inside Lisp.

An sql-database-error is an error inside the database interface that Lisp uses.

The following are subclasses of sql-database-error:

sql-database-data-error

An error with the data given. It signifies an error that must be fixed for the code to work.

sql-timeout-error

Signifies an error that is a result of other users using the same database. It means the code can work without change, once the other users stop using the database.

sql-connection-error

An error with the connection to the RDBMS.

The following are subclasses of sql-connection-error:

sql-timeout-error

A timeout with some operation.

sql-fatal-error

An error which means that the connection is no longer usable.

Note: In general, the documentation for the various supported databases make it difficult to decide which error code should be made into which of the above condition class, and we probably get many of these wrong. If you find errors that seem to be signalled with the wrong condition class, please report them to Lisp Support, including the full printout of the condition, and we will fix it.


LispWorks User Guide and Reference Manual - 22 Dec 2009

NextPrevUpTopContentsIndex