H2 Database Engine 2.3.232 · org.h2.command.CommandInterface

Field Summary

Modifier and Type	Field and Description
public static final int	ALTER_DOMAIN_ADD_CONSTRAINT The type of ALTER DOMAIN ADD CONSTRAINT statement.
public static final int	ALTER_DOMAIN_DEFAULT The type of an ALTER DOMAIN SET DEFAULT and ALTER DOMAIN DROP DEFAULT statements.
public static final int	ALTER_DOMAIN_DROP_CONSTRAINT The type of ALTER DOMAIN DROP CONSTRAINT statement.
public static final int	ALTER_DOMAIN_ON_UPDATE The type of an ALTER DOMAIN SET ON UPDATE and ALTER DOMAIN DROP ON UPDATE statements.
public static final int	ALTER_DOMAIN_RENAME The type of an ALTER DOMAIN RENAME statement.
public static final int	ALTER_DOMAIN_RENAME_CONSTRAINT The type of an ALTER DOMAIN RENAME CONSTRAINT statement.
public static final int	ALTER_INDEX_RENAME The type of a ALTER INDEX RENAME statement.
public static final int	ALTER_SCHEMA_RENAME The type of an ALTER SCHEMA RENAME statement.
public static final int	ALTER_SEQUENCE The type of an ALTER SEQUENCE statement.
public static final int	ALTER_TABLE_ADD_COLUMN The type of an ALTER TABLE ADD statement.
public static final int	ALTER_TABLE_ADD_CONSTRAINT_CHECK The type of an ALTER TABLE ADD CHECK statement.
public static final int	ALTER_TABLE_ADD_CONSTRAINT_PRIMARY_KEY The type of an ALTER TABLE ADD PRIMARY KEY statement.
public static final int	ALTER_TABLE_ADD_CONSTRAINT_REFERENTIAL The type of an ALTER TABLE ADD FOREIGN KEY statement.
public static final int	ALTER_TABLE_ADD_CONSTRAINT_UNIQUE The type of an ALTER TABLE ADD UNIQUE statement.
public static final int	ALTER_TABLE_ALTER_COLUMN_CHANGE_TYPE The type of an ALTER TABLE ALTER COLUMN statement that changes the column data type.
public static final int	ALTER_TABLE_ALTER_COLUMN_DEFAULT The type of an ALTER TABLE ALTER COLUMN SET DEFAULT and ALTER TABLE ALTER COLUMN DROP DEFAULT statements.
public static final int	ALTER_TABLE_ALTER_COLUMN_DEFAULT_ON_NULL The type of ALTER TABLE ALTER COLUMN SET DEFAULT ON NULL and ALTER TABLE ALTER COLUMN DROP DEFAULT ON NULL statements.
public static final int	ALTER_TABLE_ALTER_COLUMN_DROP_EXPRESSION The type of an ALTER TABLE ALTER COLUMN DROP EXPRESSION statement.
public static final int	ALTER_TABLE_ALTER_COLUMN_DROP_IDENTITY The type of an ALTER TABLE ALTER COLUMN DROP IDENTITY statement.
public static final int	ALTER_TABLE_ALTER_COLUMN_DROP_NOT_NULL The type of an ALTER TABLE ALTER COLUMN DROP NOT NULL statement.
public static final int	ALTER_TABLE_ALTER_COLUMN_NOT_NULL The type of an ALTER TABLE ALTER COLUMN SET NOT NULL statement.
public static final int	ALTER_TABLE_ALTER_COLUMN_ON_UPDATE The type of an ALTER TABLE ALTER COLUMN SET ON UPDATE statement.
public static final int	ALTER_TABLE_ALTER_COLUMN_RENAME The type of an ALTER TABLE ALTER COLUMN RENAME statement.
public static final int	ALTER_TABLE_ALTER_COLUMN_SELECTIVITY The type of an ALTER TABLE ALTER COLUMN SELECTIVITY statement.
public static final int	ALTER_TABLE_ALTER_COLUMN_VISIBILITY The type of an ALTER TABLE ALTER COLUMN SET INVISIBLE statement.
public static final int	ALTER_TABLE_DROP_COLUMN The type of an ALTER TABLE DROP COLUMN statement.
public static final int	ALTER_TABLE_DROP_CONSTRAINT The type of an ALTER TABLE DROP CONSTRAINT statement.
public static final int	ALTER_TABLE_RENAME The type of an ALTER TABLE RENAME statement.
public static final int	ALTER_TABLE_RENAME_CONSTRAINT The type of an ALTER TABLE RENAME CONSTRAINT statement.
public static final int	ALTER_TABLE_SET_REFERENTIAL_INTEGRITY The type of an ALTER TABLE SET REFERENTIAL_INTEGRITY statement.
public static final int	ALTER_USER_ADMIN The type of an ALTER USER ADMIN statement.
public static final int	ALTER_USER_RENAME The type of an ALTER USER RENAME statement.
public static final int	ALTER_USER_SET_PASSWORD The type of an ALTER USER SET PASSWORD statement.
public static final int	ALTER_VIEW The type of an ALTER VIEW statement.
public static final int	ANALYZE The type of an ANALYZE statement.
public static final int	BACKUP The type of a BACKUP statement.
public static final int	BEGIN The type of a BEGIN {WORK\|TRANSACTION} statement.
public static final int	CALL The type of a CALL statement.
public static final int	CHECKPOINT The type of a CHECKPOINT statement.
public static final int	CHECKPOINT_SYNC The type of a CHECKPOINT SYNC statement.
public static final int	COMMENT The type of a COMMENT statement.
public static final int	COMMIT The type of a COMMIT statement.
public static final int	COMMIT_TRANSACTION The type of a COMMIT TRANSACTION statement.
public static final int	CREATE_AGGREGATE The type of a CREATE AGGREGATE statement.
public static final int	CREATE_ALIAS The type of a CREATE ALIAS statement.
public static final int	CREATE_CONSTANT The type of a CREATE CONSTANT statement.
public static final int	CREATE_DOMAIN The type of a CREATE DOMAIN statement.
public static final int	CREATE_INDEX The type of a CREATE INDEX statement.
public static final int	CREATE_LINKED_TABLE The type of a CREATE LINKED TABLE statement.
public static final int	CREATE_MATERIALIZED_VIEW The type of a CREATE MATERIALIZED VIEW statement.
public static final int	CREATE_ROLE The type of a CREATE ROLE statement.
public static final int	CREATE_SCHEMA The type of a CREATE SCHEMA statement.
public static final int	CREATE_SEQUENCE The type of a CREATE SEQUENCE statement.
public static final int	CREATE_SYNONYM The type of a CREATE SYNONYM statement.
public static final int	CREATE_TABLE The type of a CREATE TABLE statement.
public static final int	CREATE_TRIGGER The type of a CREATE TRIGGER statement.
public static final int	CREATE_USER The type of a CREATE USER statement.
public static final int	CREATE_VIEW The type of a CREATE VIEW statement.
public static final int	DEALLOCATE The type of a DEALLOCATE statement.
public static final int	DELETE The type of a DELETE statement.
public static final int	DROP_AGGREGATE The type of a DROP AGGREGATE statement.
public static final int	DROP_ALIAS The type of a DROP ALIAS statement.
public static final int	DROP_ALL_OBJECTS The type of a DROP ALL OBJECTS statement.
public static final int	DROP_CONSTANT The type of a DROP CONSTANT statement.
public static final int	DROP_DOMAIN The type of a DROP DOMAIN statement.
public static final int	DROP_INDEX The type of a DROP INDEX statement.
public static final int	DROP_MATERIALIZED_VIEW The type of a DROP MATERIALIZED VIEW statement.
public static final int	DROP_ROLE The type of a DROP ROLE statement.
public static final int	DROP_SCHEMA The type of a DROP SCHEMA statement.
public static final int	DROP_SEQUENCE The type of a DROP SEQUENCE statement.
public static final int	DROP_SYNONYM The type of a DROP SYNONYM statement.
public static final int	DROP_TABLE The type of a DROP TABLE statement.
public static final int	DROP_TRIGGER The type of a DROP TRIGGER statement.
public static final int	DROP_USER The type of a DROP USER statement.
public static final int	DROP_VIEW The type of a DROP VIEW statement.
public static final int	EXECUTE The type of an EXECUTE statement.
public static final int	EXECUTE_IMMEDIATELY The type of an EXECUTE IMMEDIATELY statement.
public static final int	EXPLAIN The type of an EXPLAIN statement.
public static final int	EXPLAIN_ANALYZE The type of an EXPLAIN ANALYZE statement.
public static final int	GRANT The type of a GRANT statement.
public static final int	HELP The type of a HELP statement.
public static final int	INSERT The type of an INSERT statement.
public static final int	MERGE The type of a MERGE statement.
public static final int	NO_OPERATION The type of a no operation statement.
public static final int	PREPARE The type of a PREPARE statement.
public static final int	PREPARE_COMMIT The type of a PREPARE COMMIT statement.
public static final int	REFRESH_MATERIALIZED_VIEW The type of a REFRESH MATERIALIZED VIEW statement.
public static final int	REPLACE The type of a REPLACE statement.
public static final int	REVOKE The type of a REVOKE statement.
public static final int	ROLLBACK The type of a ROLLBACK statement.
public static final int	ROLLBACK_TO_SAVEPOINT The type of a ROLLBACK TO SAVEPOINT statement.
public static final int	ROLLBACK_TRANSACTION The type of a ROLLBACK TRANSACTION statement.
public static final int	RUNSCRIPT The type of a RUNSCRIPT statement.
public static final int	SAVEPOINT The type of a SAVEPOINT statement.
public static final int	SCRIPT The type of a SCRIPT statement.
public static final int	SELECT The type of a SELECT statement.
public static final int	SET The type of a SET statement.
public static final int	SET_AUTOCOMMIT_FALSE The type of a SET AUTOCOMMIT statement.
public static final int	SET_AUTOCOMMIT_TRUE The type of a SET AUTOCOMMIT statement.
public static final int	SHUTDOWN The type of a SHUTDOWN statement.
public static final int	SHUTDOWN_COMPACT The type of a SHUTDOWN COMPACT statement.
public static final int	SHUTDOWN_DEFRAG The type of a SHUTDOWN DEFRAG statement.
public static final int	SHUTDOWN_IMMEDIATELY The type of a SHUTDOWN IMMEDIATELY statement.
public static final int	TRUNCATE_TABLE The type of a TRUNCATE TABLE statement.
public static final int	UNKNOWN The type for unknown statement.
public static final int	UPDATE The type of an UPDATE statement.

