Top Description Fields Constructors Methods
org.apache.derby.iapi.sql.dictionary

public Class SPSDescriptor

extends UniqueSQLObjectDescriptor
implements Dependent, Provider
Class Inheritance
All Implemented Interfaces
org.apache.derby.iapi.sql.depend.Provider, org.apache.derby.catalog.Dependable, org.apache.derby.iapi.sql.depend.Dependent
Imports
java.sql.Timestamp, java.util.ArrayList, .List, org.apache.derby.catalog.Dependable, .DependableFinder, .UUID, org.apache.derby.shared.common.error.StandardException, org.apache.derby.shared.common.reference.SQLState, org.apache.derby.iapi.services.context.ContextManager, .ContextService, org.apache.derby.shared.common.util.ArrayUtil, org.apache.derby.iapi.services.io.StoredFormatIds, org.apache.derby.iapi.services.monitor.Monitor, org.apache.derby.shared.common.sanity.SanityManager, org.apache.derby.iapi.services.uuid.UUIDFactory, org.apache.derby.iapi.sql.Statement, .StorablePreparedStatement, org.apache.derby.iapi.sql.conn.LanguageConnectionContext, .LanguageConnectionFactory, org.apache.derby.iapi.sql.depend.DependencyManager, .Dependent, .Provider, org.apache.derby.iapi.sql.execute.ExecPreparedStatement, org.apache.derby.iapi.store.access.TransactionController, org.apache.derby.iapi.types.DataTypeDescriptor, .DataTypeUtilities, .DataValueDescriptor
A SPSDescriptor describes a Stored Prepared Statement. It correlates to a row in SYS.SYSSTATEMENTS

Synchronization

Stored prepared statements may be cached. Thus they may be shared by multiple threads. It is very hard for two threads to try to muck with an sps simultaeously because all ddl (including sps recompilation) clears out the sps cache and invalidates whatever statement held a cached sps. But it is possible for two statements to do a prepare execute statment at the exact same time, so both try to do an sps.prepare() at the same time during code generation, so we synchronize most everything except getters on immutable objects just to be on the safe side.

Field Summary

Modifier and TypeField and Description
private Timestamp
compileTime

private final UUID
compSchemaId

private final boolean
initiallyCompilable

private static final int
INVALIDATE

private boolean
lookedUpParams

private final String
name

private Object[]
paramDefaults

Old code - never used.

private DataTypeDescriptor[]
params

private ExecPreparedStatement
preparedStatement

private static final int
RECOMPILE

interface to this class is:

  1. public void prepare() throws StandardException;
  2. public void prepareAndRelease(LanguageConnectionContext lcc) throws StandardException;
  3. public void prepareAndRelease(...);
  4. public String getQualifiedName();
  5. public char getType();
  6. public String getTypeAsString();
  7. public boolean isValid();
  8. public boolean initiallyCompilable();
  9. public java.sql.Timestamp getCompileTime();
  10. public void setCompileTime();
  11. public String getText();
  12. public String getUsingText();
  13. public void setUsingText(String usingText);
  14. public void setUUID(UUID uuid);
  15. public DataTypeDescriptor[] getParams() throws StandardException;
  16. public void setParams(DataTypeDescriptor[] params);
  17. Object[] getParameterDefaults() throws StandardException;
  18. void setParameterDefaults(Object[] values);
  19. public UUID getCompSchemaId();
  20. public ExecPreparedStatement getPreparedStatement() throws StandardException;
  21. public ExecPreparedStatement getPreparedStatement(boolean recompIfInvalid) throws StandardException;
  22. public void revalidate(LanguageConnectionContext lcc) throws StandardException;
private final SchemaDescriptor
sd

public static final char
SPS_TYPE_EXPLAIN

public static final char
SPS_TYPE_REGULAR

public static final char
SPS_TYPE_TRIGGER

Statement types.

private String
text

private final char
type

private final String
usingText

