ResultConstants

Documentation of 'org.hsqldb.result.ResultConstants' Java class ResultConstants

All Classes

Summary:
Nested |
Field |
Constr |
Method

Detail:
Field |
Constr |
Method

```
public interface ResultConstants
```
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.

Since:

2.1.1

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`BATCHEXECDIRECT` Indicates that the Result object encapsulates a batch of statements
`static int`	`BATCHEXECRESPONSE` Indicates that the Result object encapsulates a set of update counts for a batch execution
`static int`	`BATCHEXECUTE` Indicates that the Result object encapsulates a batch of prepared statement parameter values
`static int`	`CALL_RESPONSE` Indicates that the Result encapsulates a response to a procedure call via CallableStatement
`static int`	`CHANGE_SET` Indicates that the Result encapsulates a data change set
`static int`	`CLOSE_CURSORS_AT_COMMIT`
`static int`	`CLOSE_RESULT` Indicates that the Result encapsulates a request to close a result set
`static int`	`CONCUR_READ_ONLY`
`static int`	`CONCUR_UPDATABLE`
`static int`	`CONNECT` Indicates that Result encapsulates a request to establish a connection.
`static int`	`CONNECTACKNOWLEDGE` Indicates that the Result object encapsulates a response to a connection attempt that was successful
`static int`	`DATA` Indicates that the Result object encapsulates a result set response containing data.
`static int`	`DATAHEAD` Indicates that the Result object encapsulates a set of data rows with metadata
`static int`	`DATAROWS` Indicates that the Result object encapsulates a set of data rows without metadata
`static int`	`DELETE_CURSOR`
`static int`	`DISCONNECT` Indicates that Result encapsulates a request to terminate an established connection.
`static int`	`ENDTRAN` Indicates that Result encapsulates a request to terminate an SQL-transaction.
`static int`	`ERROR` Indicates that the Result object encapsualtes an error response.
`static int`	`EXECDIRECT` Indicates that Result encapsulates a request to execute a statement directly.
`static int`	`EXECUTE` Indicates that Result encapsulates a request to execute a prepared statement.
`static int`	`EXECUTE_FAILED` batch item failed
`static int`	`EXECUTE_INVALID` attempt to execute invalid statement
`static int`	`FREESTMT` Indicates that Result encapsulates a request to deallocate an SQL-statement.
`static int`	`GENERATED` generated data
`static int`	`GETSESSIONATTR` Indicates that the Result object encapsulates a request to get session attributes.
`static int`	`HOLD_CURSORS_OVER_COMMIT`
`static int`	`HSQL_API_BASE` The offset at which HSQLDB API Result mode values start.
`static int`	`INSERT_CURSOR`
`static int`	`LARGE_OBJECT_OP` Common result type for all large object operations
`static int`	`MODE_UPPER_LIMIT` Constants above this limit are handled as non-HSQLDB results
`static int`	`NONE` Not a result
`static int`	`PARAM_METADATA` Only for metadata, indicates that the metadata is for the parameters.
`static int`	`PREPARE` Indicates that Result encapsulates a request to prepare a statement.
`static int`	`PREPARE_ACK` Indicates that the Result object encapsulates a response that communicates the acknowlegement of newly allocated Statement object in the form of its statementID and metadata
`static int`	`PREPARECOMMIT` Indicates that the Result object encapsulates a request to prepare to commit as the first phase of a two-phase commit
`static int`	`REQUESTDATA` Indicates that the Result object encapsulates a request to return some rows of data
`static int`	`RESETSESSION` Indicates that the Result object encapsulates a request to start a new internal session for the connection
`static int`	`RETURN_GENERATED_KEYS` Constants indicating generated key return behaviour
`static int`	`RETURN_GENERATED_KEYS_COL_INDEXES`
`static int`	`RETURN_GENERATED_KEYS_COL_NAMES`
`static int`	`RETURN_NO_GENERATED_KEYS`
`static int`	`SETCONNECTATTR` Indicates that Result encapsulates a request to set the value of an SQL-connection attribute.
`static int`	`SETSESSIONATTR` Indicates that the Result object encapsulates a result set for setting session attributes.
`static int`	`SQL_ASENSITIVE`
`static int`	`SQL_ATTR_SAVEPOINT_NAME`
`static int`	`SQL_HOLDABLE`
`static int`	`SQL_INSENSITIVE`
`static int`	`SQL_NONHOLDABLE`
`static int`	`SQL_NONSCROLLABLE`
`static int`	`SQL_NOT_UPDATABLE`
`static int`	`SQL_SCROLLABLE`
`static int`	`SQL_SENSITIVE`
`static int`	`SQL_UPDATABLE`
`static int`	`SQL_WITH_RETURN`
`static int`	`SQL_WITHOUT_RETURN`
`static int`	`STARTTRAN` Indicates that Result encapsulates a request to explicitly start an SQL-transaction and set its characteristics.
`static int`	`SUCCESS_NO_INFO` Batch item succeeded but does not generate an update count, for example a call having no return value
`static int`	`TX_COMMIT`
`static int`	`TX_COMMIT_AND_CHAIN`
`static int`	`TX_ROLLBACK`
`static int`	`TX_ROLLBACK_AND_CHAIN`
`static int`	`TX_SAVEPOINT_NAME_RELEASE`
`static int`	`TX_SAVEPOINT_NAME_ROLLBACK`
`static int`	`TYPE_FORWARD_ONLY`
`static int`	`TYPE_SCROLL_INSENSITIVE`
`static int`	`TYPE_SCROLL_SENSITIVE`
`static int`	`UPDATE_CURSOR`
`static int`	`UPDATE_RESULT` Indicates that the Result encapsulates a request to update or insert into a result set
`static int`	`UPDATECOUNT` Indicates that the Result object encapsulates an update count response.
`static int`	`VALUE` Indicates that the Result encapsulates a simple value for internal use
`static int`	`WARNING` Warning