Method Summary

Modifier and Type	Method and Description
public void	cancel() Cancel the statement if it is still processing.
public void	close() Redeclares java.lang.AutoCloseable.close. Close the statement.
public BatchResult	Returns: result of batch execution executeBatchUpdate(ArrayList<Value[]> batch parameters batchParameters, Object `null` or `false` if generated keys are not needed, `true` if generated keys should be configured automatically, `int[]` to specify column indices to return generated keys from, or `String[]` to specify column names to return generated keys from generatedKeysRequest) Executes the statement with multiple sets of parameters.
public ResultInterface	Returns: the result executeQuery(long the maximum number of rows returned maxRows, boolean if the result set must be scrollable scrollable) Execute the query.
public ResultWithGeneratedKeys	Returns: the update count and generated keys, if any executeUpdate(Object `null` or `false` if generated keys are not needed, `true` if generated keys should be configured automatically, `int[]` to specify column indices to return generated keys from, or `String[]` to specify column names to return generated keys from generatedKeysRequest) Execute the statement
public int	Returns: one of the constants above getCommandType() Get command type.
public ResultInterface	Returns: the empty result getMetaData() Get an empty result set containing the meta data of the result.
public ArrayList<? extends ParameterInterface>	Returns: the parameters getParameters() Get the parameters (if any).
public boolean	Returns: true if it is a query isQuery() Check if this is a query.
public void	stop(boolean commit the session if auto-commit is enabled commitIfAutoCommit) Stop the command execution, release all locks and resources.