private final UUID
uuid

private UUIDFactory
uuidFactory

private boolean
valid

Constructor Summary

AccessConstructor and Description
public
SPSDescriptor(DataDictionary
The data dictionary that this descriptor lives in
dataDictionary, String
the SPS name
name, UUID
the UUID
uuid, UUID
the schema UUID
suuid, UUID
the schema UUID at compilation time
compSchemaUUID, char
type
type, boolean
is the sps valid
valid, String
the text for this statement
text, boolean
is the statement initially compilable?
initiallyCompilable)

Constructor for a SPS Descriptor

public
SPSDescriptor(DataDictionary
The data dictionary that this descriptor lives in
dataDictionary, String
the SPS name
name, UUID
the UUID
uuid, UUID
the schema UUID
suuid, UUID
the schema UUID at compilation time
compSchemaUUID, char
type
type, boolean
is the sps valid
valid, String
the text for this statement
text, String
the text for the USING clause supplied to CREATE or ALTER STATEMENT
usingText, Timestamp
the time this was compiled
compileTime, ExecPreparedStatement
the PreparedStatement
preparedStatement, boolean
is the statement initially compilable?
initiallyCompilable)

Constructor for a SPS Descriptor.

Method Summary

Modifier and TypeMethod and Description
private void
compileStatement(LanguageConnectionContext
connection
lcc, TableDescriptor
subject table (may be null)
triggerTable, TransactionController
transaction controller to use (may be null)
tc)

Compiles this SPS.

public final String

Returns:

String The provider's type.
getClassType()

Implements org.apache.derby.catalog.Dependable.getClassType.

Get the provider's type.

public final synchronized Timestamp

Returns:

the time this class was last compiled
getCompileTime()

The time this prepared statement was compiled

public final UUID

Returns:

the schema UUID
getCompSchemaId()

Get the compilation type schema id when this view was first bound.

private static ContextService
getContextService()

Must be private so that user code can't call this entry point.

public final DependableFinder
getDependableFinder()

Implements org.apache.derby.catalog.Dependable.getDependableFinder.

Return the stored form of this provider

public String
getDescriptorName()

Overrides org.apache.derby.iapi.sql.dictionary.TupleDescriptor.getDescriptorName.

public String
getDescriptorType()

Overrides org.apache.derby.iapi.sql.dictionary.TupleDescriptor.getDescriptorType.

Each descriptor must identify itself with its type; i.e index, check constraint whatever.

public final String

Returns:

A String containing the name of the statement.
getName()

Implements abstract org.apache.derby.iapi.sql.dictionary.UniqueSQLObjectDescriptor.getName.

Gets the name of the sps.

public final UUID

Returns:

String The provider's UUID
getObjectID()

Implements org.apache.derby.catalog.Dependable.getObjectID.

Get the provider's UUID

public final String

Returns:

String The name of this provider.
getObjectName()

Implements org.apache.derby.catalog.Dependable.getObjectName.

Return the name of this Provider.

public final synchronized Object[]

Returns:

the default parameter values
getParameterDefaults()

Get the default parameter values for this statement.

public final synchronized DataTypeDescriptor[]

Returns:

the array of data type descriptors
getParams()

Get the array of date type descriptors for this statement.

public final ExecPreparedStatement

Returns:

the preparedStatement
getPreparedStatement()

Get the preparedStatement for this statement.

public final synchronized ExecPreparedStatement

Returns:

the preparedStatement
getPreparedStatement(boolean
if false, never recompile even if statement is invalid
recompIfInvalid)

Get the preparedStatement for this statement.

public final String

Returns:

A String containing the name of the statement.
getQualifiedName()

Gets the full, qualified name of the statement.

public final SchemaDescriptor

Returns:

SchemaDescriptor The SchemaDescriptor.
getSchemaDescriptor()

Implements abstract org.apache.derby.iapi.sql.dictionary.UniqueSQLObjectDescriptor.getSchemaDescriptor.

