Top Description Fields
org.hsqldb.result

public Interface ResultConstants

Imports
org.hsqldb.StatementTypes

An enumeration of the request and response mode values used to communicate between the client and the engine when sending Result objects back and forth.
Authors
Campbell Burnet (campbell-burnet@users dot sourceforge.net), Fred Toussi (fredt@users dot sourceforge.net)
Since
2.6.0
Version
1.7.2

Field Summary

Modifier and TypeField and Description
public static final int
BATCHEXECDIRECT

Indicates that the Result object encapsulates a batch of statements

public static final int
BATCHEXECRESPONSE

Indicates that the Result object encapsulates a set of update counts for a batch execution

public static final int
BATCHEXECUTE

Indicates that the Result object encapsulates a batch of prepared statement parameter values

public static final int
CALL_RESPONSE

Indicates that the Result encapsulates a response to a procedure call via CallableStatement

public static final int
CHANGE_SET

Indicates that the Result encapsulates a data change set

public static final int
public static final int
CLOSE_RESULT

Indicates that the Result encapsulates a request to close a result set

public static final int
public static final int
public static final int
CONNECT

Indicates that Result encapsulates a request to establish a connection.

public static final int
CONNECTACKNOWLEDGE

Indicates that the Result object encapsulates a response to a connection attempt that was successful

public static final int
DATA

Indicates that the Result object encapsulates a result set response containing data.

public static final int
DATAHEAD

Indicates that the Result object encapsulates a set of data rows with metadata

public static final int
DATAROWS

Indicates that the Result object encapsulates a set of data rows without metadata

public static final int
public static final int
DISCONNECT

Indicates that Result encapsulates a request to terminate an established connection.

public static final int
ENDTRAN

Indicates that Result encapsulates a request to terminate an SQL-transaction.

public static final int
ERROR

Indicates that the Result object encapsulates an error response.

public static final int
EXECDIRECT

Indicates that Result encapsulates a request to execute a statement directly.

public static final int
EXECUTE

Indicates that Result encapsulates a request to execute a prepared statement.

public static final int
EXECUTE_FAILED

batch item failed

public static final int
EXECUTE_INVALID

attempt to execute invalid statement

public static final int
FREESTMT

Indicates that Result encapsulates a request to deallocate an SQL-statement.

public static final int
GENERATED

generated data

public static final int
GETSESSIONATTR

Indicates that the Result object encapsulates a request to get session attributes.

public static final int
public static final int
HSQL_API_BASE

The offset at which HSQLDB API Result mode values start.

public static final int
public static final int
LARGE_OBJECT_OP

Common result type for all large object operations

public static final int
MODE_UPPER_LIMIT

Constants above this limit are handled as non-HSQLDB results

public static final int
NONE

Not a result

public static final int
PARAM_METADATA

Only for metadata, indicates that the metadata is for the parameters.

public static final int
PREPARE

Indicates that Result encapsulates a request to prepare a statement.

public static final int
PREPARE_ACK

Indicates that the Result object encapsulates a response that communicates the acknowledgement of newly allocated Statement object in the form of its statementID and metadata

public static final int
PREPARECOMMIT

Indicates that the Result object encapsulates a request to prepare to commit as the first phase of a two-phase commit

public static final int
REQUESTDATA

Indicates that the Result object encapsulates a request to return some rows of data

public static final int
RESETSESSION

Indicates that the Result object encapsulates a request to start a new internal session for the connection

public static final int
RETURN_GENERATED_KEYS

Constants indicating generated key return behaviour

public static final int
public static final int
public static final int
public static final int
public static final int
SETCONNECTATTR

Indicates that Result encapsulates a request to set the value of an SQL-connection attribute.

public static final int
SETSESSIONATTR

Indicates that the Result object encapsulates a result set for setting session attributes.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
SQLCANCEL

Indicates that Result encapsulates a request to cancel execution of a CLI routine.

public static final int
STARTTRAN

Indicates that Result encapsulates a request to explicitly start an SQL-transaction and set its characteristics.

public static final int
SUCCESS_NO_INFO

Batch item succeeded but does not generate an update count, for example a call having no return value

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
UPDATE_RESULT

Indicates that the Result encapsulates a request to update or insert into a result set

public static final int
UPDATECOUNT