Field Detail

ALTER_DOMAIN_ADD_CONSTRAINT	back to summary
public static final int ALTER_DOMAIN_ADD_CONSTRAINT The type of ALTER DOMAIN ADD CONSTRAINT statement.

ALTER_DOMAIN_DEFAULT	back to summary
public static final int ALTER_DOMAIN_DEFAULT The type of an ALTER DOMAIN SET DEFAULT and ALTER DOMAIN DROP DEFAULT statements.

ALTER_DOMAIN_DROP_CONSTRAINT	back to summary
public static final int ALTER_DOMAIN_DROP_CONSTRAINT The type of ALTER DOMAIN DROP CONSTRAINT statement.

ALTER_DOMAIN_ON_UPDATE	back to summary
public static final int ALTER_DOMAIN_ON_UPDATE The type of an ALTER DOMAIN SET ON UPDATE and ALTER DOMAIN DROP ON UPDATE statements.

ALTER_DOMAIN_RENAME	back to summary
public static final int ALTER_DOMAIN_RENAME The type of an ALTER DOMAIN RENAME statement.

ALTER_DOMAIN_RENAME_CONSTRAINT	back to summary
public static final int ALTER_DOMAIN_RENAME_CONSTRAINT The type of an ALTER DOMAIN RENAME CONSTRAINT statement.

