public interface SqlService extends Service, Loggable
Modifier and Type | Field and Description |
---|---|
static int |
DB_LOG_TYPE
The DB_LOG_TYPE.
|
static int |
DELETE_TYPE
The DELETE_TYPE.
|
static int |
DML_TYPE
The generic DML_TYPE.
|
static int |
EXCEPTION_TYPE
The EXCEPTION_TYPE.
|
static int |
EXECUTE_SCRIPT_TYPE
The EXECUTE_SCRIPT_TYPE.
|
static int |
EXECUTE_TYPE
The EXECUTE_TYPE.
|
static int |
EXPLAIN_PLAN_TYPE
The EXPLAIN_PLAN_TYPE.
|
static int |
INSERT_TYPE
The INSERT_TYPE.
|
static int |
MERGE_TYPE
The MERGE_TYPE.
|
static int |
NOTHING_TYPE
The unknown sql type.
|
static int |
OUTPUT_PARAM_TYPE
The Constant OUTPUT_PARAM_TYPE.
|
static int |
SELECT_TYPE
The SELECT_TYPE.
|
static int |
UPDATE_TYPE
The UPDATE_TYPE.
|
Modifier and Type | Method and Description |
---|---|
void |
cancel(SessionConnectionProvider<Alias> provider)
Cancels currently executed sql.
|
void |
commitTransaction(SessionConnectionProvider<Alias> provider,
Alias params,
boolean closeOnCommit)
Commits current transaction.
|
SqlResult |
executeAutotrace(SqlRequest sqlRequest)
Executes autotrace
|
SqlResult |
executeExplainPlan(SqlRequest sqlRequest)
Executes explain plan if supported by driver passed in the sql request.
|
SqlResult |
executeExternal(SqlRequest sqlRequest)
Executes sql using external tool if supported by driver passed in the sql request.
|
SqlResult |
executeScript(SqlRequest sqlRequest)
Executes sql script, for example anonymous sql block if supported by driver passed in the sql request.
|
SqlResult |
executeSql(SqlRequest sqlRequest)
Executes sql.
|
Map<String,FieldDef> |
getMetaData(SqlRequest sqlRequest)
Gets the meta data for the database object (table, view or synonym).
|
void |
releaseConnection(SessionConnectionProvider<Alias> provider,
Alias params)
Releases connection.
|
void |
rollbackTransaction(SessionConnectionProvider<Alias> provider,
Alias params,
boolean closeOnRollback)
Rollbacks current transaction.
|
getLogNode, getPropertyName, isLogByDefault
static final int NOTHING_TYPE
static final int SELECT_TYPE
static final int DML_TYPE
static final int UPDATE_TYPE
static final int INSERT_TYPE
static final int DELETE_TYPE
static final int MERGE_TYPE
static final int EXECUTE_TYPE
static final int EXECUTE_SCRIPT_TYPE
static final int OUTPUT_PARAM_TYPE
static final int EXPLAIN_PLAN_TYPE
static final int EXCEPTION_TYPE
static final int DB_LOG_TYPE
void cancel(SessionConnectionProvider<Alias> provider)
provider
- the connection providervoid commitTransaction(SessionConnectionProvider<Alias> provider, Alias params, boolean closeOnCommit) throws Exception
provider
- the connection providerparams
- the aliscloseOnCommit
- the close on commit flag. If set the connection will be released on commitException
- the exceptionSqlResult executeAutotrace(SqlRequest sqlRequest) throws Exception
sqlRequest
- the sql requestException
- in case of any errorSqlResult executeExplainPlan(SqlRequest sqlRequest) throws Exception
sqlRequest
- the sql requestException
- in case of any errorSqlResult executeExternal(SqlRequest sqlRequest) throws Exception
sqlRequest
- the sql requestException
- in case of any errorSqlResult executeScript(SqlRequest sqlRequest) throws Exception
sqlRequest
- the sql requestException
- in case of any errorSqlResult executeSql(SqlRequest sqlRequest) throws Exception
sqlRequest
- the sql requestException
- in case of any errorMap<String,FieldDef> getMetaData(SqlRequest sqlRequest) throws Exception
sqlRequest
- the sql requestException
- the exceptionvoid releaseConnection(SessionConnectionProvider<Alias> provider, Alias params) throws Exception
provider
- the connection providerparams
- the aliasException
- in case of any errorvoid rollbackTransaction(SessionConnectionProvider<Alias> provider, Alias params, boolean closeOnRollback) throws Exception
provider
- the connection providerparams
- the aliascloseOnRollback
- the close on rollback flag. If set the connection will be closed on rollbackException
- in case of any errorCopyright © 2010-2020 Toolsverse. All Rights Reserved.