org.hsqldb

Class TriggerDef

java.lang.Object

org.hsqldb.TriggerDef

All Implemented Interfaces:

java.lang.Runnable, SchemaObject

Direct Known Subclasses:

TriggerDefSQL

public class TriggerDef
extends java.lang.Object
implements java.lang.Runnable, SchemaObject

Represents an HSQLDB Trigger definition.

Provides services regarding HSQLDB Trigger execution and metadata.

Development of the trigger implementation sponsored by Logicscope Realisations Ltd

Since:

hsqldb 1.61

Nested Class Summary

Nested classes/interfaces inherited from interface org.hsqldb.SchemaObject

SchemaObject.ConstraintTypes, SchemaObject.Deferable, SchemaObject.Nullability, SchemaObject.ParameterModes, SchemaObject.ReferentialAction, SchemaObject.ViewCheckModes

Field Summary

Fields inherited from interface org.hsqldb.SchemaObject

ASSERTION, CATALOG, CHARSET, COLLATION, COLUMN, CONSTRAINT, CURSOR, DOMAIN, FUNCTION, GRANTEE, INDEX, LABEL, PARAMETER, PROCEDURE, ROUTINE, SCHEMA, SEARCH, SEQUENCE, SERVER, SPECIFIC_ROUTINE, SUBQUERY, TABLE, TRANSITION, TRIGGER, TYPE, VARIABLE, VIEW, WRAPPER

Constructor Summary

Constructors

Constructor and Description
TriggerDef(HsqlNameManager.HsqlName name, int when, int operation, boolean forEachRow, Table table, Table[] transitions, RangeVariable[] rangeVars, Expression condition, java.lang.String conditionSQL, int[] updateColumns)
TriggerDef(HsqlNameManager.HsqlName name, int when, int operation, boolean forEach, Table table, Table[] transitions, RangeVariable[] rangeVars, Expression condition, java.lang.String conditionSQL, int[] updateColumns, java.lang.String triggerClassName, boolean noWait, int queueSize) Constructs a new TriggerDef object to represent an HSQLDB trigger declared in an SQL CREATE TRIGGER statement.

Method Summary

Modifier and Type	Method and Description
void	compile(Session session, SchemaObject parentObject)
java.lang.String	getActionOrientationString()
java.lang.String	getActionTimingString()
HsqlNameManager.HsqlName	getCatalogName()
long	getChangeTimestamp()
java.lang.String	getClassName()
OrderedHashSet	getComponents()
java.lang.String	getConditionSQL()
java.lang.String	getEventTypeString()
HsqlNameManager.HsqlName	getName()
java.lang.String	getNewTransitionRowName()
java.lang.String	getNewTransitionTableName()
java.lang.String	getOldTransitionRowName()
java.lang.String	getOldTransitionTableName()
Grantee	getOwner()
java.lang.String	getProcedureSQL()
OrderedHashSet	getReferences()
HsqlNameManager.HsqlName	getSchemaName()
java.lang.String	getSQL() Retrieves the SQL character sequence required to (re)create the trigger, as a StringBuffer
java.lang.StringBuffer	getSQLMain()
int	getStatementType()
Table	getTable()
int	getType()
int[]	getUpdateColumnIndexes()
boolean	hasNewTable()
boolean	hasOldTable()
boolean	isBusy()
boolean	isForEachRow()
boolean	isSystem()
boolean	isValid()
void	run() run method declaration
void	start() start the thread if this is threaded
void	terminate() signal the thread to stop

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TriggerDef

public TriggerDef(HsqlNameManager.HsqlName name,
                  int when,
                  int operation,
                  boolean forEach,
                  Table table,
                  Table[] transitions,
                  RangeVariable[] rangeVars,
                  Expression condition,
                  java.lang.String conditionSQL,
                  int[] updateColumns,
                  java.lang.String triggerClassName,
                  boolean noWait,
                  int queueSize)