Gets the SchemaDescriptor for this SPS Descriptor.

public final synchronized String

Returns:

The text
getText()

Get the text used to create this statement.

public final char

Returns:

An identifier telling what type of statement we are.
getType()

Gets an identifier telling what type of table this is.

public final String

Returns:

type as a string
getTypeAsString()

Simple little helper function to convert your type to a string, which is easier to use.

public final String

Returns:

The text
getUsingText()

Get the text of the USING clause used on CREATE or ALTER statement.

public final UUID

Returns:

The UUID.
getUUID()

Implements abstract org.apache.derby.iapi.sql.dictionary.UniqueTupleDescriptor.getUUID.

Gets the UUID of the SPS.

public boolean

Returns:

false if statement was created with the NOCOMPILE flag true otherwise
initiallyCompilable()

Is the statement initially compilable?

public final synchronized boolean

Returns:

true if the dependent is currently valid
isValid()

Implements org.apache.derby.iapi.sql.depend.Dependent.isValid.

Check that all of the dependent's dependencies are valid.

public void
loadGeneratedClass()

Load the underlying generatd class.

public final synchronized void
makeInvalid(int
The action causing the invalidation
action, LanguageConnectionContext
The LanguageConnectionContext
lcc)

Implements org.apache.derby.iapi.sql.depend.Dependent.makeInvalid.

Mark the dependent as invalid (due to at least one of its dependencies being invalid).

public final synchronized void
prepareAndRelease(LanguageConnectionContext
the language connection context
lcc, TableDescriptor
the table descriptor to bind against. Had better be null if this isn't a trigger sps.
triggerTable, TransactionController
the transaction controller
tc)

FOR TRIGGERS ONLY

Generate the class for this SPS and immediately release it.

public final synchronized void
prepareAndRelease(LanguageConnectionContext
the language connection context
lcc, TableDescriptor
the table descriptor to bind against. Had better be null if this isn't a trigger sps.
triggerTable)

FOR TRIGGERS ONLY

Generate the class for this SPS and immediately release it.

public final synchronized void
prepareAndRelease(LanguageConnectionContext
the language connection context
lcc)

Generate the class for this SPS and immediately release it.

public final void
prepareToInvalidate(Provider
the provider
p, int
The action causing the invalidation
action, LanguageConnectionContext
The LanguageConnectionContext
lcc)

Implements org.apache.derby.iapi.sql.depend.Dependent.prepareToInvalidate.

Prepare to mark the dependent as invalid (due to at least one of its dependencies being invalid).

private UUID

Returns:

the UUID
recreateUUID(String
the string
idString)

Get the UUID for the given string

public final synchronized void
revalidate(LanguageConnectionContext lcc)

Invalidate and revalidate.

public final synchronized void
setCompileTime()

Set the compile time to now

public final synchronized void
setParameterDefaults(Object[]
the parameter defaults
values)

Set the parameter defaults for this statement.

public final synchronized void
setParams(DataTypeDescriptor[]
the parameter list
params)

Set the list of parameters for this statement

public final synchronized void
setText(String newText)

It is possible that when a trigger is invalidated, the generated trigger action sql associated with it needs to be regenerated.

public final String

Returns:

The contents as a String
toString()

Overrides java.lang.Object.toString.

Prints the contents of the TableDescriptor

private void
updateSYSSTATEMENTS(LanguageConnectionContext lcc, int mode, TransactionController tc)

public static boolean

Returns:

true/false
validType(char
the type
type)

Validate the type

Note

Only SPS_TYPE_REGULAR and SPS_TYPE_TRIGGER are currently valid.

Field Detail

compileTimeback to summary
private Timestamp compileTime
compSchemaIdback to summary
private final UUID compSchemaId
initiallyCompilableback to summary
private final boolean initiallyCompilable
INVALIDATEback to summary
private static final int INVALIDATE
lookedUpParamsback to summary
private boolean lookedUpParams
nameback to summary
private final String name
paramDefaultsback to summary
private Object[] paramDefaults