ALTER_INDEX_RENAME	back to summary
public static final int ALTER_INDEX_RENAME The type of a ALTER INDEX RENAME statement.

ALTER_SCHEMA_RENAME	back to summary
public static final int ALTER_SCHEMA_RENAME The type of an ALTER SCHEMA RENAME statement.

ALTER_SEQUENCE	back to summary
public static final int ALTER_SEQUENCE The type of an ALTER SEQUENCE statement.

ALTER_TABLE_ADD_COLUMN	back to summary
public static final int ALTER_TABLE_ADD_COLUMN The type of an ALTER TABLE ADD statement.

ALTER_TABLE_ADD_CONSTRAINT_CHECK	back to summary
public static final int ALTER_TABLE_ADD_CONSTRAINT_CHECK The type of an ALTER TABLE ADD CHECK statement.

ALTER_TABLE_ADD_CONSTRAINT_PRIMARY_KEY	back to summary
public static final int ALTER_TABLE_ADD_CONSTRAINT_PRIMARY_KEY The type of an ALTER TABLE ADD PRIMARY KEY statement.

ALTER_TABLE_ADD_CONSTRAINT_REFERENTIAL	back to summary
public static final int ALTER_TABLE_ADD_CONSTRAINT_REFERENTIAL The type of an ALTER TABLE ADD FOREIGN KEY statement.

ALTER_TABLE_ADD_CONSTRAINT_UNIQUE	back to summary
public static final int ALTER_TABLE_ADD_CONSTRAINT_UNIQUE The type of an ALTER TABLE ADD UNIQUE statement.

ALTER_TABLE_ALTER_COLUMN_CHANGE_TYPE	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_CHANGE_TYPE The type of an ALTER TABLE ALTER COLUMN statement that changes the column data type.

ALTER_TABLE_ALTER_COLUMN_DEFAULT	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_DEFAULT The type of an ALTER TABLE ALTER COLUMN SET DEFAULT and ALTER TABLE ALTER COLUMN DROP DEFAULT statements.

ALTER_TABLE_ALTER_COLUMN_DEFAULT_ON_NULL	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_DEFAULT_ON_NULL The type of ALTER TABLE ALTER COLUMN SET DEFAULT ON NULL and ALTER TABLE ALTER COLUMN DROP DEFAULT ON NULL statements.

ALTER_TABLE_ALTER_COLUMN_DROP_EXPRESSION	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_DROP_EXPRESSION The type of an ALTER TABLE ALTER COLUMN DROP EXPRESSION statement.

ALTER_TABLE_ALTER_COLUMN_DROP_IDENTITY	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_DROP_IDENTITY The type of an ALTER TABLE ALTER COLUMN DROP IDENTITY statement.

