io.picodata.jdbc

Enum PicodataSQLState

java.lang.Object

java.lang.Enum<PicodataSQLState>

io.picodata.jdbc.PicodataSQLState

All Implemented Interfaces:

Serializable, Comparable<PicodataSQLState>

public enum PicodataSQLState
extends Enum<PicodataSQLState>

This class is used for holding SQLState codes. See the SQLSTATE section in the most recent SQL standard you can find (e.g. ISO/IEC 9075-1:2023)

Enum Constant Summary

Enum Constants

Enum Constant and Description
CANNOT_COERCE Type conversions did not work, perhaps there is no suitable mapping
CONNECTION_DOES_NOT_EXIST Connection has failed or was closed before this operation
DATA_ERROR The data format is not valid
DATA_TYPE_MISMATCH Actual data type did not match expected
INVALID_CURSOR_STATE Cursor is closed or at a wrong position in the result set
INVALID_PARAMETER_TYPE Actual parameter type does not match expected
INVALID_PARAMETER_VALUE Parameter value did not pass validation
NO_DATA The server did not return any data although they should be present
NOT_IMPLEMENTED This operation is not supported yet
NUMERIC_VALUE_OUT_OF_RANGE Numeric value had wrong format or did not match the target bounds.
OBJECT_NOT_IN_STATE Generic error that this operation is not allowed on some internal object now
PROTOCOL_VIOLATION The server sent us a response the driver was not prepared for and is either bizarre datastream corruption, a driver bug, or a protocol violation on the server's part.
TOO_MANY_RESULTS Most likely one or zero rows were expected but many were returned from the server
UNDEFINED_COLUMN THere was an attempt to access a column that was not returned in a result set
UNEXPECTED_ERROR Something is broken in the system or JVM or a process was interrupted, that puts the driver into an incosistent state

Method Summary

Modifier and Type	Method and Description
String	getState() Get ISO spec state code
String	toString()
static PicodataSQLState	valueOf(String name) Returns the enum constant of this type with the specified name.
static PicodataSQLState[]	values() Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

CANNOT_COERCE

public static final PicodataSQLState CANNOT_COERCE

Type conversions did not work, perhaps there is no suitable mapping

CONNECTION_DOES_NOT_EXIST

public static final PicodataSQLState CONNECTION_DOES_NOT_EXIST

Connection has failed or was closed before this operation

DATA_ERROR

public static final PicodataSQLState DATA_ERROR

The data format is not valid

DATA_TYPE_MISMATCH

public static final PicodataSQLState DATA_TYPE_MISMATCH

Actual data type did not match expected

INVALID_CURSOR_STATE

public static final PicodataSQLState INVALID_CURSOR_STATE

Cursor is closed or at a wrong position in the result set

INVALID_PARAMETER_TYPE

public static final PicodataSQLState INVALID_PARAMETER_TYPE

Actual parameter type does not match expected

INVALID_PARAMETER_VALUE

public static final PicodataSQLState INVALID_PARAMETER_VALUE

Parameter value did not pass validation

NO_DATA

public static final PicodataSQLState NO_DATA

The server did not return any data although they should be present

NOT_IMPLEMENTED

public static final PicodataSQLState NOT_IMPLEMENTED

This operation is not supported yet

NUMERIC_VALUE_OUT_OF_RANGE

public static final PicodataSQLState NUMERIC_VALUE_OUT_OF_RANGE

Numeric value had wrong format or did not match the target bounds. Possible type mismatch

OBJECT_NOT_IN_STATE

public static final PicodataSQLState OBJECT_NOT_IN_STATE

Generic error that this operation is not allowed on some internal object now

PROTOCOL_VIOLATION

public static final PicodataSQLState PROTOCOL_VIOLATION

The server sent us a response the driver was not prepared for and is either bizarre datastream corruption, a driver bug, or a protocol violation on the server's part.

TOO_MANY_RESULTS

public static final PicodataSQLState TOO_MANY_RESULTS

Most likely one or zero rows were expected but many were returned from the server

UNDEFINED_COLUMN

public static final PicodataSQLState UNDEFINED_COLUMN

THere was an attempt to access a column that was not returned in a result set

UNEXPECTED_ERROR

public static final PicodataSQLState UNEXPECTED_ERROR

Something is broken in the system or JVM or a process was interrupted, that puts the driver into an incosistent state

Method Detail

values

public static PicodataSQLState[] 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 (PicodataSQLState c : PicodataSQLState.values())
    System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static PicodataSQLState 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

getState

public String getState()

Get ISO spec state code

Returns:

code

toString

public String toString()

Overrides:

toString in class Enum<PicodataSQLState>