Old code - never used.

paramsback to summary
private DataTypeDescriptor[] params
preparedStatementback to summary
private ExecPreparedStatement preparedStatement
RECOMPILEback to summary
private static final int RECOMPILE

interface to this class is:

  1. public void prepare() throws StandardException;
  2. public void prepareAndRelease(LanguageConnectionContext lcc) throws StandardException;
  3. public void prepareAndRelease(...);
  4. public String getQualifiedName();
  5. public char getType();
  6. public String getTypeAsString();
  7. public boolean isValid();
  8. public boolean initiallyCompilable();
  9. public java.sql.Timestamp getCompileTime();
  10. public void setCompileTime();
  11. public String getText();
  12. public String getUsingText();
  13. public void setUsingText(String usingText);
  14. public void setUUID(UUID uuid);
  15. public DataTypeDescriptor[] getParams() throws StandardException;
  16. public void setParams(DataTypeDescriptor[] params);
  17. Object[] getParameterDefaults() throws StandardException;
  18. void setParameterDefaults(Object[] values);
  19. public UUID getCompSchemaId();
  20. public ExecPreparedStatement getPreparedStatement() throws StandardException;
  21. public ExecPreparedStatement getPreparedStatement(boolean recompIfInvalid) throws StandardException;
  22. public void revalidate(LanguageConnectionContext lcc) throws StandardException;
sdback to summary
private final SchemaDescriptor sd
SPS_TYPE_EXPLAINback to summary
public static final char SPS_TYPE_EXPLAIN
SPS_TYPE_REGULARback to summary
public static final char SPS_TYPE_REGULAR
SPS_TYPE_TRIGGERback to summary
public static final char SPS_TYPE_TRIGGER

Statement types.

  • SPS_TYPE_TRIGGER - trigger
  • SPS_TYPE_EXPLAIN - explain (NOT IMPLEMENTED)
  • SPS_TYPE_REGULAR - catchall
textback to summary
private String text
typeback to summary
private final char type
usingTextback to summary
private final String usingText
uuidback to summary
private final UUID uuid
uuidFactoryback to summary
private UUIDFactory uuidFactory
validback to summary
private boolean valid

Constructor Detail

SPSDescriptorback to summary
public SPSDescriptor(DataDictionary dataDictionary, String name, UUID uuid, UUID suuid, UUID compSchemaUUID, char type, boolean valid, String text, boolean initiallyCompilable) throws StandardException

Constructor for a SPS Descriptor

Parameters
dataDictionary:DataDictionary

The data dictionary that this descriptor lives in

name:String

the SPS name

uuid:UUID

the UUID

suuid:UUID

the schema UUID

compSchemaUUID:UUID

the schema UUID at compilation time

type:char

type

valid:boolean

is the sps valid

text:String

the text for this statement

initiallyCompilable:boolean

is the statement initially compilable?

Exceptions
StandardException:
on error
SPSDescriptorback to summary
public SPSDescriptor(DataDictionary dataDictionary, String name, UUID uuid, UUID suuid, UUID compSchemaUUID, char type, boolean valid, String text, String usingText, Timestamp compileTime, ExecPreparedStatement preparedStatement, boolean initiallyCompilable) throws StandardException

Constructor for a SPS Descriptor. Used when constructing an SPS descriptor from a row in SYSSTATEMENTS.

Parameters
dataDictionary:DataDictionary

The data dictionary that this descriptor lives in

name:String

the SPS name

uuid:UUID

the UUID

suuid:UUID

the schema UUID

compSchemaUUID:UUID

the schema UUID at compilation time

type:char

type

valid:boolean

is the sps valid

text:String

the text for this statement

usingText:String

the text for the USING clause supplied to CREATE or ALTER STATEMENT

compileTime:Timestamp

the time this was compiled