ALTER_TABLE_ALTER_COLUMN_DROP_NOT_NULL	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_DROP_NOT_NULL The type of an ALTER TABLE ALTER COLUMN DROP NOT NULL statement.

ALTER_TABLE_ALTER_COLUMN_NOT_NULL	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_NOT_NULL The type of an ALTER TABLE ALTER COLUMN SET NOT NULL statement.

ALTER_TABLE_ALTER_COLUMN_ON_UPDATE	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_ON_UPDATE The type of an ALTER TABLE ALTER COLUMN SET ON UPDATE statement.

ALTER_TABLE_ALTER_COLUMN_RENAME	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_RENAME The type of an ALTER TABLE ALTER COLUMN RENAME statement.

ALTER_TABLE_ALTER_COLUMN_SELECTIVITY	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_SELECTIVITY The type of an ALTER TABLE ALTER COLUMN SELECTIVITY statement.

ALTER_TABLE_ALTER_COLUMN_VISIBILITY	back to summary
public static final int ALTER_TABLE_ALTER_COLUMN_VISIBILITY The type of an ALTER TABLE ALTER COLUMN SET INVISIBLE statement.

ALTER_TABLE_DROP_COLUMN	back to summary
public static final int ALTER_TABLE_DROP_COLUMN The type of an ALTER TABLE DROP COLUMN statement.

ALTER_TABLE_DROP_CONSTRAINT	back to summary
public static final int ALTER_TABLE_DROP_CONSTRAINT The type of an ALTER TABLE DROP CONSTRAINT statement.

ALTER_TABLE_RENAME	back to summary
public static final int ALTER_TABLE_RENAME The type of an ALTER TABLE RENAME statement.

ALTER_TABLE_RENAME_CONSTRAINT	back to summary
public static final int ALTER_TABLE_RENAME_CONSTRAINT The type of an ALTER TABLE RENAME CONSTRAINT statement.

ALTER_TABLE_SET_REFERENTIAL_INTEGRITY	back to summary
public static final int ALTER_TABLE_SET_REFERENTIAL_INTEGRITY The type of an ALTER TABLE SET REFERENTIAL_INTEGRITY statement.

ALTER_USER_ADMIN	back to summary
public static final int ALTER_USER_ADMIN The type of an ALTER USER ADMIN statement.

ALTER_USER_RENAME	back to summary
public static final int ALTER_USER_RENAME The type of an ALTER USER RENAME statement.

ALTER_USER_SET_PASSWORD	back to summary
public static final int ALTER_USER_SET_PASSWORD The type of an ALTER USER SET PASSWORD statement.

ALTER_VIEW	back to summary
public static final int ALTER_VIEW The type of an ALTER VIEW statement.

ANALYZE	back to summary
public static final int ANALYZE The type of an ANALYZE statement.

BACKUP	back to summary
public static final int BACKUP The type of a BACKUP statement.

BEGIN	back to summary
public static final int BEGIN The type of a BEGIN {WORK\|TRANSACTION} statement.

CALL	back to summary
public static final int CALL The type of a CALL statement.

CHECKPOINT	back to summary
public static final int CHECKPOINT The type of a CHECKPOINT statement.

CHECKPOINT_SYNC	back to summary
public static final int CHECKPOINT_SYNC The type of a CHECKPOINT SYNC statement.

COMMENT	back to summary
public static final int COMMENT The type of a COMMENT statement.

COMMIT	back to summary
public static final int COMMIT The type of a COMMIT statement.

COMMIT_TRANSACTION	back to summary
public static final int COMMIT_TRANSACTION The type of a COMMIT TRANSACTION statement.

CREATE_AGGREGATE	back to summary
public static final int CREATE_AGGREGATE The type of a CREATE AGGREGATE statement.

CREATE_ALIAS	back to summary
public static final int CREATE_ALIAS The type of a CREATE ALIAS statement.

CREATE_CONSTANT	back to summary
public static final int CREATE_CONSTANT The type of a CREATE CONSTANT statement.

CREATE_DOMAIN	back to summary
public static final int CREATE_DOMAIN The type of a CREATE DOMAIN statement.