Indicates that the Result object encapsulates an update count response.

public static final int
VALUE

Indicates that the Result encapsulates a simple value for internal use

public static final int
WARNING

Warning

Field Detail

BATCHEXECDIRECTback to summary
public static final int BATCHEXECDIRECT

Indicates that the Result object encapsulates a batch of statements

BATCHEXECRESPONSEback to summary
public static final int BATCHEXECRESPONSE

Indicates that the Result object encapsulates a set of update counts for a batch execution

BATCHEXECUTEback to summary
public static final int BATCHEXECUTE

Indicates that the Result object encapsulates a batch of prepared statement parameter values

CALL_RESPONSEback to summary
public static final int CALL_RESPONSE

Indicates that the Result encapsulates a response to a procedure call via CallableStatement

CHANGE_SETback to summary
public static final int CHANGE_SET

Indicates that the Result encapsulates a data change set

CLOSE_CURSORS_AT_COMMITback to summary
public static final int CLOSE_CURSORS_AT_COMMIT
CLOSE_RESULTback to summary
public static final int CLOSE_RESULT

Indicates that the Result encapsulates a request to close a result set

CONCUR_READ_ONLYback to summary
public static final int CONCUR_READ_ONLY
CONCUR_UPDATABLEback to summary
public static final int CONCUR_UPDATABLE
CONNECTback to summary
public static final int CONNECT

Indicates that Result encapsulates a request to establish a connection.

CONNECTACKNOWLEDGEback to summary
public static final int CONNECTACKNOWLEDGE

Indicates that the Result object encapsulates a response to a connection attempt that was successful

DATAback to summary
public static final int DATA

Indicates that the Result object encapsulates a result set response containing data.

DATAHEADback to summary
public static final int DATAHEAD

Indicates that the Result object encapsulates a set of data rows with metadata

DATAROWSback to summary
public static final int DATAROWS

Indicates that the Result object encapsulates a set of data rows without metadata

DELETE_CURSORback to summary
public static final int DELETE_CURSOR
DISCONNECTback to summary
public static final int DISCONNECT

Indicates that Result encapsulates a request to terminate an established connection.

ENDTRANback to summary
public static final int ENDTRAN

Indicates that Result encapsulates a request to terminate an SQL-transaction.

ERRORback to summary
public static final int ERROR

Indicates that the Result object encapsulates an error response.

EXECDIRECTback to summary
public static final int EXECDIRECT

Indicates that Result encapsulates a request to execute a statement directly.

EXECUTEback to summary
public static final int EXECUTE

Indicates that Result encapsulates a request to execute a prepared statement.

EXECUTE_FAILEDback to summary
public static final int EXECUTE_FAILED

batch item failed

EXECUTE_INVALIDback to summary
public static final int EXECUTE_INVALID

attempt to execute invalid statement

FREESTMTback to summary
public static final int FREESTMT

Indicates that Result encapsulates a request to deallocate an SQL-statement.

GENERATEDback to summary
public static final int GENERATED

generated data

GETSESSIONATTRback to summary
public static final int GETSESSIONATTR

Indicates that the Result object encapsulates a request to get session attributes.

HOLD_CURSORS_OVER_COMMITback to summary
public static final int HOLD_CURSORS_OVER_COMMIT
HSQL_API_BASEback to summary
public static final int HSQL_API_BASE

The offset at which HSQLDB API Result mode values start.

INSERT_CURSORback to summary
public static final int INSERT_CURSOR
LARGE_OBJECT_OPback to summary
public static final int LARGE_OBJECT_OP

Common result type for all large object operations

MODE_UPPER_LIMITback to summary
public static final int MODE_UPPER_LIMIT

Constants above this limit are handled as non-HSQLDB results

NONEback to summary
public static final int NONE

Not a result

PARAM_METADATAback to summary
public static final int PARAM_METADATA

Only for metadata, indicates that the metadata is for the parameters.

PREPAREback to summary
public static final int PREPARE

Indicates that Result encapsulates a request to prepare a statement.

PREPARE_ACKback to summary
public static final int PREPARE_ACK

Indicates that the Result object encapsulates a response that communicates the acknowledgement of newly allocated Statement object in the form of its statementID and metadata

PREPARECOMMITback to summary
public static final int PREPARECOMMIT

