Interface SQLSessionContext
- All Known Implementing Classes:
SQLSessionContextImpl
Presently this set contains the following properties:
- current role
- current schema
SQL session context is implemented as follows: Statements at root connection level use the instance held by the the lcc, nested connections maintain instances of SQLSessionContext, held by the activation of the calling statement. This forms a logical stack as required by the standard. The statement context also holds a reference to the current SQLSessionContext.
When a dynamic result set references e.g. current role, the value retrieved will always be that of the current role when the statement is logically executed (inside procedure/function), not the current value when the result set is accessed outside the stored procedure/function. This works since the nested SQL session context is kept by the caller activation, so even though the statement context of the call has been popped, we can get at the final state of the nested SQL session context since the caller's activation is alive as long as dynamic result sets need it).
If more than one nested connection is used inside a shared procedure, they will share the same nested SQL session context. Since the same dynamic call context is involved, this seems correct.
- See Also:
-
Method Summary
Modifier and TypeMethodDescriptionGet a handle to the session's constraint modes.Get the SQL current user of this SQL connection contextGet the schema of this SQL connection contextGet state of DEFERRED ALL setting.getRole()
Get the SQL role of this SQL connection contextisDeferred
(UUID constraintId) ReturnBoolean.TRUE
if the constraint mode for this constraint/index has been set to deferred,Boolean.FALSE
if it has been set to immediate.void
Clear deferred information for this transaction.void
Initialize a inferior session context with the constraint mode map of the parent session context.void
Set the schema of this SQL connection contextvoid
setDeferred
(UUID constraintId, boolean deferred) Set the constraint mode for this constraint todeferred
.void
setDeferredAll
(Boolean deferred) Set the constraint mode for all deferrable constraints todeferred
.void
Set the SQL role of this SQL connection contextvoid
Set the SQL current user of this SQL connection context
-
Method Details
-
setRole
Set the SQL role of this SQL connection context -
getRole
String getRole()Get the SQL role of this SQL connection context -
setUser
Set the SQL current user of this SQL connection context -
getCurrentUser
String getCurrentUser()Get the SQL current user of this SQL connection context -
setDefaultSchema
Set the schema of this SQL connection context -
getDefaultSchema
SchemaDescriptor getDefaultSchema()Get the schema of this SQL connection context -
getConstraintModes
Get a handle to the session's constraint modes. The caller is responsible for any cloning needed.- Returns:
- constraint modes map
-
setConstraintModes
Initialize a inferior session context with the constraint mode map of the parent session context.- Parameters:
hm
- constraint mode map
-
setDeferred
Set the constraint mode for this constraint todeferred
. Ifdeferred
isfalse
, to immediate checking, iftrue
to deferred checking.- Parameters:
constraintId
- The constraint iddeferred
- The new constraint mode
-
isDeferred
ReturnBoolean.TRUE
if the constraint mode for this constraint/index has been set to deferred,Boolean.FALSE
if it has been set to immediate. Any ALL setting is considered also. If the constraint mode hasn't been set for this constraint, returnnull
. The constraint mode is the effectively the initial constraint mode in this case.- Parameters:
constraintId
- the constraint id- Returns:
Boolean.TRUE
if the constraint mode for this constraint/index has been set to deferred,Boolean.FALSE
if it has been set to immediate.
-
resetConstraintModes
void resetConstraintModes()Clear deferred information for this transaction. -
setDeferredAll
Set the constraint mode for all deferrable constraints todeferred
. Ifdeferred
isfalse
, set to immediate checking, iftrue
to deferred checking.null
is allowed: it means no ALL setting exists.- Parameters:
deferred
- the mode to set
-
getDeferredAll
Boolean getDeferredAll()Get state of DEFERRED ALL setting.- Returns:
True
is deferred all constraint mode has been set for this session context.False
is deferred immediate has been set for this session context.null
means no ALL setting has been made for this context
-