- Field Detail
  - HSQL_API_BASE
```
static final int HSQL_API_BASE
```
    The offset at which HSQLDB API Result mode values start.
    
    See Also:
    
    Constant Field Values
  - NONE
```
static final int NONE
```
    Not a result
    
    See Also:
    
    Constant Field Values
  - UPDATECOUNT
```
static final int UPDATECOUNT
```
    Indicates that the Result object encapsulates an update count response.
    
    See Also:
    
    Constant Field Values
  - ERROR
```
static final int ERROR
```
    Indicates that the Result object encapsualtes an error response.
    
    See Also:
    
    Constant Field Values
  - DATA
```
static final int DATA
```
    Indicates that the Result object encapsulates a result set response containing data.
    
    See Also:
    
    Constant Field Values
  - PREPARE_ACK
```
static final int PREPARE_ACK
```
    Indicates that the Result object encapsulates a response that communicates the acknowlegement of newly allocated Statement object in the form of its statementID and metadata
    
    See Also:
    
    Constant Field Values
  - SETSESSIONATTR
```
static final int SETSESSIONATTR
```
    Indicates that the Result object encapsulates a result set for setting session attributes.
    
    See Also:
    
    Constant Field Values
  - GETSESSIONATTR
```
static final int GETSESSIONATTR
```
    Indicates that the Result object encapsulates a request to get session attributes.
    
    See Also:
    
    Constant Field Values
  - BATCHEXECDIRECT
```
static final int BATCHEXECDIRECT
```
    Indicates that the Result object encapsulates a batch of statements
    
    See Also:
    
    Constant Field Values
  - BATCHEXECUTE
```
static final int BATCHEXECUTE
```
    Indicates that the Result object encapsulates a batch of prepared statement parameter values
    
    See Also:
    
    Constant Field Values
  - RESETSESSION
```
static final int RESETSESSION
```
    Indicates that the Result object encapsulates a request to start a new internal session for the connection
    
    See Also:
    
    Constant Field Values
  - CONNECTACKNOWLEDGE