CREATE_INDEX	back to summary
public static final int CREATE_INDEX The type of a CREATE INDEX statement.

CREATE_LINKED_TABLE	back to summary
public static final int CREATE_LINKED_TABLE The type of a CREATE LINKED TABLE statement.

CREATE_MATERIALIZED_VIEW	back to summary
public static final int CREATE_MATERIALIZED_VIEW The type of a CREATE MATERIALIZED VIEW statement.

CREATE_ROLE	back to summary
public static final int CREATE_ROLE The type of a CREATE ROLE statement.

CREATE_SCHEMA	back to summary
public static final int CREATE_SCHEMA The type of a CREATE SCHEMA statement.

CREATE_SEQUENCE	back to summary
public static final int CREATE_SEQUENCE The type of a CREATE SEQUENCE statement.

CREATE_SYNONYM	back to summary
public static final int CREATE_SYNONYM The type of a CREATE SYNONYM statement.

CREATE_TABLE	back to summary
public static final int CREATE_TABLE The type of a CREATE TABLE statement.

CREATE_TRIGGER	back to summary
public static final int CREATE_TRIGGER The type of a CREATE TRIGGER statement.

CREATE_USER	back to summary
public static final int CREATE_USER The type of a CREATE USER statement.

CREATE_VIEW	back to summary
public static final int CREATE_VIEW The type of a CREATE VIEW statement.

DEALLOCATE	back to summary
public static final int DEALLOCATE The type of a DEALLOCATE statement.

DELETE	back to summary
public static final int DELETE The type of a DELETE statement.

DROP_AGGREGATE	back to summary
public static final int DROP_AGGREGATE The type of a DROP AGGREGATE statement.

DROP_ALIAS	back to summary
public static final int DROP_ALIAS The type of a DROP ALIAS statement.

DROP_ALL_OBJECTS	back to summary
public static final int DROP_ALL_OBJECTS The type of a DROP ALL OBJECTS statement.

DROP_CONSTANT	back to summary
public static final int DROP_CONSTANT The type of a DROP CONSTANT statement.

DROP_DOMAIN	back to summary
public static final int DROP_DOMAIN The type of a DROP DOMAIN statement.

DROP_INDEX	back to summary
public static final int DROP_INDEX The type of a DROP INDEX statement.

DROP_MATERIALIZED_VIEW	back to summary
public static final int DROP_MATERIALIZED_VIEW The type of a DROP MATERIALIZED VIEW statement.

DROP_ROLE	back to summary
public static final int DROP_ROLE The type of a DROP ROLE statement.

DROP_SCHEMA	back to summary
public static final int DROP_SCHEMA The type of a DROP SCHEMA statement.

DROP_SEQUENCE	back to summary
public static final int DROP_SEQUENCE The type of a DROP SEQUENCE statement.

DROP_SYNONYM	back to summary
public static final int DROP_SYNONYM The type of a DROP SYNONYM statement.

DROP_TABLE	back to summary
public static final int DROP_TABLE The type of a DROP TABLE statement.

DROP_TRIGGER	back to summary
public static final int DROP_TRIGGER The type of a DROP TRIGGER statement.

DROP_USER	back to summary
public static final int DROP_USER The type of a DROP USER statement.

DROP_VIEW	back to summary
public static final int DROP_VIEW The type of a DROP VIEW statement.

EXECUTE	back to summary
public static final int EXECUTE The type of an EXECUTE statement.

EXECUTE_IMMEDIATELY	back to summary
public static final int EXECUTE_IMMEDIATELY The type of an EXECUTE IMMEDIATELY statement.

EXPLAIN	back to summary
public static final int EXPLAIN The type of an EXPLAIN statement.

EXPLAIN_ANALYZE	back to summary
public static final int EXPLAIN_ANALYZE The type of an EXPLAIN ANALYZE statement.

GRANT	back to summary
public static final int GRANT The type of a GRANT statement.

HELP	back to summary
public static final int HELP The type of a HELP statement.

INSERT	back to summary
public static final int INSERT The type of an INSERT statement.

MERGE	back to summary
public static final int MERGE The type of a MERGE statement.