preparedStatement:ExecPreparedStatement

the PreparedStatement

initiallyCompilable:boolean

is the statement initially compilable?

Exceptions
StandardException:
on error

Method Detail

compileStatementback to summary
private void compileStatement(LanguageConnectionContext lcc, TableDescriptor triggerTable, TransactionController tc) throws StandardException

Compiles this SPS.

Note

This SPS may still be marked as invalid after this method has completed, because an invalidation request may have been received while compiling.

Parameters
lcc:LanguageConnectionContext

connection

triggerTable:TableDescriptor

subject table (may be null)

tc:TransactionController

transaction controller to use (may be null)

Exceptions
StandardException:
if something fails
getClassTypeback to summary
public final String getClassType()

Implements org.apache.derby.catalog.Dependable.getClassType.

Get the provider's type.

Returns:String

String The provider's type.

getCompileTimeback to summary
public final synchronized Timestamp getCompileTime()

The time this prepared statement was compiled

Returns:Timestamp

the time this class was last compiled

getCompSchemaIdback to summary
public final UUID getCompSchemaId()

Get the compilation type schema id when this view was first bound.

Returns:UUID

the schema UUID

getContextServiceback to summary
private static ContextService getContextService()

Must be private so that user code can't call this entry point.

getDependableFinderback to summary
public final DependableFinder getDependableFinder()

Implements org.apache.derby.catalog.Dependable.getDependableFinder.

Return the stored form of this provider

Returns:DependableFinder

Doc from org.apache.derby.catalog.Dependable.getDependableFinder.

A Finder object that can be written to disk if this is a Persistent Dependable. Null if this is not a persistent dependable.

See Also
Dependable#getDependableFinder
getDescriptorNameback to summary
public String getDescriptorName()

Overrides org.apache.derby.iapi.sql.dictionary.TupleDescriptor.getDescriptorName.

Annotations
@Override
See Also
TupleDescriptor#getDescriptorName
getDescriptorTypeback to summary
public String getDescriptorType()

Overrides org.apache.derby.iapi.sql.dictionary.TupleDescriptor.getDescriptorType.

Doc from org.apache.derby.iapi.sql.dictionary.TupleDescriptor.getDescriptorType.

Each descriptor must identify itself with its type; i.e index, check constraint whatever.

Annotations
@Override
See Also
TupleDescriptor#getDescriptorType
getNameback to summary
public final String getName()

Implements abstract org.apache.derby.iapi.sql.dictionary.UniqueSQLObjectDescriptor.getName.

Gets the name of the sps.

Returns:String

A String containing the name of the statement.

getObjectIDback to summary
public final UUID getObjectID()

Implements org.apache.derby.catalog.Dependable.getObjectID.

Get the provider's UUID

Returns:UUID

String The provider's UUID

getObjectNameback to summary
public final String getObjectName()

Implements org.apache.derby.catalog.Dependable.getObjectName.

Return the name of this Provider. (Useful for errors.)

Returns:String

String The name of this provider.

getParameterDefaultsback to summary
public final synchronized Object[] getParameterDefaults() throws StandardException

Get the default parameter values for this statement. Default parameter values are supplied by a USING clause on either a CREATE or ALTER STATEMENT statement.

Returns:Object[]

the default parameter values

Exceptions
StandardException:
on error
getParamsback to summary
public final synchronized DataTypeDescriptor[] getParams() throws StandardException

Get the array of date type descriptors for this statement. Currently, we do a lookup if we don't already have the parameters saved. When SPSes are cached, the parameters should be set up when the sps is constructed.

Returns:DataTypeDescriptor[]

the array of data type descriptors

Exceptions
StandardException:
on error
getPreparedStatementback to summary
public final ExecPreparedStatement getPreparedStatement() throws StandardException

Get the preparedStatement for this statement. If stmt is invalid or hasn't been compiled yet, it will be recompiled.

Returns:ExecPreparedStatement

