com.scalar.db.sql

Interface SqlStatementExecutable

All Known Subinterfaces:

SqlTransaction, SqlTransactionManager, SqlTwoPhaseCommitTransaction, SqlTwoPhaseCommitTransactionManager

public interface SqlStatementExecutable

An interface for executing SQL statements. Only DDLs and DMLs are supported. For the details of the grammar, see ScalarDB SQL Grammar.

Method Summary

Modifier and Type	Method and Description
default ResultSet	execute(Statement statement) Executes the specified statement.
default ResultSet	execute(Statement statement, java.util.List<Value> positionalValues) Executes the specified statement with the specified positional values.
ResultSet	execute(Statement statement, java.util.List<Value> positionalValues, java.lang.String defaultNamespaceName) Executes the specified statement with the specified positional values.
default ResultSet	execute(Statement statement, java.util.Map<java.lang.String,Value> namedValues) Executes the specified statement with the specified named values.
ResultSet	execute(Statement statement, java.util.Map<java.lang.String,Value> namedValues, java.lang.String defaultNamespaceName) Executes the specified statement with the specified named values.
default ResultSet	execute(Statement statement, java.lang.String defaultNamespaceName) Executes the specified statement.
default ResultSet	execute(java.lang.String sql) Executes the specified SQL statement.
default ResultSet	execute(java.lang.String sql, java.util.List<Value> positionalValues) Executes the specified SQL statement with the specified positional values.
ResultSet	execute(java.lang.String sql, java.util.List<Value> positionalValues, java.lang.String defaultNamespaceName) Executes the specified SQL statement with the specified positional values.
default ResultSet	execute(java.lang.String sql, java.util.Map<java.lang.String,Value> namedValues) Executes the specified SQL statement with the specified named values.
ResultSet	execute(java.lang.String sql, java.util.Map<java.lang.String,Value> namedValues, java.lang.String defaultNamespaceName) Executes the specified SQL statement with the specified named values.
default ResultSet	execute(java.lang.String sql, java.lang.String defaultNamespaceName) Executes the specified SQL statement.

Method Detail

execute

default ResultSet execute(java.lang.String sql)

Executes the specified SQL statement.

Parameters:

sql - an SQL statement to execute

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

default ResultSet execute(java.lang.String sql,
                          @Nullable
                          java.lang.String defaultNamespaceName)

Executes the specified SQL statement.

Parameters:

sql - an SQL statement to execute

defaultNamespaceName - the default namespace name used if a namespace is not specified in the SQL statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

default ResultSet execute(java.lang.String sql,
                          java.util.List<Value> positionalValues)

Executes the specified SQL statement with the specified positional values.

Parameters:

sql - an SQL statement to execute

positionalValues - parameter values for the positional bind markers in the SQL statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

ResultSet execute(java.lang.String sql,
                  @Nullable
                  java.util.List<Value> positionalValues,
                  @Nullable
                  java.lang.String defaultNamespaceName)

Executes the specified SQL statement with the specified positional values.

Parameters:

sql - an SQL statement to execute

positionalValues - parameter values for the positional bind markers in the SQL statement

defaultNamespaceName - the default namespace name used if a namespace is not specified in the SQL statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

default ResultSet execute(java.lang.String sql,
                          java.util.Map<java.lang.String,Value> namedValues)

Executes the specified SQL statement with the specified named values.

Parameters:

sql - an SQL statement to execute

namedValues - parameter values for the named bind markers in the SQL statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

ResultSet execute(java.lang.String sql,
                  @Nullable
                  java.util.Map<java.lang.String,Value> namedValues,
                  @Nullable
                  java.lang.String defaultNamespaceName)

Executes the specified SQL statement with the specified named values.

Parameters:

sql - an SQL statement to execute

namedValues - parameter values for the named bind markers in the SQL statement

defaultNamespaceName - the default namespace name used if a namespace is not specified in the SQL statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

default ResultSet execute(Statement statement)

Executes the specified statement.

Parameters:

statement - a statement to execute

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

default ResultSet execute(Statement statement,
                          @Nullable
                          java.lang.String defaultNamespaceName)

Executes the specified statement.

Parameters:

statement - a statement to execute

defaultNamespaceName - the default namespace name used if a namespace is not specified in the statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

default ResultSet execute(Statement statement,
                          java.util.List<Value> positionalValues)

Executes the specified statement with the specified positional values.

Parameters:

statement - a statement to execute

positionalValues - parameter values for the positional bind markers in the statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

ResultSet execute(Statement statement,
                  @Nullable
                  java.util.List<Value> positionalValues,
                  @Nullable
                  java.lang.String defaultNamespaceName)

Executes the specified statement with the specified positional values.

Parameters:

statement - a statement to execute

positionalValues - parameter values for the positional bind markers in the statement

defaultNamespaceName - the default namespace name used if a namespace is not specified in the statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

default ResultSet execute(Statement statement,
                          java.util.Map<java.lang.String,Value> namedValues)

Executes the specified statement with the specified named values.

Parameters:

statement - a statement to execute

namedValues - parameter values for the named bind markers in the statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient

execute

ResultSet execute(Statement statement,
                  @Nullable
                  java.util.Map<java.lang.String,Value> namedValues,
                  @Nullable
                  java.lang.String defaultNamespaceName)

Executes the specified statement with the specified named values.

Parameters:

statement - a statement to execute

namedValues - parameter values for the named bind markers in the statement

defaultNamespaceName - the default namespace name used if a namespace is not specified in the statement

Returns:

a ResultSet object that contains the data produced by the query

Throws:

TransactionRetryableException - if the transaction operation execution fails due to retryable faults (e.g., a transaction conflict). You can retry the transaction from the beginning.

SqlException - if the transaction operation execution fails due to transient or nontransient faults. You can try retrying the transaction from the beginning, but the transaction may still fail if the cause is nontranient