NO_OPERATION	back to summary
public static final int NO_OPERATION The type of a no operation statement.

PREPARE	back to summary
public static final int PREPARE The type of a PREPARE statement.

PREPARE_COMMIT	back to summary
public static final int PREPARE_COMMIT The type of a PREPARE COMMIT statement.

REFRESH_MATERIALIZED_VIEW	back to summary
public static final int REFRESH_MATERIALIZED_VIEW The type of a REFRESH MATERIALIZED VIEW statement.

REPLACE	back to summary
public static final int REPLACE The type of a REPLACE statement.

REVOKE	back to summary
public static final int REVOKE The type of a REVOKE statement.

ROLLBACK	back to summary
public static final int ROLLBACK The type of a ROLLBACK statement.

ROLLBACK_TO_SAVEPOINT	back to summary
public static final int ROLLBACK_TO_SAVEPOINT The type of a ROLLBACK TO SAVEPOINT statement.

ROLLBACK_TRANSACTION	back to summary
public static final int ROLLBACK_TRANSACTION The type of a ROLLBACK TRANSACTION statement.

RUNSCRIPT	back to summary
public static final int RUNSCRIPT The type of a RUNSCRIPT statement.

SAVEPOINT	back to summary
public static final int SAVEPOINT The type of a SAVEPOINT statement.

SCRIPT	back to summary
public static final int SCRIPT The type of a SCRIPT statement.

SELECT	back to summary
public static final int SELECT The type of a SELECT statement.

SET	back to summary
public static final int SET The type of a SET statement.

SET_AUTOCOMMIT_FALSE	back to summary
public static final int SET_AUTOCOMMIT_FALSE The type of a SET AUTOCOMMIT statement.

SET_AUTOCOMMIT_TRUE	back to summary
public static final int SET_AUTOCOMMIT_TRUE The type of a SET AUTOCOMMIT statement.

SHUTDOWN	back to summary
public static final int SHUTDOWN The type of a SHUTDOWN statement.

SHUTDOWN_COMPACT	back to summary
public static final int SHUTDOWN_COMPACT The type of a SHUTDOWN COMPACT statement.

SHUTDOWN_DEFRAG	back to summary
public static final int SHUTDOWN_DEFRAG The type of a SHUTDOWN DEFRAG statement.

SHUTDOWN_IMMEDIATELY	back to summary
public static final int SHUTDOWN_IMMEDIATELY The type of a SHUTDOWN IMMEDIATELY statement.

TRUNCATE_TABLE	back to summary
public static final int TRUNCATE_TABLE The type of a TRUNCATE TABLE statement.

UNKNOWN	back to summary
public static final int UNKNOWN The type for unknown statement.

UPDATE	back to summary
public static final int UPDATE The type of an UPDATE statement.

Method Detail

cancel	back to summary
public void cancel() Cancel the statement if it is still processing.

back to summary

public void close()

Redeclares java.lang.AutoCloseable.close.

Close the statement.

Annotations

@Override

executeBatchUpdate back to summary

public BatchResult executeBatchUpdate(ArrayList<Value[]> batchParameters, Object generatedKeysRequest)

Executes the statement with multiple sets of parameters.

Parameters

batchParameters:ArrayList<Value[]>: batch parameters
generatedKeysRequest:Object: null or false if generated keys are not needed, true if generated keys should be configured automatically, int[] to specify column indices to return generated keys from, or String[] to specify column names to return generated keys from

Returns:BatchResult

result of batch execution

executeQuery

back to summary

public ResultInterface executeQuery(long maxRows, boolean scrollable)

Execute the query.

Parameters

maxRows:long: the maximum number of rows returned
scrollable:boolean: if the result set must be scrollable

Returns:ResultInterface

the result

executeUpdate back to summary

public ResultWithGeneratedKeys executeUpdate(Object generatedKeysRequest)

Execute the statement

Parameters

generatedKeysRequest:Object: null or false if generated keys are not needed, true if generated keys should be configured automatically, int[] to specify column indices to return generated keys from, or String[] to specify column names to return generated keys from

Returns:ResultWithGeneratedKeys