HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

Other Versions:

Class 25 - Class 40

SQLSTATE Value Description
Class 25 - Invalid transaction state
25000 Invalid transaction state (INVALID_TRANSACTION_STATE)
25001 Active SQL transaction (ACTIVE_SQL_TRANSACTION)
25002 Branch transaction already activated (BRANCH_TRANSACTION_ALREADY_ACTIVE)
25008 Held cursor requires the same isolation level (HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL)
25003 Inappropriate access mode for branch transaction (INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION)
25004 Inappropriate isolation level for branch transaction (INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION)
25005 No active SQL transaction for branch transaction (NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION)
25006 Read-only SQL transaction (READ_ONLY_SQL_TRANSACTION)
25007 Schema and data statement mixing not supported (SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED)
25009 Transaction cannot be started during recovery (RUN_TRANSACTION_DURING_RECOVERY)
25010 Transaction ID does not exist (GXID_DOES_NOT_EXIST)
25P01 No active SQL transaction (NO_ACTIVE_SQL_TRANSACTION)
25P02 In failed SQL transaction (IN_FAILED_SQL_TRANSACTION)
Class 26 - Invalid SQL statement name
26000 Invalid SQL statement name (INVALID_SQL_STATEMENT_NAME)
Class 27 - Triggered data change violation
27000 Triggered data change violation (TRIGGERED_DATA_CHANGE_VIOLATION)
27001 Invalid triggered tuple (TRIGGERED_INVALID_TUPLE)
Class 28 - Invalid authorization specification
28000 Invalid authorization specification (INVALID_AUTHORIZATION_SPECIFICATION)
28P01 Invalid password (INVALID_PASSWORD)
28P02 Initial password not changed (INITIAL_PASSWORD_NOT_MODIFIED)
Class 29 - Invalid or unexpected state
29P06 Invalid cache plan (INVALID_CACHE_PLAN)
Class 34 - Invalid cursor name
34000 Invalid cursor name (INVALID_CURSOR_NAME)
Class 38 - External process exception
38000 External process exception (EXTERNAL_ROUTINE_EXCEPTION)
38001 Containing SQL not permitted (CONTAINING_SQL_NOT_PERMITTED)
38002 Modifying SQL data not permitted (MODIFYING_SQL_DATA_NOT_PERMITTED)
38003 Prohibited SQL statement attempted (PROHIBITED_SQL_STATEMENT_ATTEMPTED)
38004 SQL data read not permitted (READING_SQL_DATA_NOT_PERMITTED)
Class 39 - External process invocation exception
39000 External process invocation exception (EXTERNAL_ROUTINE_INVOCATION_EXCEPTION)
39001 Invalid SQLSTATE value returned (INVALID_SQLSTATE_RETURNED)
39004 Null value not allowed (NULL_VALUE_NOT_ALLOWED)
39P01 Trigger protocol violated (TRIGGER_PROTOCOL_VIOLATED)
39P02 SRF protocol violated (SRF_PROTOCOL_VIOLATED)
Class 40 - Transaction rollback
40000 Transaction rollback (TRANSACTION_ROLLBACK)
40002 Transaction integrity constraint violation (TRANSACTION_INTEGRITY_CONSTRAINT_VIOLATION)
40001 Serialization failure (SERIALIZATION_FAILURE)
40003 Statement completion unknown (STATEMENT_COMPLETION_UNKNOWN)
40P01 Deadlock detected (DEADLOCK_DETECTED)
Copyright © 2011-2024 www.enmotech.com All rights reserved.