the preparedStatement

Exceptions
StandardException:
on error
getPreparedStatementback to summary
public final synchronized ExecPreparedStatement getPreparedStatement(boolean recompIfInvalid) throws StandardException

Get the preparedStatement for this statement. Expects the prepared statement to have already been added to SYS.SYSSTATEMENTS.

Side Effects: will update SYS.SYSSTATEMENTS with the new plan if it needs to be recompiled.

Parameters
recompIfInvalid:boolean

if false, never recompile even if statement is invalid

Returns:ExecPreparedStatement

the preparedStatement

Exceptions
StandardException:
on error
getQualifiedNameback to summary
public final String getQualifiedName()

Gets the full, qualified name of the statement.

Returns:String

A String containing the name of the statement.

getSchemaDescriptorback to summary
public final SchemaDescriptor getSchemaDescriptor()

Implements abstract org.apache.derby.iapi.sql.dictionary.UniqueSQLObjectDescriptor.getSchemaDescriptor.

Gets the SchemaDescriptor for this SPS Descriptor.

Returns:SchemaDescriptor

SchemaDescriptor The SchemaDescriptor.

getTextback to summary
public final synchronized String getText()

Get the text used to create this statement. Returns original text in a cleartext string.

Returns:String

The text

getTypeback to summary
public final char getType()

Gets an identifier telling what type of table this is. Types match final ints in this interface. Currently returns SPS_TYPE_REGULAR or SPS_TYPE_TRIGGER.

Returns:char

An identifier telling what type of statement we are.

getTypeAsStringback to summary
public final String getTypeAsString()

Simple little helper function to convert your type to a string, which is easier to use.

Returns:String

type as a string

getUsingTextback to summary
public final String getUsingText()

Get the text of the USING clause used on CREATE or ALTER statement.

Returns:String

The text

getUUIDback to summary
public final UUID getUUID()

Implements abstract org.apache.derby.iapi.sql.dictionary.UniqueTupleDescriptor.getUUID.

Gets the UUID of the SPS.

Returns:UUID

The UUID.

initiallyCompilableback to summary
public boolean initiallyCompilable()

Is the statement initially compilable?

Returns:boolean

false if statement was created with the NOCOMPILE flag true otherwise

isValidback to summary
public final synchronized boolean isValid()

Implements org.apache.derby.iapi.sql.depend.Dependent.isValid.

Check that all of the dependent's dependencies are valid.

Returns:boolean

true if the dependent is currently valid

loadGeneratedClassback to summary
public void loadGeneratedClass() throws StandardException

Load the underlying generatd class. This is not expected to be used outside of the datadictionary package. It is used for optimizing class loading for sps cacheing.

Exceptions
StandardException:
on error
makeInvalidback to summary
public final synchronized void makeInvalid(int action, LanguageConnectionContext lcc) throws StandardException

Implements org.apache.derby.iapi.sql.depend.Dependent.makeInvalid.

Mark the dependent as invalid (due to at least one of its dependencies being invalid).

Parameters
action:int

The action causing the invalidation

lcc:LanguageConnectionContext

Doc from org.apache.derby.iapi.sql.depend.Dependent.makeInvalid.

The LanguageConnectionContext

Exceptions
StandardException:
thrown if unable to make it invalid
prepareAndReleaseback to summary
public final synchronized void prepareAndRelease(LanguageConnectionContext lcc, TableDescriptor triggerTable, TransactionController tc) throws StandardException

FOR TRIGGERS ONLY

Generate the class for this SPS and immediately release it. This is useful for cases where we don't want to immediately execute the statement corresponding to this sps (e.g. CREATE STATEMENT).

SIDE EFFECTS: will update and SYSDEPENDS with the prepared statement dependency info.

Parameters
lcc:LanguageConnectionContext

the language connection context

triggerTable:TableDescriptor

the table descriptor to bind against. Had better be null if this isn't a trigger sps.

