Package com.nuodb.jdbc

Enum SQLState

  • All Implemented Interfaces:
    Serializable, Comparable<SQLState>
    public enum SQLState
extends Enum<SQLState>
    Maps NuoDB vendor error codes to default SQLState values. These should be consistent with SQLException.h

    SQLState is XOPEN state, which is indicated by com.nuodb.jdbc.RemDatabaseMetaData.getSQLStateType(). According to XOPEN SQL state is a five-character, standardised diagnostic code, see page 86 of Values of SQLSTATE are shown in this manual in the format ’CCSSS’, where CC is the class code and SSS is the subclass. The format, values, and usage are the same as in the X/Open SQL specification, except that additional, CLI-specific codes are defined as class ’HY’. (See Appendix A for a list of CLI SQLSTATE values with cross-references.) We are following MSSQL and IBM DB2:

    • MSSQL defines it for when "Login timeout expired, A network-related or instance-specific error"
    • IBM DB2 raises SQLTimeoutException when "Query timeout period expired before the data source returned the result set. The timeout period is set through SQLSetStmtAttr() with an Attribute argument of SQL_ATTR_QUERY_TIMEOUT."

    • Enum Constant Detail

      • NUMERIC_VALUE_OUT_OF_RANGE

        public static final SQLState NUMERIC_VALUE_OUT_OF_RANGE

      • COMMUNICATION_LINK_ERROR

        public static final SQLState COMMUNICATION_LINK_ERROR

      • INVALID_PARAMETER_VALUE

        public static final SQLState INVALID_PARAMETER_VALUE

      • SYNTAX_ERROR

        public static final SQLState SYNTAX_ERROR

      • FEATURE_NOT_YET_IMPLEMENTED

        public static final SQLState FEATURE_NOT_YET_IMPLEMENTED

      • BUG_CHECK

        public static final SQLState BUG_CHECK

      • COMPILE_ERROR

        public static final SQLState COMPILE_ERROR

      • RUNTIME_ERROR

        public static final SQLState RUNTIME_ERROR

      • IO_ERROR

        public static final SQLState IO_ERROR

      • NETWORK_ERROR

        public static final SQLState NETWORK_ERROR

      • CONVERSION_ERROR

        public static final SQLState CONVERSION_ERROR

      • TRUNCATION_ERROR

        public static final SQLState TRUNCATION_ERROR

      • CONNECTION_ERROR

        public static final SQLState CONNECTION_ERROR

      • DDL_ERROR

        public static final SQLState DDL_ERROR

      • APPLICATION_ERROR

        public static final SQLState APPLICATION_ERROR

      • SECURITY_ERROR

        public static final SQLState SECURITY_ERROR

      • DATABASE_CORRUPTION

        public static final SQLState DATABASE_CORRUPTION

      • VERSION_ERROR

        public static final SQLState VERSION_ERROR

      • LICENSE_ERROR

        public static final SQLState LICENSE_ERROR

      • INTERNAL_ERROR

        public static final SQLState INTERNAL_ERROR

      • DEBUG_ERROR

        public static final SQLState DEBUG_ERROR

      • LOST_BLOB

        public static final SQLState LOST_BLOB

      • INCONSISTENT_BLOB

        public static final SQLState INCONSISTENT_BLOB

      • DELETED_BLOB

        public static final SQLState DELETED_BLOB

      • LOG_ERROR

        public static final SQLState LOG_ERROR

      • DATABASE_DAMAGED

        public static final SQLState DATABASE_DAMAGED

      • UPDATE_CONFLICT

        public static final SQLState UPDATE_CONFLICT

      • NO_SUCH_TABLE

        public static final SQLState NO_SUCH_TABLE

      • INDEX_OVERFLOW

        public static final SQLState INDEX_OVERFLOW

      • UNIQUE_DUPLICATE

        public static final SQLState UNIQUE_DUPLICATE

      • UNCOMMITTED_UPDATES

        public static final SQLState UNCOMMITTED_UPDATES

      • DEADLOCK

        public static final SQLState DEADLOCK

      • OUT_OF_MEMORY_ERROR

        public static final SQLState OUT_OF_MEMORY_ERROR

      • OUT_OF_RECORD_MEMORY_ERROR

        public static final SQLState OUT_OF_RECORD_MEMORY_ERROR

      • LOCK_TIMEOUT

        public static final SQLState LOCK_TIMEOUT

      • PLATFORM_ERROR

        public static final SQLState PLATFORM_ERROR

      • NO_SCHEMA

        public static final SQLState NO_SCHEMA

      • CONFIGURATION_ERROR

        public static final SQLState CONFIGURATION_ERROR

      • READ_ONLY_ERROR

        public static final SQLState READ_ONLY_ERROR

      • NO_GENERATED_KEYS

        public static final SQLState NO_GENERATED_KEYS

      • THROWN_EXCEPTION

        public static final SQLState THROWN_EXCEPTION

      • INVALID_TRANSACTION_ISOLATION

        public static final SQLState INVALID_TRANSACTION_ISOLATION

      • UNSUPPORTED_TRANSACTION_ISOLATION

        public static final SQLState UNSUPPORTED_TRANSACTION_ISOLATION

      • INVALID_UTF8

        public static final SQLState INVALID_UTF8

      • CONSTRAINT_ERROR

        public static final SQLState CONSTRAINT_ERROR

      • UPDATE_ERROR

        public static final SQLState UPDATE_ERROR

      • I18N_ERROR

        public static final SQLState I18N_ERROR

      • OPERATION_KILLED

        public static final SQLState OPERATION_KILLED

      • INVALID_STATEMENT

        public static final SQLState INVALID_STATEMENT

      • IS_SHUTDOWN

        public static final SQLState IS_SHUTDOWN

      • IN_QUOTED_STRING

        public static final SQLState IN_QUOTED_STRING

      • BATCH_UPDATE_ERROR

        public static final SQLState BATCH_UPDATE_ERROR

      • JAVA_ERROR

        public static final SQLState JAVA_ERROR

      • INVALID_FIELD

        public static final SQLState INVALID_FIELD

      • INVALID_INDEX_NULL

        public static final SQLState INVALID_INDEX_NULL

      • INVALID_OPERATION

        public static final SQLState INVALID_OPERATION

      • INVALID_STATISTICS

        public static final SQLState INVALID_STATISTICS

      • INVALID_GENERATOR

        public static final SQLState INVALID_GENERATOR

      • OPERATION_TIMEOUT

        public static final SQLState OPERATION_TIMEOUT

      • NO_SUCH_INDEX

        public static final SQLState NO_SUCH_INDEX

      • NO_SUCH_SEQUENCE

        public static final SQLState NO_SUCH_SEQUENCE

      • XAER_PROTO

        public static final SQLState XAER_PROTO

      • UNKNOWN_ERROR

        public static final SQLState UNKNOWN_ERROR

      • TRANSACTIONAL_LOCK_ERROR

        public static final SQLState TRANSACTIONAL_LOCK_ERROR

      • TRANSACTION_STATE_UNKNOWN

        public static final SQLState TRANSACTION_STATE_UNKNOWN

      • INVALID_TIMEZONE_DISPLACEMENT_VALUE

        public static final SQLState INVALID_TIMEZONE_DISPLACEMENT_VALUE

    • Method Detail

      • values

        public static SQLState[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows: 
        for (SQLState c : SQLState.values())
    System.out.println(c);
        Returns:
        an array containing the constants of this enum type, in the order they are declared

      • valueOf

        public static SQLState valueOf​(String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        IllegalArgumentException - if this enum type has no constant with the specified name
        NullPointerException - if the argument is null

      • getCode

        public int getCode()

      • getState

        public String getState()

      • getStateClass

        public String getStateClass()

      • getCode

        public static int getCode​(SQLState sqlState)

      • getState

        public static String getState​(int code)

      • getSQLState

        public static SQLState getSQLState​(int code)