Login | Register
My pages Projects Community openCollabNet

Axion: SQL Error Codes

Standard SQL99 error codes and error messages are listed below. In most cases the numeric Axion vendor code (VC) is equivalent to the 5-character SQL99 error code. Otherwise, the vendor code (VC) is shown at the end of the error message.

The list is ordered according to SQL99 error classes. Note that Axion currently raises only a small subset of these error codes.


successful completion

  • 00000 successful completion

warning

  • 01000 warning
  • 01001 warning: cursor operation conflict
  • 01002 warning: disconnect error
  • 01003 warning: null value eliminated in set function
  • 01004 warning: string data, right truncation
  • 01005 warning: insufficient item descriptor areas
  • 01006 warning: privilege not revoked
  • 01007 warning: privilege not granted
  • 01009 warning: search condition too long for information schema
  • 0100A warning: query expression too long for information schema (VC: 2010001 )
  • 0100B warning: default value too long for information schema (VC: 2010002 )
  • 0100C warning: dynamic result sets returned (VC: 2010003 )
  • 0100D warning: additional result sets returned (VC: 2010004 )
  • 0100E warning: attempt to return too many result sets (VC: 2010005 )
  • 0100F warning: statement too long for information schema (VC: 2010206 )
  • 0102F warning: array data, right truncation (VC: 201206 )


no data

  • 02000 no data
  • 02001 no data: no additional dynamic result sets returned


dynamic SQL error

  • 07000 dynamic SQL error
  • 07001 dynamic SQL error: using clause does not match dynamic parameter specifications
  • 07002 dynamic SQL error: using clause does not match target specifications
  • 07003 dynamic SQL error: cursor specification cannot be executed
  • 07004 dynamic SQL error: using clause required for dynamic parameters
  • 07005 dynamic SQL error: prepared statement not a cursor specification
  • 07006 dynamic SQL error: restricted data type attribute violation
  • 07007 dynamic SQL error: using clause required for result fields
  • 07008 dynamic SQL error: invalid descriptor count
  • 07009 dynamic SQL error: invalid descriptor index
  • 0700B dynamic SQL error: data type transform function violation (VC: 2070002 )
  • 0700C dynamic SQL error: undefined DATA value (VC: 2070003 )
  • 0700D dynamic SQL error: invalid DATA target (VC: 2070004 )
  • 0700E dynamic SQL error: invalid LEVEL value (VC: 2070005 )
  • 0700F dynamic SQL error: invalid DATETIME_INTERVAL_CODE (VC: 2070006 )


connection exception

  • 08000 connection exception
  • 08001 connection exception: SQL-client unable to establish SQL-connection
  • 08002 connection exception: connection name in use
  • 08003 connection exception: connection does not exist
  • 08004 connection exception: SQL-client unable to establish SQL-connection
  • 08006 connection exception: connection failure
  • 08007 connection exception: transaction resolution unknown


triggered action exception

  • 09000 triggered action exception


feature not supported

  • 0A000 feature not supported (VC: 1001000 )
  • 0A001 feature not supported: multiple server transactions (VC: 1001001 )


invalid transaction initiation

  • 0B000 invalid transaction initiation (VC: 1002000 )


invalid target type specification

  • 0D000 invalid target type specification (VC: 1004000 )


invalid schema name list specification

  • 0E000 invalid schema name list specification (VC: 1005000 )


locator exception

  • 0F000 locator exception (VC: 1006000 )
  • 0F001 locator exception: invalid specification (VC: 1060001 )


invalid grantor

  • 0L000 invalid grantor (VC: 1012000 )


invalid SQL-invoked procedure reference

  • 0M000 invalid SQL-invoked procedure reference (VC: 1013000 )


invalid role specification

  • 0P000 invalid role specification (VC: 1016000 )


invalid transform group name specification

  • 1019000 invalid transform group name specification (VC: 1010000 )


target table disagrees with cursor specification

  • 0T000 target table disagrees with cursor specification (VC: 1020000 )


attemtp to assign to non-updatable column

  • 0U000 attemtp to assign to non-updatable column (VC: 1021000 )


attempt to assign to ordering column

  • 0V000 attempt to assign to ordering column (VC: 1022000 )


prohibited statement encountered during trigger execution

  • 0W000 prohibited statement encountered during trigger execution (VC: 1023000 )


diagnostics exception

  • 0Z000 diagnostics exception (VC: 1026000 )
  • 0Z001 diagnostics exception: maximum number of stacked diagnostics areas exceeded (VC: 1026001 )


cardinality violation

  • 21000 cardinality violation


