SQLSTATE error codes

Applies to: Databricks SQL Databricks Runtime 12.2 and above

All error classes returned by Azure Databricks are associated with a 5 character SQLSTATE. A SQLSTATE is a SQL standard encoding for error conditions commonly used by JDBC, ODBC, and other client APIs.

A SQLSTATE consists of two portions: A two character class, and a three character subclass. Each character must be a digit '0' to '9' or 'A' to 'Z'.

While many SQLSTATE values are prescribed by the SQL standard, others are common in the industry, specific to Spark, or Azure Databricks.

Where necessary Spark and Azure Databricks use the 'KD' class and 'K**' subclass ranges for custom SQLSTATEs. The class 'XX' is used for internal errors warranting a bug report.

For an ordered list of error classes see: Error handling in Azure Databricks

Azure Databricks uses the following SQLSTATE classes:

Class 01: warning

Class 02: no data

Class 07: dynamic SQL error

Class 08: connection exception

Class 0A: feature not supported

Class 0B: invalid transaction initiation

Class 0K: resignal when handler not active

Class 0N: SQL/XML mapping error

Class 21: cardinality violation

Class 22: data exception

Class 23: integrity constraint violation

Class 24: invalid cursor state

Class 25: invalid transaction state

Class 28: invalid authorization specification

Class 2B: dependent privilege descriptors still exist

Class 2D: invalid transaction termination

Class 35: invalid condition number

Class 38: external routine exception

Class 39: external routine invocation exception

Class 3D: invalid catalog name

Class 3F: invalid schema name

Class 40: transaction rollback

Class 42: syntax error or access rule violation