Interface ExecPreparedStatement
- All Superinterfaces:
Dependable, Dependent, PreparedStatement
- All Known Subinterfaces:
StorablePreparedStatement
- All Known Implementing Classes:
GenericPreparedStatement, GenericStorablePreparedStatement
Execution extends prepared statement to add methods it needs
for execution purposes (that should not be on the Database API).
-
Field Summary
Fields inherited from interface Dependable
ACTIVATION, ALIAS, COLUMNS_IN_TABLE, COLUMNS_PERMISSION, CONGLOMERATE, CONSTRAINT, DEFAULT, FILE, HEAP, INDEX, PERM, PREPARED_STATEMENT, ROLE_GRANT, ROUTINE_PERMISSION, SCHEMA, SEQUENCE, STORED_PREPARED_STATEMENT, TABLE, TABLE_PERMISSION, TRIGGER, VIEW -
Method Summary
Modifier and TypeMethodDescriptionvoidMark the statement as unusable, i.e. the system is finished with it and no one should be able to use it.Get the class generated for this prepared statement.getClone()Get a new prepared statement that is a shallow copy of the current one.Get the Execution constants.Get the saved cursor info.longgetInitialRowCount(int rsNum, long currentRowCount) Get the initial row count of the specified result set.getSavedObject(int objectNum) Get a saved object by number.Get all the saved objects.intGet the stale plan check interval.the target table of the cursorintthe update mode of the cursorbooleanCheck if this prepared statement has a cursor with columns that can be updated.intIncrement and return the execution count for this statement.booleanisUpdateColumn(String columnName) Check if the specified column name is one of the update columns.booleanDoes this statement need a savpointvoidset the statement textvoidIndicate that the statement represents an SPS actionvoidsetStalePlanCheckInterval(int interval) Set the stale plan check interval.voidsetValid()set this prepared statement to be validbooleanChecks whether this PreparedStatement is up to date and its activation class is identical to the supplied generated class.Methods inherited from interface Dependable
getClassType, getDependableFinder, getObjectID, getObjectName, isPersistentMethods inherited from interface Dependent
isValid, makeInvalid, prepareToInvalidateMethods inherited from interface PreparedStatement
execute, executeSubStatement, executeSubStatement, getActivation, getBeginCompileTimestamp, getBindTimeInMillis, getCompileTimeInMillis, getCompileTimeWarnings, getEndCompileTimestamp, getGenerateTimeInMillis, getOptimizeTimeInMillis, getParameterType, getParameterTypes, getParseTimeInMillis, getResultDescription, getSource, getSPSName, getVersionCounter, isAtomic, referencesSessionSchema, rePrepare, upToDate
-
Method Details
-
setSource
-
getConstantAction
ConstantAction getConstantAction()Get the Execution constants. This routine is called at Execution time.- Returns:
- ConstantAction The big structure enclosing the Execution constants.
-
getSavedObject
Get a saved object by number. This is called during execution to access objects created at compile time. These are meant to be read-only at run time.- Returns:
- Object A saved object. The caller has to know what it is requesting and cast it back to the expected type.
-
getSavedObjects
-
getCursorInfo
Object getCursorInfo()Get the saved cursor info. Used for stored prepared statements.- Returns:
- Object the cursor info
-
getActivationClass
Get the class generated for this prepared statement. Used to confirm compatability with auxilary structures.- Throws:
StandardException- on error obtaining class (probably when a stored prepared statement is loading)
-
upToDate
Checks whether this PreparedStatement is up to date and its activation class is identical to the supplied generated class. A call to
upToDate(gc)is supposed to perform the same work as the following code in one atomic operation:getActivationClass() == gc && upToDate()
- Parameters:
gc- a generated class that must be identical togetActivationClass()for this method to returntrue- Returns:
trueif this statement is up to date and its activation class is identical togc,falseotherwise- Throws:
StandardException- See Also:
-
finish
Mark the statement as unusable, i.e. the system is finished with it and no one should be able to use it. -
needsSavepoint
boolean needsSavepoint()Does this statement need a savpoint- Returns:
- true if needs a savepoint
-
getClone
Get a new prepared statement that is a shallow copy of the current one.- Returns:
- a new prepared statement
- Throws:
StandardException- on error
-
getUpdateMode
int getUpdateMode()the update mode of the cursor- Returns:
- The update mode of the cursor
-
getTargetTable
ExecCursorTableReference getTargetTable()the target table of the cursor- Returns:
- target table of the cursor
-
hasUpdateColumns
boolean hasUpdateColumns()Check if this prepared statement has a cursor with columns that can be updated. -
isUpdateColumn
Check if the specified column name is one of the update columns. -
setValid
void setValid()set this prepared statement to be valid -
setSPSAction
void setSPSAction()Indicate that the statement represents an SPS action -
getRequiredPermissionsList
List<StatementPermission> getRequiredPermissionsList()- Returns:
- the list of permissions required to execute this statement. May be null if the database does not use SQL standard authorization
-
incrementExecutionCount
int incrementExecutionCount()Increment and return the execution count for this statement.- Returns:
- execution count for this statement after the last compilation
-
getInitialRowCount
long getInitialRowCount(int rsNum, long currentRowCount) Get the initial row count of the specified result set. If the initial row count has not yet been set, initialize it with the value of the current row count.- Parameters:
rsNum- the result set to get the initial row count forcurrentRowCount- the current row count for the result set- Returns:
- the row count from the first execution of the result set
-
setStalePlanCheckInterval
void setStalePlanCheckInterval(int interval) Set the stale plan check interval.- Parameters:
interval- the stale plan check interval
-
getStalePlanCheckInterval
int getStalePlanCheckInterval()Get the stale plan check interval.- Returns:
- the stale plan check interval, or zero if it has not been initialized yet
-