data exception

  • 22000 data exception
  • 22001 data exception: string data, right truncation
  • 22002 data exception: null value, no indicator parameter
  • 22003 data exception: numeric value out of range
  • 22004 data exception: null value not allowed
  • 22005 data exception: error in assignment
  • 22006 data exception: invalid interval format
  • 22007 data exception: invalid datetime format
  • 22008 data exception: datetime field overflow
  • 22009 data exception: invalid time zone displacement value
  • 2200B data exception: escape character conflict (VC: 2220002 )
  • 2200C data exception: invalid use of escape character (VC: 2220003 )
  • 2200F data exception: invalid escape octet (VC: 222004 )
  • 2200E data exception: null value in array target (VC: 2220005 )
  • 2200F data exception: zero-length character string (VC: 2220006 )
  • 2200G data exception: most specific type mismatch (VC: 2220007 )
  • 2200H data exception: sequence generator limit exceeded (VC: 2220008 )
  • 2200P data exception: interval value out of range (VC: 2220016 )
  • 2200Q data exception: multiset value overflow (VC: 2220017 )
  • 22010 data exception: invalid indicator parameter value
  • 22011 data exception: substring error
  • 22012 data exception: division by zero
  • 22013 data exception: invalid preceding or following size in window function
  • 22015 data exception: interval field overflow
  • 22018 data exception: invalid character value for cast
  • 22019 data exception: invalid escape character
  • 2201B data exception: invalid regular expression (VC: 2220102 )
  • 2201C data exception: null row not permitted in table (VC: 2220103 )
  • 2201E data exception: invalid argument for natural logarithm (VC: 2220104 )
  • 2201F data exception: invalid argument for power function (VC: 2220105 )
  • 2201G data exception: invalid argument for width bucket function (VC: 2220106 )
  • 22021 data exception: character not in repertoire
  • 22022 data exception: indicator overflow
  • 22023 data exception: invalid parameter value
  • 22024 data exception: unterminated C string
  • 22025 data exception: invalid escape sequence
  • 22026 data exception: string data, length mismatch
  • 22027 data exception: trim error
  • 22029 data exception: noncharacter in UCS string
  • 2202D data exception: null value substituted for mutator subject parameter (VC: 2220204 )
  • 2202E data exception: array element error (VC: 2220205 )
  • 2202F data exception: array data, right truncation (VC: 2220206 )
  • 2202G data exception: invalid repeat argument in a sample clause (VC: 2220207 )
  • 2202H data exception: invalid sample size (VC: 2220208 )


integrity constraint violation

  • 23000 integrity constraint violation
  • 23001 integrity constraint violation: restrict violation


invalid cursor state

  • 24000 invalid cursor state


invalid transaction state

  • 25000 invalid transaction state
  • 25001 invalid transaction state: active SQL-transaction
  • 25002 invalid transaction state: branch transaction already active
  • 25003 invalid transaction state: inappropriate access mode for branch transaction
  • 25004 invalid transaction state: inappropriate isolation level for branch transaction
  • 25005 invalid transaction state: no active SQL-transaction for branch transaction
  • 25006 invalid transaction state: read-only SQL-transaction
  • 25007 invalid transaction state: schema and data statement mixing not supported
  • 25008 invalid transaction state: held cursor requires same isolation level


invalid SQL statement name

  • 26000 invalid SQL statement name


triggered data change violation

  • 27000 triggered data change violation


invalid authorization specification

  • 28000 invalid authorization specification


dependent privilege descriptors still exist:

  • 2B000 dependent privilege descriptors still exist: (VC: 1202000 )


invalid character set name

  • 2C000 invalid character set name (VC: 1203000 )


invalid transaction termination

  • 2D000 invalid transaction termination (VC: 1204000 )


invalid connection name

  • 2E000 invalid connection name (VC: 1205000 )


SQL routine exception

  • 2F000 SQL routine exception (VC: 1206000 )
  • 2F002 SQL routine exception: modifying SQL-data not permitted (VC: 1206002 )
  • 2F003 SQL routine exception: prohibited SQL-statement attempted (VC: 1206003 )
  • 2F004 SQL routine exception: reading SQL-data not permitted (VC: 1206004 )
  • 2F005 SQL routine exception: function executed no return statement (VC: 1206005 )


invalid collation name

  • 2H000 invalid collation name (VC: 1208000 )


invalid SQL statement identifier

  • 30000 invalid SQL statement identifier


invalid SQL descriptor name

  • 33000 invalid SQL descriptor name


invalid cursor name

  • 34000 invalid cursor name


invalid condition number

  • 35000 invalid condition number


cursor sensitivity exception

  • 36000 cursor sensitivity exception
  • 36001 cursor sensitivity exception: request rejected
  • 36002 cursor sensitivity exception: request failed


external routine exception

  • 38000 external routine exception
  • 38001 external routine exception: containing SQL not permitted
  • 38002 external routine exception: modifying SQL-data not permitted
  • 38003 external routine exception: prohibited SQL-statement attempted
  • 38004 external routine exception: reading SQL-data not permitted
  • 39000 external routine invocation exception:
  • 39004 external routine invocation exception: null value not allowed


savepoint exception

  • 3B000 savepoint exception (VC: 1302000 )
  • 3B001 savepoint exception: invalid specification (VC: 1302001 )
  • 3B002 savepoint exception: too many (VC: 162002 )


ambiguous cursor name

  • 3C000 ambiguous cursor name (VC: 1303000 )


invalid catalog name

  • 3D000 invalid catalog name (VC: 1304000 )


invalid schema name

  • 3F000 invalid schema name (VC: 1305000 )


transaction rollback

  • 40000 transaction rollback
  • 40001 transaction rollback: serialization failure
  • 40002 transaction rollback: integrity constraint violation
  • 40003 transaction rollback: statement completion unknown
  • 40004 transaction rollback: triggered action exception


syntax error or access rule violation

  • 42000 syntax error or access rule violation


with check option violation

  • 44000 with check option violation


Unknown Error: Catch-All

  • 99000 Unknown Error: Catch-All
  • 99099 Unknown Error: Error converting vendor code to SQL state code


Remote Database Access

  • HZ000 Remote Database Access (VC: 499000 )



Axion - Open Source Java Database Engine