Package org.h2.command
Interface CommandInterface
- All Superinterfaces:
AutoCloseable
- All Known Implementing Classes:
Command
,CommandContainer
,CommandList
,CommandRemote
Represents a SQL statement.
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final int
The type of ALTER DOMAIN ADD CONSTRAINT statement.static final int
The type of an ALTER DOMAIN SET DEFAULT and ALTER DOMAIN DROP DEFAULT statements.static final int
The type of ALTER DOMAIN DROP CONSTRAINT statement.static final int
The type of an ALTER DOMAIN SET ON UPDATE and ALTER DOMAIN DROP ON UPDATE statements.static final int
The type of an ALTER DOMAIN RENAME statement.static final int
The type of an ALTER DOMAIN RENAME CONSTRAINT statement.static final int
The type of a ALTER INDEX RENAME statement.static final int
The type of an ALTER SCHEMA RENAME statement.static final int
The type of an ALTER SEQUENCE statement.static final int
The type of an ALTER TABLE ADD statement.static final int
The type of an ALTER TABLE ADD CHECK statement.static final int
The type of an ALTER TABLE ADD PRIMARY KEY statement.static final int
The type of an ALTER TABLE ADD FOREIGN KEY statement.static final int
The type of an ALTER TABLE ADD UNIQUE statement.static final int
The type of an ALTER TABLE ALTER COLUMN statement that changes the column data type.static final int
The type of an ALTER TABLE ALTER COLUMN SET DEFAULT and ALTER TABLE ALTER COLUMN DROP DEFAULT statements.static final int
The type of ALTER TABLE ALTER COLUMN SET DEFAULT ON NULL and ALTER TABLE ALTER COLUMN DROP DEFAULT ON NULL statements.static final int
The type of an ALTER TABLE ALTER COLUMN DROP EXPRESSION statement.static final int
The type of an ALTER TABLE ALTER COLUMN DROP IDENTITY statement.static final int
The type of an ALTER TABLE ALTER COLUMN DROP NOT NULL statement.static final int
The type of an ALTER TABLE ALTER COLUMN SET NOT NULL statement.static final int
The type of an ALTER TABLE ALTER COLUMN SET ON UPDATE statement.static final int
The type of an ALTER TABLE ALTER COLUMN RENAME statement.static final int
The type of an ALTER TABLE ALTER COLUMN SELECTIVITY statement.static final int
The type of an ALTER TABLE ALTER COLUMN SET INVISIBLE statement.static final int
The type of an ALTER TABLE DROP COLUMN statement.static final int
The type of an ALTER TABLE DROP CONSTRAINT statement.static final int
The type of an ALTER TABLE RENAME statement.static final int
The type of an ALTER TABLE RENAME CONSTRAINT statement.static final int
The type of an ALTER TABLE SET REFERENTIAL_INTEGRITY statement.static final int
The type of an ALTER USER ADMIN statement.static final int
The type of an ALTER USER RENAME statement.static final int
The type of an ALTER USER SET PASSWORD statement.static final int
The type of an ALTER VIEW statement.static final int
The type of an ANALYZE statement.static final int
The type of a BACKUP statement.static final int
The type of a BEGIN {WORK|TRANSACTION} statement.static final int
The type of a CALL statement.static final int
The type of a CHECKPOINT statement.static final int
The type of a CHECKPOINT SYNC statement.static final int
The type of a COMMENT statement.static final int
The type of a COMMIT statement.static final int
The type of a COMMIT TRANSACTION statement.static final int
The type of a CREATE AGGREGATE statement.static final int
The type of a CREATE ALIAS statement.static final int
The type of a CREATE CONSTANT statement.static final int
The type of a CREATE DOMAIN statement.static final int
The type of a CREATE INDEX statement.static final int
The type of a CREATE LINKED TABLE statement.static final int
The type of a CREATE ROLE statement.static final int
The type of a CREATE SCHEMA statement.static final int
The type of a CREATE SEQUENCE statement.static final int
The type of a CREATE SYNONYM statement.static final int
The type of a CREATE TABLE statement.static final int
The type of a CREATE TRIGGER statement.static final int
The type of a CREATE USER statement.static final int
The type of a CREATE VIEW statement.static final int
The type of a DEALLOCATE statement.static final int
The type of a DELETE statement.static final int
The type of a DROP AGGREGATE statement.static final int
The type of a DROP ALIAS statement.static final int
The type of a DROP ALL OBJECTS statement.static final int
The type of a DROP CONSTANT statement.static final int
The type of a DROP DOMAIN statement.static final int
The type of a DROP INDEX statement.static final int
The type of a DROP ROLE statement.static final int
The type of a DROP SCHEMA statement.static final int
The type of a DROP SEQUENCE statement.static final int
The type of a DROP SYNONYM statement.static final int
The type of a DROP TABLE statement.static final int
The type of a DROP TRIGGER statement.static final int
The type of a DROP USER statement.static final int
The type of a DROP VIEW statement.static final int
The type of an EXECUTE statement.static final int
The type of an EXECUTE IMMEDIATELY statement.static final int
The type of an EXPLAIN statement.static final int
The type of an EXPLAIN ANALYZE statement.static final int
The type of a GRANT statement.static final int
The type of a HELP statement.static final int
The type of an INSERT statement.static final int
The type of a MERGE statement.static final int
The type of a no operation statement.static final int
The type of a PREPARE statement.static final int
The type of a PREPARE COMMIT statement.static final int
The type of a REPLACE statement.static final int
The type of a REVOKE statement.static final int
The type of a ROLLBACK statement.static final int
The type of a ROLLBACK TO SAVEPOINT statement.static final int
The type of a ROLLBACK TRANSACTION statement.static final int
The type of a RUNSCRIPT statement.static final int
The type of a SAVEPOINT statement.static final int
The type of a SCRIPT statement.static final int
The type of a SELECT statement.static final int
The type of a SET statement.static final int
The type of a SET AUTOCOMMIT statement.static final int
The type of a SET AUTOCOMMIT statement.static final int
The type of a SHUTDOWN statement.static final int
The type of a SHUTDOWN COMPACT statement.static final int
The type of a SHUTDOWN DEFRAG statement.static final int
The type of a SHUTDOWN IMMEDIATELY statement.static final int
The type of a TRUNCATE TABLE statement.static final int
The type for unknown statement.static final int
The type of an UPDATE statement. -
Method Summary
Modifier and TypeMethodDescriptionvoid
cancel()
Cancel the statement if it is still processing.void
close()
Close the statement.executeQuery
(long maxRows, boolean scrollable) Execute the query.executeUpdate
(Object generatedKeysRequest) Execute the statementint
Get command type.Get an empty result set containing the meta data of the result.ArrayList
<? extends ParameterInterface> Get the parameters (if any).boolean
isQuery()
Check if this is a query.void
stop()
Stop the command execution, release all locks and resources
-
Field Details
-
UNKNOWN
static final int UNKNOWNThe type for unknown statement.- See Also:
-
ALTER_INDEX_RENAME
static final int ALTER_INDEX_RENAMEThe type of a ALTER INDEX RENAME statement.- See Also:
-
ALTER_SCHEMA_RENAME
static final int ALTER_SCHEMA_RENAMEThe type of an ALTER SCHEMA RENAME statement.- See Also:
-
ALTER_TABLE_ADD_CONSTRAINT_CHECK
static final int ALTER_TABLE_ADD_CONSTRAINT_CHECKThe type of an ALTER TABLE ADD CHECK statement.- See Also:
-
ALTER_TABLE_ADD_CONSTRAINT_UNIQUE
static final int ALTER_TABLE_ADD_CONSTRAINT_UNIQUEThe type of an ALTER TABLE ADD UNIQUE statement.- See Also:
-
ALTER_TABLE_ADD_CONSTRAINT_REFERENTIAL
static final int ALTER_TABLE_ADD_CONSTRAINT_REFERENTIALThe type of an ALTER TABLE ADD FOREIGN KEY statement.- See Also:
-
ALTER_TABLE_ADD_CONSTRAINT_PRIMARY_KEY
static final int ALTER_TABLE_ADD_CONSTRAINT_PRIMARY_KEYThe type of an ALTER TABLE ADD PRIMARY KEY statement.- See Also:
-
ALTER_TABLE_ADD_COLUMN
static final int ALTER_TABLE_ADD_COLUMNThe type of an ALTER TABLE ADD statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_NOT_NULL
static final int ALTER_TABLE_ALTER_COLUMN_NOT_NULLThe type of an ALTER TABLE ALTER COLUMN SET NOT NULL statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_DROP_NOT_NULL
static final int ALTER_TABLE_ALTER_COLUMN_DROP_NOT_NULLThe type of an ALTER TABLE ALTER COLUMN DROP NOT NULL statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_DEFAULT
static final int ALTER_TABLE_ALTER_COLUMN_DEFAULTThe type of an ALTER TABLE ALTER COLUMN SET DEFAULT and ALTER TABLE ALTER COLUMN DROP DEFAULT statements.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_CHANGE_TYPE
static final int ALTER_TABLE_ALTER_COLUMN_CHANGE_TYPEThe type of an ALTER TABLE ALTER COLUMN statement that changes the column data type.- See Also:
-
ALTER_TABLE_DROP_COLUMN
static final int ALTER_TABLE_DROP_COLUMNThe type of an ALTER TABLE DROP COLUMN statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_SELECTIVITY
static final int ALTER_TABLE_ALTER_COLUMN_SELECTIVITYThe type of an ALTER TABLE ALTER COLUMN SELECTIVITY statement.- See Also:
-
ALTER_TABLE_DROP_CONSTRAINT
static final int ALTER_TABLE_DROP_CONSTRAINTThe type of an ALTER TABLE DROP CONSTRAINT statement.- See Also:
-
ALTER_TABLE_RENAME
static final int ALTER_TABLE_RENAMEThe type of an ALTER TABLE RENAME statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_RENAME
static final int ALTER_TABLE_ALTER_COLUMN_RENAMEThe type of an ALTER TABLE ALTER COLUMN RENAME statement.- See Also:
-
ALTER_USER_ADMIN
static final int ALTER_USER_ADMINThe type of an ALTER USER ADMIN statement.- See Also:
-
ALTER_USER_RENAME
static final int ALTER_USER_RENAMEThe type of an ALTER USER RENAME statement.- See Also:
-
ALTER_USER_SET_PASSWORD
static final int ALTER_USER_SET_PASSWORDThe type of an ALTER USER SET PASSWORD statement.- See Also:
-
ALTER_VIEW
static final int ALTER_VIEWThe type of an ALTER VIEW statement.- See Also:
-
ANALYZE
static final int ANALYZEThe type of an ANALYZE statement.- See Also:
-
CREATE_AGGREGATE
static final int CREATE_AGGREGATEThe type of a CREATE AGGREGATE statement.- See Also:
-
CREATE_CONSTANT
static final int CREATE_CONSTANTThe type of a CREATE CONSTANT statement.- See Also:
-
CREATE_ALIAS
static final int CREATE_ALIASThe type of a CREATE ALIAS statement.- See Also:
-
CREATE_INDEX
static final int CREATE_INDEXThe type of a CREATE INDEX statement.- See Also:
-
CREATE_LINKED_TABLE
static final int CREATE_LINKED_TABLEThe type of a CREATE LINKED TABLE statement.- See Also:
-
CREATE_ROLE
static final int CREATE_ROLEThe type of a CREATE ROLE statement.- See Also:
-
CREATE_SCHEMA
static final int CREATE_SCHEMAThe type of a CREATE SCHEMA statement.- See Also:
-
CREATE_SEQUENCE
static final int CREATE_SEQUENCEThe type of a CREATE SEQUENCE statement.- See Also:
-
CREATE_TABLE
static final int CREATE_TABLEThe type of a CREATE TABLE statement.- See Also:
-
CREATE_TRIGGER
static final int CREATE_TRIGGERThe type of a CREATE TRIGGER statement.- See Also:
-
CREATE_USER
static final int CREATE_USERThe type of a CREATE USER statement.- See Also:
-
CREATE_DOMAIN
static final int CREATE_DOMAINThe type of a CREATE DOMAIN statement.- See Also:
-
CREATE_VIEW
static final int CREATE_VIEWThe type of a CREATE VIEW statement.- See Also:
-
DEALLOCATE
static final int DEALLOCATEThe type of a DEALLOCATE statement.- See Also:
-
DROP_AGGREGATE
static final int DROP_AGGREGATEThe type of a DROP AGGREGATE statement.- See Also:
-
DROP_CONSTANT
static final int DROP_CONSTANTThe type of a DROP CONSTANT statement.- See Also:
-
DROP_ALL_OBJECTS
static final int DROP_ALL_OBJECTSThe type of a DROP ALL OBJECTS statement.- See Also:
-
DROP_ALIAS
static final int DROP_ALIASThe type of a DROP ALIAS statement.- See Also:
-
DROP_INDEX
static final int DROP_INDEXThe type of a DROP INDEX statement.- See Also:
-
DROP_ROLE
static final int DROP_ROLEThe type of a DROP ROLE statement.- See Also:
-
DROP_SCHEMA
static final int DROP_SCHEMAThe type of a DROP SCHEMA statement.- See Also:
-
DROP_SEQUENCE
static final int DROP_SEQUENCEThe type of a DROP SEQUENCE statement.- See Also:
-
DROP_TABLE
static final int DROP_TABLEThe type of a DROP TABLE statement.- See Also:
-
DROP_TRIGGER
static final int DROP_TRIGGERThe type of a DROP TRIGGER statement.- See Also:
-
DROP_USER
static final int DROP_USERThe type of a DROP USER statement.- See Also:
-
DROP_DOMAIN
static final int DROP_DOMAINThe type of a DROP DOMAIN statement.- See Also:
-
DROP_VIEW
static final int DROP_VIEWThe type of a DROP VIEW statement.- See Also:
-
GRANT
static final int GRANTThe type of a GRANT statement.- See Also:
-
REVOKE
static final int REVOKEThe type of a REVOKE statement.- See Also:
-
PREPARE
static final int PREPAREThe type of a PREPARE statement.- See Also:
-
COMMENT
static final int COMMENTThe type of a COMMENT statement.- See Also:
-
TRUNCATE_TABLE
static final int TRUNCATE_TABLEThe type of a TRUNCATE TABLE statement.- See Also:
-
ALTER_SEQUENCE
static final int ALTER_SEQUENCEThe type of an ALTER SEQUENCE statement.- See Also:
-
ALTER_TABLE_SET_REFERENTIAL_INTEGRITY
static final int ALTER_TABLE_SET_REFERENTIAL_INTEGRITYThe type of an ALTER TABLE SET REFERENTIAL_INTEGRITY statement.- See Also:
-
BACKUP
static final int BACKUPThe type of a BACKUP statement.- See Also:
-
CALL
static final int CALLThe type of a CALL statement.- See Also:
-
DELETE
static final int DELETEThe type of a DELETE statement.- See Also:
-
EXECUTE
static final int EXECUTEThe type of an EXECUTE statement.- See Also:
-
EXPLAIN
static final int EXPLAINThe type of an EXPLAIN statement.- See Also:
-
INSERT
static final int INSERTThe type of an INSERT statement.- See Also:
-
MERGE
static final int MERGEThe type of a MERGE statement.- See Also:
-
REPLACE
static final int REPLACEThe type of a REPLACE statement.- See Also:
-
NO_OPERATION
static final int NO_OPERATIONThe type of a no operation statement.- See Also:
-
RUNSCRIPT
static final int RUNSCRIPTThe type of a RUNSCRIPT statement.- See Also:
-
SCRIPT
static final int SCRIPTThe type of a SCRIPT statement.- See Also:
-
SELECT
static final int SELECTThe type of a SELECT statement.- See Also:
-
SET
static final int SETThe type of a SET statement.- See Also:
-
UPDATE
static final int UPDATEThe type of an UPDATE statement.- See Also:
-
SET_AUTOCOMMIT_TRUE
static final int SET_AUTOCOMMIT_TRUEThe type of a SET AUTOCOMMIT statement.- See Also:
-
SET_AUTOCOMMIT_FALSE
static final int SET_AUTOCOMMIT_FALSEThe type of a SET AUTOCOMMIT statement.- See Also:
-
COMMIT
static final int COMMITThe type of a COMMIT statement.- See Also:
-
ROLLBACK
static final int ROLLBACKThe type of a ROLLBACK statement.- See Also:
-
CHECKPOINT
static final int CHECKPOINTThe type of a CHECKPOINT statement.- See Also:
-
SAVEPOINT
static final int SAVEPOINTThe type of a SAVEPOINT statement.- See Also:
-
ROLLBACK_TO_SAVEPOINT
static final int ROLLBACK_TO_SAVEPOINTThe type of a ROLLBACK TO SAVEPOINT statement.- See Also:
-
CHECKPOINT_SYNC
static final int CHECKPOINT_SYNCThe type of a CHECKPOINT SYNC statement.- See Also:
-
PREPARE_COMMIT
static final int PREPARE_COMMITThe type of a PREPARE COMMIT statement.- See Also:
-
COMMIT_TRANSACTION
static final int COMMIT_TRANSACTIONThe type of a COMMIT TRANSACTION statement.- See Also:
-
ROLLBACK_TRANSACTION
static final int ROLLBACK_TRANSACTIONThe type of a ROLLBACK TRANSACTION statement.- See Also:
-
SHUTDOWN
static final int SHUTDOWNThe type of a SHUTDOWN statement.- See Also:
-
SHUTDOWN_IMMEDIATELY
static final int SHUTDOWN_IMMEDIATELYThe type of a SHUTDOWN IMMEDIATELY statement.- See Also:
-
SHUTDOWN_COMPACT
static final int SHUTDOWN_COMPACTThe type of a SHUTDOWN COMPACT statement.- See Also:
-
BEGIN
static final int BEGINThe type of a BEGIN {WORK|TRANSACTION} statement.- See Also:
-
SHUTDOWN_DEFRAG
static final int SHUTDOWN_DEFRAGThe type of a SHUTDOWN DEFRAG statement.- See Also:
-
ALTER_TABLE_RENAME_CONSTRAINT
static final int ALTER_TABLE_RENAME_CONSTRAINTThe type of an ALTER TABLE RENAME CONSTRAINT statement.- See Also:
-
EXPLAIN_ANALYZE
static final int EXPLAIN_ANALYZEThe type of an EXPLAIN ANALYZE statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_VISIBILITY
static final int ALTER_TABLE_ALTER_COLUMN_VISIBILITYThe type of an ALTER TABLE ALTER COLUMN SET INVISIBLE statement.- See Also:
-
CREATE_SYNONYM
static final int CREATE_SYNONYMThe type of a CREATE SYNONYM statement.- See Also:
-
DROP_SYNONYM
static final int DROP_SYNONYMThe type of a DROP SYNONYM statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_ON_UPDATE
static final int ALTER_TABLE_ALTER_COLUMN_ON_UPDATEThe type of an ALTER TABLE ALTER COLUMN SET ON UPDATE statement.- See Also:
-
EXECUTE_IMMEDIATELY
static final int EXECUTE_IMMEDIATELYThe type of an EXECUTE IMMEDIATELY statement.- See Also:
-
ALTER_DOMAIN_ADD_CONSTRAINT
static final int ALTER_DOMAIN_ADD_CONSTRAINTThe type of ALTER DOMAIN ADD CONSTRAINT statement.- See Also:
-
ALTER_DOMAIN_DROP_CONSTRAINT
static final int ALTER_DOMAIN_DROP_CONSTRAINTThe type of ALTER DOMAIN DROP CONSTRAINT statement.- See Also:
-
ALTER_DOMAIN_DEFAULT
static final int ALTER_DOMAIN_DEFAULTThe type of an ALTER DOMAIN SET DEFAULT and ALTER DOMAIN DROP DEFAULT statements.- See Also:
-
ALTER_DOMAIN_ON_UPDATE
static final int ALTER_DOMAIN_ON_UPDATEThe type of an ALTER DOMAIN SET ON UPDATE and ALTER DOMAIN DROP ON UPDATE statements.- See Also:
-
ALTER_DOMAIN_RENAME
static final int ALTER_DOMAIN_RENAMEThe type of an ALTER DOMAIN RENAME statement.- See Also:
-
HELP
static final int HELPThe type of a HELP statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_DROP_EXPRESSION
static final int ALTER_TABLE_ALTER_COLUMN_DROP_EXPRESSIONThe type of an ALTER TABLE ALTER COLUMN DROP EXPRESSION statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_DROP_IDENTITY
static final int ALTER_TABLE_ALTER_COLUMN_DROP_IDENTITYThe type of an ALTER TABLE ALTER COLUMN DROP IDENTITY statement.- See Also:
-
ALTER_TABLE_ALTER_COLUMN_DEFAULT_ON_NULL
static final int ALTER_TABLE_ALTER_COLUMN_DEFAULT_ON_NULLThe type of ALTER TABLE ALTER COLUMN SET DEFAULT ON NULL and ALTER TABLE ALTER COLUMN DROP DEFAULT ON NULL statements.- See Also:
-
ALTER_DOMAIN_RENAME_CONSTRAINT
static final int ALTER_DOMAIN_RENAME_CONSTRAINTThe type of an ALTER DOMAIN RENAME CONSTRAINT statement.- See Also:
-
-
Method Details
-
getCommandType
int getCommandType()Get command type.- Returns:
- one of the constants above
-
isQuery
boolean isQuery()Check if this is a query.- Returns:
- true if it is a query
-
getParameters
ArrayList<? extends ParameterInterface> getParameters()Get the parameters (if any).- Returns:
- the parameters
-
executeQuery
Execute the query.- Parameters:
maxRows
- the maximum number of rows returnedscrollable
- if the result set must be scrollable- Returns:
- the result
-
executeUpdate
Execute the statement- Parameters:
generatedKeysRequest
-null
orfalse
if generated keys are not needed,true
if generated keys should be configured automatically,int[]
to specify column indices to return generated keys from, orString[]
to specify column names to return generated keys from- Returns:
- the update count and generated keys, if any
-
stop
void stop()Stop the command execution, release all locks and resources -
close
void close()Close the statement.- Specified by:
close
in interfaceAutoCloseable
-
cancel
void cancel()Cancel the statement if it is still processing. -
getMetaData
ResultInterface getMetaData()Get an empty result set containing the meta data of the result.- Returns:
- the empty result
-