tc:TransactionController

the transaction controller

Exceptions
StandardException:
on error
prepareAndReleaseback to summary
public final synchronized void prepareAndRelease(LanguageConnectionContext lcc, TableDescriptor triggerTable) throws StandardException

FOR TRIGGERS ONLY

Generate the class for this SPS and immediately release it. This is useful for cases where we don't want to immediately execute the statement corresponding to this sps (e.g. CREATE STATEMENT).

SIDE EFFECTS: will update and SYSDEPENDS with the prepared statement dependency info.

Parameters
lcc:LanguageConnectionContext

the language connection context

triggerTable:TableDescriptor

the table descriptor to bind against. Had better be null if this isn't a trigger sps.

Exceptions
StandardException:
on error
prepareAndReleaseback to summary
public final synchronized void prepareAndRelease(LanguageConnectionContext lcc) throws StandardException

Generate the class for this SPS and immediately release it. This is useful for cases where we don't want to immediately execute the statement corresponding to this sps (e.g. CREATE STATEMENT).

SIDE EFFECTS: will update and SYSDEPENDS with the prepared statement dependency info.

Parameters
lcc:LanguageConnectionContext

the language connection context

Exceptions
StandardException:
on error
prepareToInvalidateback to summary
public final void prepareToInvalidate(Provider p, int action, LanguageConnectionContext lcc) throws StandardException

Implements org.apache.derby.iapi.sql.depend.Dependent.prepareToInvalidate.

Prepare to mark the dependent as invalid (due to at least one of its dependencies being invalid).

Parameters
p:Provider

the provider

action:int

The action causing the invalidation

lcc:LanguageConnectionContext

Doc from org.apache.derby.iapi.sql.depend.Dependent.prepareToInvalidate.

The LanguageConnectionContext

Exceptions
StandardException:
thrown if unable to make it invalid
recreateUUIDback to summary
private UUID recreateUUID(String idString)

Get the UUID for the given string

Parameters
idString:String

the string

Returns:UUID

the UUID

revalidateback to summary
public final synchronized void revalidate(LanguageConnectionContext lcc) throws StandardException

Invalidate and revalidate. The functional equivalent of calling makeInvalid() and makeValid(), except it is optimized.

Exceptions
StandardException:
on error
setCompileTimeback to summary
public final synchronized void setCompileTime()

Set the compile time to now

setParameterDefaultsback to summary
public final synchronized void setParameterDefaults(Object[] values)

Set the parameter defaults for this statement.

Parameters
values:Object[]

the parameter defaults

setParamsback to summary
public final synchronized void setParams(DataTypeDescriptor[] params)

Set the list of parameters for this statement

Parameters
params:DataTypeDescriptor[]

the parameter list

setTextback to summary
public final synchronized void setText(String newText)

It is possible that when a trigger is invalidated, the generated trigger action sql associated with it needs to be regenerated. One example of such a case would be when ALTER TABLE on the trigger table changes the length of a column. The need for this code was found as part of DERBY-4874 where the Alter table had changed the length of a varchar column from varchar(30) to varchar(64) but the generated trigger action plan continued to use varchar(30). To fix varchar(30) in in trigger action sql to varchar(64), we need to regenerate the trigger action sql which is saved as stored prepared statement. This new trigger action sql will then get updated into SYSSTATEMENTS table. DERBY-4874

toStringback to summary
public final String toString()

Overrides java.lang.Object.toString.

Prints the contents of the TableDescriptor

Returns:String

The contents as a String

Annotations
@Override
updateSYSSTATEMENTSback to summary
private void updateSYSSTATEMENTS(LanguageConnectionContext lcc, int mode, TransactionController tc) throws StandardException
validTypeback to summary
public static boolean validType(char type)

Validate the type

Note

Only SPS_TYPE_REGULAR and SPS_TYPE_TRIGGER are currently valid.

Parameters
type:char

the type

Returns:boolean

true/false