```
static final int CONNECTACKNOWLEDGE
```
    Indicates that the Result object encapsulates a response to a connection attempt that was successful
    
    See Also:
    
    Constant Field Values
  - PREPARECOMMIT
```
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
    
    See Also:
    
    Constant Field Values
  - REQUESTDATA
```
static final int REQUESTDATA
```
    Indicates that the Result object encapsulates a request to return some rows of data
    
    See Also:
    
    Constant Field Values
  - DATAROWS
```
static final int DATAROWS
```
    Indicates that the Result object encapsulates a set of data rows without metadata
    
    See Also:
    
    Constant Field Values
  - DATAHEAD
```
static final int DATAHEAD
```
    Indicates that the Result object encapsulates a set of data rows with metadata
    
    See Also:
    
    Constant Field Values
  - BATCHEXECRESPONSE
```
static final int BATCHEXECRESPONSE
```
    Indicates that the Result object encapsulates a set of update counts for a batch execution
    
    See Also:
    
    Constant Field Values
  - PARAM_METADATA
```
static final int PARAM_METADATA
```
    Only for metadata, indicates that the metadata is for the parameters.
    
    See Also:
    
    Constant Field Values
  - LARGE_OBJECT_OP
```
static final int LARGE_OBJECT_OP
```
    Common result type for all large object operations
    
    See Also:
    
    Constant Field Values
  - WARNING
```
static final int WARNING
```
    Warning
    
    See Also:
    
    Constant Field Values
  - GENERATED
```
static final int GENERATED
```
    generated data
    
    See Also:
    
    Constant Field Values
  - EXECUTE_INVALID
```
static final int EXECUTE_INVALID
```
    attempt to execute invalid statement
    
    See Also:
    
    Constant Field Values
  - CONNECT
```
static final int CONNECT
```
    Indicates that Result encapsulates a request to establish a connection.
    
    See Also:
    
    Constant Field Values
  - DISCONNECT
```
static final int DISCONNECT
```
    Indicates that Result encapsulates a request to terminate an established connection.
    
    See Also:
    
    Constant Field Values
  - ENDTRAN
```
static final int ENDTRAN
```
    Indicates that Result encapsulates a request to terminate an SQL-transaction.
    
    See Also:
    
    Constant Field Values
  - EXECDIRECT
```
static final int EXECDIRECT
```
    Indicates that Result encapsulates a request to execute a statement directly.
    
    See Also:
    
    Constant Field Values
  - EXECUTE
```
static final int EXECUTE
```
    Indicates that Result encapsulates a request to execute a prepared statement.
    
    See Also:
    
    Constant Field Values
  - FREESTMT
```
static final int FREESTMT
```
    Indicates that Result encapsulates a request to deallocate an SQL-statement.
    
    See Also:
    
    Constant Field Values
  - PREPARE
```
static final int PREPARE
```
    Indicates that Result encapsulates a request to prepare a statement.
    
    See Also:
    
    Constant Field Values
  - SETCONNECTATTR
```
static final int SETCONNECTATTR
```
    Indicates that Result encapsulates a request to set the value of an SQL-connection attribute.
    
    See Also:
    
    Constant Field Values
  - STARTTRAN
```
static final int STARTTRAN
```
    Indicates that Result encapsulates a request to explicitly start an SQL-transaction and set its characteristics.
    
    See Also:
    
    Constant Field Values
  - CLOSE_RESULT
```
static final int CLOSE_RESULT
```
    Indicates that the Result encapsulates a request to close a result set
    
    See Also:
    
    Constant Field Values
  - UPDATE_RESULT
```
static final int UPDATE_RESULT
```
    Indicates that the Result encapsulates a request to update or insert into a result set
    
    See Also:
    
    Constant Field Values
  - VALUE
```
static final int VALUE
```
    Indicates that the Result encapsulates a simple value for internal use
    
    See Also:
    
    Constant Field Values
  - CALL_RESPONSE
```
static final int CALL_RESPONSE
```
    Indicates that the Result encapsulates a response to a procedure call via CallableStatement
    
    See Also:
    
    Constant Field Values
  - CHANGE_SET
```
static final int CHANGE_SET
```
    Indicates that the Result encapsulates a data change set
    
    See Also:
    
    Constant Field Values
  - MODE_UPPER_LIMIT
```
static final int MODE_UPPER_LIMIT
```
    Constants above this limit are handled as non-HSQLDB results
    
    See Also:
    
    Constant Field Values
  - TX_COMMIT
```
static final int TX_COMMIT
```
    See Also:
    
    Constant Field Values
  - TX_ROLLBACK
```
static final int TX_ROLLBACK
```
    See Also:
    
    Constant Field Values
  - TX_SAVEPOINT_NAME_ROLLBACK
```
static final int TX_SAVEPOINT_NAME_ROLLBACK
```
    See Also:
    
    Constant Field Values
  - TX_SAVEPOINT_NAME_RELEASE
```
static final int TX_SAVEPOINT_NAME_RELEASE
```
    See Also:
    
    Constant Field Values
  - TX_COMMIT_AND_CHAIN
```
static final int TX_COMMIT_AND_CHAIN
```
    See Also:
    
    Constant Field Values
  - TX_ROLLBACK_AND_CHAIN
```
static final int TX_ROLLBACK_AND_CHAIN
```
    See Also:
    
    Constant Field Values
  - UPDATE_CURSOR
```
static final int UPDATE_CURSOR
```
    See Also:
    
    Constant Field Values
  - DELETE_CURSOR
```
static final int DELETE_CURSOR
```
    See Also:
    
    Constant Field Values
  - INSERT_CURSOR
```
static final int INSERT_CURSOR
```
    See Also:
    
    Constant Field Values
  - SQL_ATTR_SAVEPOINT_NAME
```
static final int SQL_ATTR_SAVEPOINT_NAME
```
    See Also:
    
    Constant Field Values
  - EXECUTE_FAILED
```
static final int EXECUTE_FAILED
```
    batch item failed
    
    See Also:
    
    Constant Field Values
  - SUCCESS_NO_INFO
```
static final int SUCCESS_NO_INFO
```
    Batch item succeeded but does not generate an update count, for example a call having no return value
    
    See Also:
    
    Constant Field Values
  - SQL_ASENSITIVE
```
static final int SQL_ASENSITIVE
```
    See Also:
    
    Constant Field Values
  - SQL_INSENSITIVE
```
static final int SQL_INSENSITIVE
```
    See Also:
    
    Constant Field Values
  - SQL_SENSITIVE
```
static final int SQL_SENSITIVE
```
    See Also:
    
    Constant Field Values
  - SQL_NONSCROLLABLE
```
static final int SQL_NONSCROLLABLE
```
    See Also:
    
    Constant Field Values
  - SQL_SCROLLABLE
```
static final int SQL_SCROLLABLE
```
    See Also:
    
    Constant Field Values
  - SQL_NONHOLDABLE
```
static final int SQL_NONHOLDABLE
```
    See Also:
    
    Constant Field Values
  - SQL_HOLDABLE
```
static final int SQL_HOLDABLE
```
    See Also:
    
    Constant Field Values
  - SQL_WITHOUT_RETURN
```
static final int SQL_WITHOUT_RETURN
```
    See Also:
    
    Constant Field Values
  - SQL_WITH_RETURN
```
static final int SQL_WITH_RETURN
```
    See Also:
    
    Constant Field Values
  - SQL_NOT_UPDATABLE
```
static final int SQL_NOT_UPDATABLE
```
    See Also:
    
    Constant Field Values
  - SQL_UPDATABLE
```
static final int SQL_UPDATABLE
```
    See Also:
    
    Constant Field Values
  - TYPE_FORWARD_ONLY
```
static final int TYPE_FORWARD_ONLY
```
    See Also:
    
    Constant Field Values
  - TYPE_SCROLL_INSENSITIVE
```
static final int TYPE_SCROLL_INSENSITIVE
```
    See Also:
    
    Constant Field Values
  - TYPE_SCROLL_SENSITIVE
```
static final int TYPE_SCROLL_SENSITIVE
```
    See Also:
    
    Constant Field Values
  - CONCUR_READ_ONLY
```
static final int CONCUR_READ_ONLY
```
    See Also:
    
    Constant Field Values
  - CONCUR_UPDATABLE
```
static final int CONCUR_UPDATABLE
```
    See Also:
    
    Constant Field Values
  - HOLD_CURSORS_OVER_COMMIT
```
static final int HOLD_CURSORS_OVER_COMMIT
```
    See Also:
    
    Constant Field Values
  - CLOSE_CURSORS_AT_COMMIT
```
static final int CLOSE_CURSORS_AT_COMMIT
```
    See Also:
    
    Constant Field Values
  - RETURN_GENERATED_KEYS
```
static final int RETURN_GENERATED_KEYS
```
    Constants indicating generated key return behaviour
    
    See Also:
    
    Constant Field Values
  - RETURN_NO_GENERATED_KEYS
```
static final int RETURN_NO_GENERATED_KEYS
```
    See Also:
    
    Constant Field Values
  - RETURN_GENERATED_KEYS_COL_NAMES
```
static final int RETURN_GENERATED_KEYS_COL_NAMES
```
    See Also:
    
    Constant Field Values
  - RETURN_GENERATED_KEYS_COL_INDEXES
```
static final int RETURN_GENERATED_KEYS_COL_INDEXES
```
    See Also:
    
    Constant Field Values

Skip navigation links

All Classes

Summary:
Nested |
Field |
Constr |
Method

Detail:
Field |
Constr |
Method

Interface ResultConstants

Field Summary

Field Detail

HSQL_API_BASE

NONE

UPDATECOUNT

ERROR

DATA

PREPARE_ACK

SETSESSIONATTR

GETSESSIONATTR

BATCHEXECDIRECT

BATCHEXECUTE

RESETSESSION

CONNECTACKNOWLEDGE

PREPARECOMMIT

REQUESTDATA

DATAROWS

DATAHEAD

BATCHEXECRESPONSE

PARAM_METADATA

LARGE_OBJECT_OP

WARNING

GENERATED

EXECUTE_INVALID

CONNECT

DISCONNECT

ENDTRAN

EXECDIRECT

EXECUTE

FREESTMT

PREPARE

SETCONNECTATTR

STARTTRAN

CLOSE_RESULT

UPDATE_RESULT

VALUE

CALL_RESPONSE

CHANGE_SET

MODE_UPPER_LIMIT

TX_COMMIT

TX_ROLLBACK

TX_SAVEPOINT_NAME_ROLLBACK

TX_SAVEPOINT_NAME_RELEASE

TX_COMMIT_AND_CHAIN

TX_ROLLBACK_AND_CHAIN

UPDATE_CURSOR

DELETE_CURSOR

INSERT_CURSOR

SQL_ATTR_SAVEPOINT_NAME

EXECUTE_FAILED

SUCCESS_NO_INFO

SQL_ASENSITIVE

SQL_INSENSITIVE

SQL_SENSITIVE

SQL_NONSCROLLABLE

SQL_SCROLLABLE

SQL_NONHOLDABLE

SQL_HOLDABLE

SQL_WITHOUT_RETURN

SQL_WITH_RETURN

SQL_NOT_UPDATABLE

SQL_UPDATABLE

TYPE_FORWARD_ONLY

TYPE_SCROLL_INSENSITIVE

TYPE_SCROLL_SENSITIVE

CONCUR_READ_ONLY

CONCUR_UPDATABLE

HOLD_CURSORS_OVER_COMMIT

CLOSE_CURSORS_AT_COMMIT

RETURN_GENERATED_KEYS

RETURN_NO_GENERATED_KEYS

RETURN_GENERATED_KEYS_COL_NAMES

RETURN_GENERATED_KEYS_COL_INDEXES