Constructs a new TriggerDef object to represent an HSQLDB trigger declared in an SQL CREATE TRIGGER statement. Changes in 1.7.2 allow the queue size to be specified as 0. A zero queue size causes the Trigger.fire() code to run in the main thread of execution (fully inside the enclosing transaction). Otherwise, the code is run in the Trigger's own thread. (fredt@users)

Parameters:

name - The trigger object's HsqlName

when - whether the trigger fires before, after or instead of the triggering event

operation - the triggering operation; currently insert, update, or delete

forEach - indicates whether the trigger is fired for each row (true) or statement (false)

table - the Table object upon which the indicated operation fires the trigger

triggerClassName - the fully qualified named of the class implementing the org.hsqldb.Trigger (trigger body) interface

noWait - do not wait for available space on the pending queue; if the pending queue does not have fewer than nQueueSize queued items, then overwrite the current tail instead

queueSize - the length to which the pending queue may grow before further additions are either blocked or overwrite the tail entry, as determined by noWait

TriggerDef

public TriggerDef(HsqlNameManager.HsqlName name,
                  int when,
                  int operation,
                  boolean forEachRow,
                  Table table,
                  Table[] transitions,
                  RangeVariable[] rangeVars,
                  Expression condition,
                  java.lang.String conditionSQL,
                  int[] updateColumns)

Method Detail

isValid

public boolean isValid()

getType

public int getType()

Specified by:

getType in interface SchemaObject

getName

public HsqlNameManager.HsqlName getName()

Specified by:

getName in interface SchemaObject

getCatalogName

public HsqlNameManager.HsqlName getCatalogName()

Specified by:

getCatalogName in interface SchemaObject

getSchemaName

public HsqlNameManager.HsqlName getSchemaName()

Specified by:

getSchemaName in interface SchemaObject

getOwner

public Grantee getOwner()

Specified by:

getOwner in interface SchemaObject

getReferences

public OrderedHashSet getReferences()

Specified by:

getReferences in interface SchemaObject

getComponents

public OrderedHashSet getComponents()

Specified by:

getComponents in interface SchemaObject

compile

public void compile(Session session,
                    SchemaObject parentObject)

Specified by:

compile in interface SchemaObject

getSQL

public java.lang.String getSQL()

Retrieves the SQL character sequence required to (re)create the trigger, as a StringBuffer

Specified by:

getSQL in interface SchemaObject

Returns:

the SQL character sequence required to (re)create the trigger

getChangeTimestamp

public long getChangeTimestamp()

Specified by:

getChangeTimestamp in interface SchemaObject

getSQLMain

public java.lang.StringBuffer getSQLMain()

getClassName

public java.lang.String getClassName()

getActionTimingString

public java.lang.String getActionTimingString()

getEventTypeString

public java.lang.String getEventTypeString()

isSystem

public boolean isSystem()

isForEachRow

public boolean isForEachRow()

getConditionSQL

public java.lang.String getConditionSQL()

getProcedureSQL

public java.lang.String getProcedureSQL()

getUpdateColumnIndexes

public int[] getUpdateColumnIndexes()

hasOldTable

public boolean hasOldTable()

hasNewTable

public boolean hasNewTable()

getOldTransitionRowName

public java.lang.String getOldTransitionRowName()

getNewTransitionRowName

public java.lang.String getNewTransitionRowName()

getOldTransitionTableName

public java.lang.String getOldTransitionTableName()

getNewTransitionTableName

public java.lang.String getNewTransitionTableName()

getStatementType

public int getStatementType()

run

public void run()

run method declaration

the trigger JSP is run in its own thread here. Its job is simply to wait until it is told by the main thread that it should fire the trigger.

Specified by:

run in interface java.lang.Runnable

start

public void start()

start the thread if this is threaded

terminate

public void terminate()

signal the thread to stop

isBusy

public boolean isBusy()

getTable

public Table getTable()

getActionOrientationString

public java.lang.String getActionOrientationString()