Indicates that the Result object encapsulates a request to prepare to commit as the first phase of a two-phase commit

REQUESTDATAback to summary
public static final int REQUESTDATA

Indicates that the Result object encapsulates a request to return some rows of data

RESETSESSIONback to summary
public static final int RESETSESSION

Indicates that the Result object encapsulates a request to start a new internal session for the connection

RETURN_GENERATED_KEYSback to summary
public static final int RETURN_GENERATED_KEYS

Constants indicating generated key return behaviour

RETURN_GENERATED_KEYS_COL_INDEXESback to summary
public static final int RETURN_GENERATED_KEYS_COL_INDEXES
RETURN_GENERATED_KEYS_COL_NAMESback to summary
public static final int RETURN_GENERATED_KEYS_COL_NAMES
RETURN_NO_GENERATED_KEYSback to summary
public static final int RETURN_NO_GENERATED_KEYS
RETURN_PRIMARY_KEYSback to summary
public static final int RETURN_PRIMARY_KEYS
SETCONNECTATTRback to summary
public static final int SETCONNECTATTR

Indicates that Result encapsulates a request to set the value of an SQL-connection attribute.

SETSESSIONATTRback to summary
public static final int SETSESSIONATTR

Indicates that the Result object encapsulates a result set for setting session attributes.

SQL_ASENSITIVEback to summary
public static final int SQL_ASENSITIVE
SQL_ATTR_SAVEPOINT_NAMEback to summary
public static final int SQL_ATTR_SAVEPOINT_NAME
SQL_HOLDABLEback to summary
public static final int SQL_HOLDABLE
SQL_INSENSITIVEback to summary
public static final int SQL_INSENSITIVE
SQL_NONHOLDABLEback to summary
public static final int SQL_NONHOLDABLE
SQL_NONSCROLLABLEback to summary
public static final int SQL_NONSCROLLABLE
SQL_NOT_UPDATABLEback to summary
public static final int SQL_NOT_UPDATABLE
SQL_SCROLLABLEback to summary
public static final int SQL_SCROLLABLE
SQL_SENSITIVEback to summary
public static final int SQL_SENSITIVE
SQL_UPDATABLEback to summary
public static final int SQL_UPDATABLE
SQL_WITH_RETURNback to summary
public static final int SQL_WITH_RETURN
SQL_WITHOUT_RETURNback to summary
public static final int SQL_WITHOUT_RETURN
SQLCANCELback to summary
public static final int SQLCANCEL

Indicates that Result encapsulates a request to cancel execution of a CLI routine.

STARTTRANback to summary
public static final int STARTTRAN

Indicates that Result encapsulates a request to explicitly start an SQL-transaction and set its characteristics.

SUCCESS_NO_INFOback to summary
public static final int SUCCESS_NO_INFO

Batch item succeeded but does not generate an update count, for example a call having no return value

TX_COMMITback to summary
public static final int TX_COMMIT
TX_COMMIT_AND_CHAINback to summary
public static final int TX_COMMIT_AND_CHAIN
TX_ROLLBACKback to summary
public static final int TX_ROLLBACK
TX_ROLLBACK_AND_CHAINback to summary
public static final int TX_ROLLBACK_AND_CHAIN
TX_SAVEPOINT_NAME_RELEASEback to summary
public static final int TX_SAVEPOINT_NAME_RELEASE
TX_SAVEPOINT_NAME_ROLLBACKback to summary
public static final int TX_SAVEPOINT_NAME_ROLLBACK
TYPE_FORWARD_ONLYback to summary
public static final int TYPE_FORWARD_ONLY
TYPE_SCROLL_INSENSITIVEback to summary
public static final int TYPE_SCROLL_INSENSITIVE
TYPE_SCROLL_SENSITIVEback to summary
public static final int TYPE_SCROLL_SENSITIVE
UPDATE_CURSORback to summary
public static final int UPDATE_CURSOR
UPDATE_RESULTback to summary
public static final int UPDATE_RESULT

Indicates that the Result encapsulates a request to update or insert into a result set

UPDATECOUNTback to summary
public static final int UPDATECOUNT

Indicates that the Result object encapsulates an update count response.

VALUEback to summary
public static final int VALUE

Indicates that the Result encapsulates a simple value for internal use

WARNINGback to summary
public static final int WARNING

Warning