public interface SqlManager
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
DB_ADMIN |
static java.lang.String |
DB_BNP |
static java.lang.String |
DB_DATA |
static java.lang.String |
DB_SYS |
static java.lang.String |
DB_TESS |
static int |
DBV_BRAND_ODBC |
static int |
DBV_BRAND_ORACLE |
static int |
DBV_BRAND_SQL |
static int |
DBV_BRAND_SYBASE |
static int |
FETCH_Delete |
static int |
FETCH_EOF |
static int |
FETCH_Ok |
static int |
FETCH_Update |
Modifier and Type | Method and Description |
---|---|
void |
checkParentForBind(boolean check)
Tells Sqlmanager to look for bind variables in parent classes;
Use only when the class you pass to SqlManager via setBindClasses() or
setClass() functions is derived from other class and you use variables from both
classes in your sql statements ( bind variables should be public in this case)
|
void |
close()
After you finish using SlqManager call this function which will take care of cleaning all resourses
|
void |
computeStatistics(java.lang.String table)
Invoke this method to compute statistics on temporary Oracle table;
This method is a 'no op' for databases other then Oracle.
|
void |
createSqlServerTempTable(java.lang.String permTable,
boolean create)
ask framework to create/drop a sqlserver 'local temporary table' based on the structure of the our 'temp' table ( Z_ table )
Please discuss it with framework team first if you believe this method will benefit your app.
|
void |
deleteAppStatistics(java.lang.String appName)
Invoke this method to delete statistics on all temporary Oracle tables that start with 'Z_'+appName;
This method is a 'no op' for databases other then Oracle.
|
void |
deleteOrTruncatePartition(java.lang.String tableName,
java.util.HashMap<java.lang.String,java.io.Serializable> keyColumns)
Special method to optimize delete from large tables .
|
void |
deleteStatistics(java.lang.String table)
Invoke this method to delete statistics on temporary Oracle table;
This method is a 'no op' for databases other then Oracle.
|
void |
disableParallelDML()
Invoke this method to disable Oracle parallel DML feature;
This method also disables autocommit mode.
|
void |
disableParallelExecution()
Invoke this method to disable Oracle parallel DML and Query features;
This method also disables autocommit mode.
|
void |
disablePreferIndexMode()
Invoke this method to disable preferIndexMode;
|
void |
dropPartition(java.lang.String dynTableName,
java.lang.String partitionID)
Ask Alex before use ! Special function you need to use to drop 'logical table partition with data'
|
void |
enableParallelDML()
Invoke this method to allow Oracle parallel DML feature;
This method also puts connection into autocommit mode;
This method is a 'no op' for databases other then Oracle.
|
void |
enableParallelQuery()
Invoke this method to enable Oracle parallel Query;
This method is a 'no op' for databases other then Oracle.
|
void |
enablePreferIndexMode()
Invoke this method to change how Oracle optimizer generates plans by encouraging it to use index lookup ( This method is currently no-op for SqlServer - it will do nothing).
|
int |
fetchStatus()
Returns the results of last SqlFetch
|
java.lang.String |
getAppId()
Returns application Id that is associated with given SqlManager ,
can be null is SqlManager was created by framework classes
|
int |
getBackEnd()
returns database backend type
|
java.util.HashMap<java.lang.String,java.io.Serializable> |
getBindsTable()
If you use HashMap to store into variables you have to call this function after every SqlFetchNext()
to get fresh row from database
|
BulkInserter |
getBulkInserter()
returns BulkInserter that can be used to efficiently copy data from one table to another.
|
java.sql.ResultSetMetaData |
getMetaData(boolean bCommit)
Returns java.sql.ResultSetMetaData for the prepared select statement
|
java.sql.ResultSetMetaData |
getMetaData(java.lang.String select)
Returns java.sql.ResultSetMetaData for the diven select statement
|
java.io.Serializable |
getObject(java.lang.String sObjCode)
Return the object stored by the system (previously stored with storeObject).
|
java.lang.String |
getPartition(java.lang.String dynTableName,
java.lang.String partitionID)
Ask Alex before use ! Special function you need to use to get cached by lockPartition() data
|
java.lang.String |
getRealTableName(java.lang.String sTableName)
Returns real database table name
|
java.lang.Object |
getSetting(java.lang.String tables,
java.lang.String key)
Allows to cache commonly used data in cluster wide store.
|
boolean |
isParallelExecution()
Invoke this method to check where Oracle process executed from parallel queue Oracle
|
boolean |
isPreferIndexMode()
Invoke this method to check current preferIndexMode
|
boolean |
isTableEmpty(java.lang.String tableName,
java.lang.String where)
utility method to check where table has any data , it works very fast , use it when you need to check large tables
|
void |
loadState(java.lang.Object state)
Restores SqlMananger state using variable obtained using saveState() method
|
java.lang.String |
lockPartition(java.lang.String dynTableName,
java.lang.String partitionID)
Ask Alex before use ! Special function you can use to populate 'logical table partition with data'
|
void |
partitionDynamicTables(java.lang.String bucketTableName,
java.lang.String partitionColumn,
java.lang.String bucketTableWhere) |
void |
putSetting(java.lang.String tables,
java.lang.String key,
java.lang.Object value)
Allows to cache commonly used data in cluster wide store.
|
void |
refreshSettings(java.lang.String tables)
Call this method to let framework know that table that was cached by putSetting() has been modified by application code
|
java.lang.Object |
saveState()
Stores SqlMananger state in the variable
|
void |
setBindClasses(java.lang.Object objClass)
Call init() function first , then
initialize objClass , which stores information about bind variables
|
void |
setBindClasses(java.lang.Object objClass,
java.lang.Object objIntoClass)
Call init() function first , then
initialize objClass and objIntoClass , which stores information about bind variables
|
void |
setBindClasses(java.lang.Object objClass,
java.lang.Object objIntoClass,
java.util.HashMap<java.lang.String,java.io.Serializable> binds)
Initialize all objects which stores information about bind variables
|
void |
setBindsTable(java.util.HashMap<java.lang.String,java.io.Serializable> binds)
HasgMap where key - name of the bind (or into) variable which can be used in any Sql statement ,
value - values of bind variable .
|
void |
setClass(java.lang.Object objClass)
Sets object whose class variables can be used as bind and into variables in any Sql statement
|
void |
setIntoClass(java.lang.Object objClass)
Sets object whose class variables can be used as into variables in select statement
|
void |
SqlCommit()
Commits transaction
|
int |
SqlCountRows(java.lang.String sSelect)
Counts rows in the select statement
|
void |
SqlExecSP(boolean bCommit)
Use this method to execute previously prepared stored procedure
|
void |
SqlExecSP(java.lang.String sExpectedVersion,
boolean bCheckOnly,
java.lang.String sSPName,
java.lang.String sParams)
To invoke stored procedure use this function
|
void |
SqlExecSP(java.lang.String sExpectedVersion,
boolean bCheckOnly,
java.lang.String sSPName,
java.lang.String sParams,
boolean bCommit)
calls above function then commits if necessary .
|
void |
SqlExecSP(java.lang.String sSPName,
java.lang.String sParams,
boolean bCommit)
To invoke generic stored procedure that doesnt follow Costpoint conventions use this function
|
void |
SqlExecSPParallel(java.lang.String sExpectedVersion,
boolean bCheckOnly,
java.lang.String sSPName,
java.lang.String sParams)
this function executes stored procedure in parallel query and dml modes if it's turn on on the system level;
it executes in autocommit mode
|
void |
SqlExecSPParallel(java.lang.String sExpectedVersion,
boolean bCheckOnly,
java.lang.String sSPName,
java.lang.String sParams,
boolean forceDML)
This function adds forceDML that allows you to turn parallel DML off
|
void |
SqlExecSPParallel(java.lang.String sExpectedVersion,
boolean bCheckOnly,
java.lang.String sSPName,
java.lang.String sParams,
java.lang.String driverTable,
java.lang.String partitionColumn)
call this method to execute stored procedure in multiple concurrent threads .
|
boolean |
SqlExecTESSSP(java.lang.String sSPName,
java.lang.String sParams,
java.lang.String sOutputIntoParms,
boolean bCommit)
to invoke TESS stored procedure that returns data back in the jdbc result set
|
void |
SqlExecute()
Executes Sql statement (like Centura's SqlExecute)
|
void |
SqlExecute(boolean bCommit)
Executes Sql statement them commits statement if bCommit is true
|
void |
SqlExecuteBlock()
Executes previously prepared by SqlPrepareBlock Sql Block
|
boolean |
SqlExecuteQuery(java.lang.String sSelect)
Parepares and executes select statement then fetches first row from result set .
|
boolean |
SqlFetchNext()
Fetches data from database into objects you provided to BasicSqlManager in
setBindClasses(Object objClass,Object objIntoClass,HashMap binds).
|
boolean |
SqlFetchNext(java.lang.Object objIntoClass)
Sets objIntoClass object before fetching data then
does the same as SqlFetchNext() function
|
long |
SqlGenerateLongSequenceNo(java.lang.String fp_sDbTable,
java.lang.String fp_sDbColumn,
long total)
Updates LAST_KEY in SEQ_GENERATOR table
|
int |
SqlGenerateSequenceNo(java.lang.String fp_sDbTable,
java.lang.String fp_sDbColumn,
int total)
Deprecated.
Use SqlGenerateLongSequenceNo() method instead.
|
int |
SqlGetModifiedRows()
returns number of modified rows by previous sql statement
|
java.util.Calendar |
SqlGetServerDateTime()
returns current server date, doesn't commit transaction
|
java.util.Calendar |
SqlGetServerDateTime(boolean bCommit)
Deprecated.
Use SqlGetServerDateTime() method instead.
|
boolean |
SqlIsTablePartitioned(java.lang.String tableName)
To check whether Oracle table is partitioned.
|
boolean |
SqlIsTablePartitionedByColumns(java.lang.String tableName,
java.lang.String columns)
To check whether Oracle table is partitioned by specific columns.
|
boolean |
SqlModifyRSRow(java.lang.String sUpdateOrDelete,
ResultSetInterface rsI)
Prepares and executes sql update or delete statement that updates/deletes one row
in the underlying table ; sql statement's where condition should try to modify
row with ROWVERSION equal to the previously selected one.
|
boolean |
SqlModifyRSRowExecute(ResultSetInterface rsI)
Executes previously prepared sql or delete statement ;
for details refer to the SqlModifyRSRow function
|
void |
SqlModifyRSRowPrepare(java.lang.String sUpdateOrDelete)
Prepares sql or delete statement ; for details refer to the SqlModifyRSRow function
|
void |
SqlPrepare(java.lang.String sSelect)
Parepares any Sql statement (like Centura's SqlPrepare)
|
void |
SqlPrepareAndExecute(java.lang.String sSelect)
Parepares and executes any Sql statement (like Centura's SqlPrepareAndExecute )
Use SqlFetchNext() if you want to get data from select command
|
void |
SqlPrepareAndExecute(java.lang.String sSelect,
boolean bCommit)
Parepares and executes any Sql statement (like Centura's SqlPrepareAndExecute )
Commmits statement if bCommit is true
|
void |
SqlPrepareAndExecute(java.lang.String sSelect,
boolean bCommit,
int timeout,
int fetchSize)
Advanced version of SqlPrepareAndExecute
|
void |
SqlPrepareAndExecuteBlock(java.lang.String sqlBlock)
Parepares and executes any Sql block statement
You can use only bind ( not into) variables in the sql blocks .
|
void |
SqlPrepareBlock(java.lang.String sSql)
Parepares Sql Block statement
You can use only bind ( not into) variables in the sql blocks .
|
void |
SqlPrepareSP(java.lang.String sExpectedVersion,
boolean bCheckOnly,
java.lang.String sSPName,
java.lang.String sParams)
To prepare stored procedure that you intend to execute multiple times inside the loop.
|
boolean |
SqlQueryFetchAll(java.lang.String sSelect)
similar to SqlExecuteQuery but fetches all rows instead of one.
|
void |
SqlRollback()
Rollback's transaction
|
void |
SqlTruncate(java.lang.String table)
Truncates table
|
void |
storeObject(java.lang.String sObjCode,
java.io.Serializable obj)
Allows to store objects for a specific application for information
sharing between method calls.
|
void |
TDDL_All_Table(java.lang.String sApplName,
boolean create)
creates all dynamic tables for the application
|
void |
TDDL_All_View(java.lang.String sApplName,
boolean create)
creates all dynamic views for the application
|
void |
TDDL_Index(java.lang.String sTableName,
java.lang.String sIndexName,
boolean create)
Recreates index on dynamic table
|
void |
TDDL_Some_Table(java.lang.String sApplName,
java.lang.String sTableNames,
boolean create)
Recreates given dynamic tables for the application
|
void |
TDDL_Table(java.lang.String sTableName,
boolean create)
Recreates dynamic table
|
void |
TDDL_View(java.lang.String sViewName,
boolean create)
Recreates dynamic view
|
boolean |
truncatePartition(java.lang.String tableName,
java.util.HashMap<java.lang.String,java.io.Serializable> keyColumns) |
void |
unlockPartition()
Ask Alex before use ! Special function you need to use after you populate 'logical table partition with data'
You have to call this method before you ( or framework ) close sql manager you used to call lockPartition() method .
|
void |
useSqlServerTempTable(boolean create)
ask framework to create a dynamic sqlserver table as 'local temporary table' instead of usual permanent ( D_ table) .
|
static final java.lang.String DB_ADMIN
static final java.lang.String DB_DATA
static final java.lang.String DB_SYS
static final java.lang.String DB_BNP
static final java.lang.String DB_TESS
static final int DBV_BRAND_ORACLE
static final int DBV_BRAND_ODBC
static final int DBV_BRAND_SYBASE
static final int DBV_BRAND_SQL
static final int FETCH_Ok
static final int FETCH_EOF
static final int FETCH_Delete
static final int FETCH_Update
int getBackEnd()
void setBindClasses(java.lang.Object objClass, java.lang.Object objIntoClass, java.util.HashMap<java.lang.String,java.io.Serializable> binds) throws java.sql.SQLException
objClass
- object whose class variables can be used as bind and into variables in any Sql statementobjIntoClass
- object whose class variables can be used as into variables in select statementbinds
- HasgMap where key - name of the bind (or into) variable which can be used in any Sql statement ,
value - values of bind variable . Developer is responsible of populating this HashMap .
After every fetch statement BasicSqlManager updates HashMap into variables with new values form database ,
to read these new values developer should call getBindsTable() function.java.sql.SQLException
void setBindClasses(java.lang.Object objClass, java.lang.Object objIntoClass) throws java.sql.SQLException
objClass
- see setBindClasses(Object objClass,Object objIntoClass,HashMap bindsTable)objIntoClass
- see setBindClasses(Object objClass,Object objIntoClass,HashMap bindsTable)java.sql.SQLException
void setBindClasses(java.lang.Object objClass) throws java.sql.SQLException
objClass
- see setBindClasses(Object objClass,Object objIntoClass,HashMap bindsTable)java.sql.SQLException
void close()
void setClass(java.lang.Object objClass)
objClass
- objectvoid SqlCommit() throws java.sql.SQLException
java.sql.SQLException
void SqlRollback() throws java.sql.SQLException
java.sql.SQLException
void setIntoClass(java.lang.Object objClass)
objClass
- objectvoid setBindsTable(java.util.HashMap<java.lang.String,java.io.Serializable> binds)
binds
- HashMapjava.util.HashMap<java.lang.String,java.io.Serializable> getBindsTable()
void SqlPrepare(java.lang.String sSelect) throws java.sql.SQLException
sSelect
- Sql statementjava.sql.SQLException
void SqlExecute() throws java.sql.SQLException
java.sql.SQLException
void SqlExecute(boolean bCommit) throws java.sql.SQLException
bCommit
- commit flagjava.sql.SQLException
java.sql.ResultSetMetaData getMetaData(boolean bCommit) throws java.sql.SQLException
bCommit
- getMetaDatajava.sql.SQLException
java.sql.ResultSetMetaData getMetaData(java.lang.String select) throws java.sql.SQLException
select
- select statementjava.sql.SQLException
void SqlPrepareAndExecute(java.lang.String sSelect) throws java.sql.SQLException
sSelect
- Sql statementjava.sql.SQLException
void SqlPrepareAndExecute(java.lang.String sSelect, boolean bCommit) throws java.sql.SQLException
sSelect
- Sql statementbCommit
- commit flagjava.sql.SQLException
void SqlPrepareAndExecute(java.lang.String sSelect, boolean bCommit, int timeout, int fetchSize) throws java.sql.SQLException
sSelect
- bCommit
- timeout
- can be -1 (never , default behavior) or number of seconds before DB
should throw timeout exceptionfetchSize
- can be -1 (default behavior, usually 10 rows) - number of rows jdbc driver
should fetch from database in one round trip , value cannot be more than 10000.
Large fetchSize value can improve performance if you intend to fetch large number of rowsjava.sql.SQLException
boolean SqlExecuteQuery(java.lang.String sSelect) throws java.sql.SQLException
sSelect
- select statementjava.sql.SQLException
int SqlCountRows(java.lang.String sSelect) throws java.sql.SQLException
sSelect
- select statementjava.sql.SQLException
boolean SqlFetchNext() throws java.sql.SQLException
java.sql.SQLException
boolean SqlFetchNext(java.lang.Object objIntoClass) throws java.sql.SQLException
objIntoClass
- java.sql.SQLException
void SqlExecSP(java.lang.String sExpectedVersion, boolean bCheckOnly, java.lang.String sSPName, java.lang.String sParams) throws java.sql.SQLException
sExpectedVersion
- standard parameterbCheckOnly
- standard parametersSPName
- stored procedure namesParams
- Parameters devided by comma , you can pass bind variables as parameters .
BasicSqlManager looks for bind variables only in objClass now (not in HashMap).
for in-out or out parameters put OUT after parameter like :
sParams=" 1,:param1 , :param2 OUT "java.sql.SQLException
java.lang.IllegalArgumentException
void SqlPrepareSP(java.lang.String sExpectedVersion, boolean bCheckOnly, java.lang.String sSPName, java.lang.String sParams) throws java.sql.SQLException
sExpectedVersion
- standard parameterbCheckOnly
- standard parametersSPName
- stored procedure namesParams
- Parameters devided by comma , you can pass bind variables as parameters .
BasicSqlManager looks for bind variables only in objClass now (not in HashMap).
for in-out or out parameters put OUT after parameter like :
sParams=" 1,:param1 , :param2 OUT "java.sql.SQLException
java.lang.IllegalArgumentException
void SqlExecSP(boolean bCommit) throws java.sql.SQLException
bCommit
- java.sql.SQLException
void SqlExecSP(java.lang.String sExpectedVersion, boolean bCheckOnly, java.lang.String sSPName, java.lang.String sParams, boolean bCommit) throws java.sql.SQLException
sExpectedVersion
- bCheckOnly
- sSPName
- sParams
- - list of variables or bind variables devided by comma , for receive params put postfix OUT , like: varname OUTbCommit
- commit flagjava.sql.SQLException
void SqlExecSPParallel(java.lang.String sExpectedVersion, boolean bCheckOnly, java.lang.String sSPName, java.lang.String sParams, java.lang.String driverTable, java.lang.String partitionColumn) throws java.sql.SQLException
sExpectedVersion
- bCheckOnly
- sSPName
- sParams
- - list of variables or bind variables devided by comma , for receive params put postfix OUT , like: varname OUT ,
params should be the same as for regular SqlExecSP plus last two params have to be two bind variables that will be used to store start/end range ;
these params should be set to the overall start/end range , framework will break it into smaller rangesdriverTable
- - table that will be used to devide overall table into multiple ranges that will be executed concurrentlypartitionColumn
- - column in driverTable that will be used to break it into several rangesjava.sql.SQLException
void SqlExecSP(java.lang.String sSPName, java.lang.String sParams, boolean bCommit) throws java.sql.SQLException
sSPName
- stored procedure namesParams
- Parameters devided by comma , you can pass bind variables as parameters .
BasicSqlManager looks for bind variables only in objClass now (not in HashMap).
for in-out or out parameters put OUT after parameter like :
sParams=" 1,:param1 , :param2 OUT "bCommit
- commit flagjava.sql.SQLException
void SqlExecSPParallel(java.lang.String sExpectedVersion, boolean bCheckOnly, java.lang.String sSPName, java.lang.String sParams) throws java.sql.SQLException
sExpectedVersion
- bCheckOnly
- sSPName
- sParams
- - list of variables or bind variables devided by comma , for receive params put postfix OUT , like: varname OUTjava.sql.SQLException
void SqlExecSPParallel(java.lang.String sExpectedVersion, boolean bCheckOnly, java.lang.String sSPName, java.lang.String sParams, boolean forceDML) throws java.sql.SQLException
sExpectedVersion
- bCheckOnly
- sSPName
- sParams
- - list of variables or bind variables devided by comma , for receive params put postfix OUT , like: varname OUTforceDML
- booleanjava.sql.SQLException
boolean SqlExecTESSSP(java.lang.String sSPName, java.lang.String sParams, java.lang.String sOutputIntoParms, boolean bCommit) throws java.sql.SQLException
sSPName
- sParams
- input and put put params separated by comma ; output params have to have OUTPUT keyword in frontsOutputIntoParms
- to read output data from jdbc result set object pass a list of into variable names separated by commabCommit
- java.sql.SQLException
int SqlGetModifiedRows() throws java.sql.SQLException
java.sql.SQLException
void SqlTruncate(java.lang.String table) throws java.sql.SQLException
table
- table namejava.sql.SQLException
@Deprecated int SqlGenerateSequenceNo(java.lang.String fp_sDbTable, java.lang.String fp_sDbColumn, int total) throws java.sql.SQLException
fp_sDbTable
- table name without ownerfp_sDbColumn
- column name without table nametotal
- function will increment LAST_KEY by this numberjava.sql.SQLException
long SqlGenerateLongSequenceNo(java.lang.String fp_sDbTable, java.lang.String fp_sDbColumn, long total) throws java.sql.SQLException
fp_sDbTable
- table name without ownerfp_sDbColumn
- colun name without table nametotal
- function will increment LAST_KEY by this numberjava.sql.SQLException
@Deprecated java.util.Calendar SqlGetServerDateTime(boolean bCommit)
bCommit
- commit flagjava.util.Calendar SqlGetServerDateTime()
void TDDL_Table(java.lang.String sTableName, boolean create) throws java.sql.SQLException
sTableName
- table namecreate
- create table flagjava.sql.SQLException
void TDDL_View(java.lang.String sViewName, boolean create) throws java.sql.SQLException
sViewName
- view namecreate
- create view flagjava.sql.SQLException
void TDDL_Index(java.lang.String sTableName, java.lang.String sIndexName, boolean create) throws java.sql.SQLException
sTableName
- tables namesIndexName
- index namecreate
- create index flagjava.sql.SQLException
void TDDL_All_Table(java.lang.String sApplName, boolean create) throws java.sql.SQLException
sApplName
- application namecreate
- cerate tables flagjava.sql.SQLException
void TDDL_All_View(java.lang.String sApplName, boolean create) throws java.sql.SQLException
sApplName
- application namecreate
- cerate views flagjava.sql.SQLException
void TDDL_Some_Table(java.lang.String sApplName, java.lang.String sTableNames, boolean create) throws java.sql.SQLException
sApplName
- application namesTableNames
- comma separated list of the tables to recreatecreate
- create flagjava.sql.SQLException
java.lang.String getRealTableName(java.lang.String sTableName)
sTableName
- logical table nameint fetchStatus()
void SqlPrepareAndExecuteBlock(java.lang.String sqlBlock) throws java.sql.SQLException
sqlBlock
- Sql block statementjava.sql.SQLException
void SqlPrepareBlock(java.lang.String sSql) throws java.sql.SQLException
sSql
- Sql statementjava.sql.SQLException
void SqlExecuteBlock() throws java.sql.SQLException
java.sql.SQLException
java.lang.Object saveState()
void loadState(java.lang.Object state)
state
- SqlMananger statevoid checkParentForBind(boolean check)
check
- true-look for bind variables in parent classes also;false - default setting,
looks for bind variables only in one classboolean SqlModifyRSRow(java.lang.String sUpdateOrDelete, ResultSetInterface rsI) throws java.sql.SQLException
sUpdateOrDelete
- - update or delete sql statementrsI
- - ResultSetInterface to add error message if necessaryjava.sql.SQLException
void SqlModifyRSRowPrepare(java.lang.String sUpdateOrDelete) throws java.sql.SQLException
sUpdateOrDelete
- - update or delete sql statementjava.sql.SQLException
boolean SqlModifyRSRowExecute(ResultSetInterface rsI) throws java.sql.SQLException
rsI
- - ResultSetInterface to add error message if necessaryjava.sql.SQLException
void enableParallelDML() throws java.sql.SQLException
java.sql.SQLException
void disableParallelDML() throws java.sql.SQLException
java.sql.SQLException
void enableParallelQuery() throws java.sql.SQLException
java.sql.SQLException
void disableParallelExecution() throws java.sql.SQLException
java.sql.SQLException
boolean isParallelExecution() throws java.sql.SQLException
java.sql.SQLException
void computeStatistics(java.lang.String table) throws java.sql.SQLException
table
- Stringjava.sql.SQLException
void deleteStatistics(java.lang.String table) throws java.sql.SQLException
table
- Stringjava.sql.SQLException
void deleteAppStatistics(java.lang.String appName) throws java.sql.SQLException
appName
- Stringjava.sql.SQLException
BulkInserter getBulkInserter() throws java.sql.SQLException
java.sql.SQLException
boolean SqlQueryFetchAll(java.lang.String sSelect) throws java.sql.SQLException
sSelect
- java.sql.SQLException
boolean isTableEmpty(java.lang.String tableName, java.lang.String where) throws java.sql.SQLException
tableName
- where
- extra where condition you can pass ( e.g. PROJ_ID like '1%' ) to check whether particular subset of data is present in table ; pass null if you dont have extra conditinsjava.sql.SQLException
java.lang.String lockPartition(java.lang.String dynTableName, java.lang.String partitionID) throws java.sql.SQLException
dynTableName
- dynamic table name from S_DYNAMIC_DDL tablepartitionID
- logical partition idjava.sql.SQLException
void unlockPartition() throws java.sql.SQLException
java.sql.SQLException
void dropPartition(java.lang.String dynTableName, java.lang.String partitionID) throws java.sql.SQLException
dynTableName
- partitionID
- java.sql.SQLException
java.lang.String getPartition(java.lang.String dynTableName, java.lang.String partitionID) throws java.sql.SQLException
dynTableName
- dynamic table name from S_DYNAMIC_DDL tablepartitionID
- logical partition idjava.sql.SQLException
boolean SqlIsTablePartitioned(java.lang.String tableName) throws java.sql.SQLException
tableName
- java.sql.SQLException
boolean SqlIsTablePartitionedByColumns(java.lang.String tableName, java.lang.String columns) throws java.sql.SQLException
tableName
- columns
- comma separated list of columnsjava.sql.SQLException
void deleteOrTruncatePartition(java.lang.String tableName, java.util.HashMap<java.lang.String,java.io.Serializable> keyColumns) throws java.sql.SQLException
tableName
- table you want to delete data fromkeyColumns
- a map of key/value pairs that will be used to create delete where conditionjava.sql.SQLException
boolean truncatePartition(java.lang.String tableName, java.util.HashMap<java.lang.String,java.io.Serializable> keyColumns) throws java.sql.SQLException
java.sql.SQLException
void partitionDynamicTables(java.lang.String bucketTableName, java.lang.String partitionColumn, java.lang.String bucketTableWhere) throws java.sql.SQLException
java.sql.SQLException
java.lang.Object getSetting(java.lang.String tables, java.lang.String key)
tables
- list of comma separated tables you select data from . Framework needs to know list of tables to be able to clear caches when tables listed by this parameter are modifed as part of
standard result set save . If tables are getting modified in other places , eg via some proprecessor action , you need to call refreshSettings() mehtod to let framework know
that tables have been changed .key
- unique key that identifies your datavoid putSetting(java.lang.String tables, java.lang.String key, java.lang.Object value)
tables
- list of comma separated tables you select data from . Framework needs to know list of tables to be able to clear caches when tables listed by this parameter are modifed as part of
standard result set save . If tables are getting modified in other places , eg via some proprecessor action , you need to call refreshSettings() mehtod to let framework know
that tables have been changed .key
- unique key that identifies your datavalue
- object you need to storevoid refreshSettings(java.lang.String tables)
tables
- void storeObject(java.lang.String sObjCode, java.io.Serializable obj)
sObjCode
- ID of object you want to name so that you can retrieve later.obj
- Object that you want to store.getObject(java.lang.String)
java.io.Serializable getObject(java.lang.String sObjCode)
sObjCode
- String containing the ID of the object stored previously.storeObject(java.lang.String, java.io.Serializable)
java.lang.String getAppId()
void enablePreferIndexMode() throws java.sql.SQLException
java.sql.SQLException
void disablePreferIndexMode() throws java.sql.SQLException
java.sql.SQLException
boolean isPreferIndexMode() throws java.sql.SQLException
java.sql.SQLException
void createSqlServerTempTable(java.lang.String permTable, boolean create) throws java.sql.SQLException
permTable
- namecreate
- true to create table/false to drop itjava.sql.SQLException
void useSqlServerTempTable(boolean create) throws java.sql.SQLException
create
- java.sql.SQLException