Modifier and Type	Class and Description
pack-priv static class	TriggerDef.DefaultTrigger
pack-priv static class	TriggerDef.TriggerData Class to store the data used to fire a trigger.

Field Summary

Modifier and Type	Field and Description
pack-priv int	actionTiming
pack-priv static final int	AFTER
pack-priv static final int	BEFORE
pack-priv long	changeTimestamp
pack-priv Expression	condition
pack-priv String	conditionSQL
pack-priv static final TriggerDef[]	emptyArray Hides org.hsqldb.SchemaObject.emptyArray.
pack-priv boolean	forEachRow
pack-priv boolean	hasTransitionRanges
pack-priv boolean	hasTransitionTables
pack-priv static final int	INSTEAD
pack-priv boolean	isSystem
protected volatile boolean	keepGoing
pack-priv int	maxRowsQueued
private HsqlNameManager.HsqlName	name
pack-priv static final int	NEW_ROW
pack-priv static final int	NEW_TABLE
pack-priv boolean	nowait
pack-priv static final int	NUM_TRIGGER_OPS
pack-priv static final int	NUM_TRIGS
pack-priv static final int	OLD_ROW
pack-priv static final int	OLD_TABLE
pack-priv int	operationType
protected HsqlDeque<TriggerDef.TriggerData>	pendingQueue
pack-priv static final int	RANGE_COUNT
pack-priv RangeVariable[]	rangeVars
pack-priv Routine	routine
protected int	rowsQueued
pack-priv Table	table
pack-priv Thread	thread
pack-priv Table[]	transitions
pack-priv Trigger	trigger
pack-priv String	triggerClassName
pack-priv int	triggerType
pack-priv int[]	updateColumns
protected boolean	valid

Constructor Summary

Access	Constructor and Description
public	TriggerDef(HsqlNameManager.HsqlName The trigger object's HsqlName name, int whether the trigger fires before, after or instead of the triggering event when, int the triggering operation; currently insert, update, or delete operation, boolean indicates whether the trigger is fired for each row (true) or statement (false) forEach, Table the Table object upon which the indicated operation fires the trigger table, Table[] transitions, RangeVariable[] rangeVars, Expression condition, String conditionSQL, int[] updateColumns, String the fully qualified name of the class implementing the org.hsqldb.Trigger (trigger body) interface triggerClassName, boolean 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 noWait, int the length to which the pending queue may grow before further additions are either blocked or overwrite the tail entry, as determined by noWait queueSize) Constructs a new TriggerDef object to represent an HSQLDB trigger declared in an SQL CREATE TRIGGER statement.
public	TriggerDef(HsqlNameManager.HsqlName name, int when, int operation, boolean forEachRow, Table table, Table[] transitions, RangeVariable[] rangeVars, Expression condition, String conditionSQL, int[] updateColumns)

Access

Constructor and Description

public

TriggerDef(HsqlNameManager.HsqlName

The trigger object's HsqlName

name, int

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

when, int

the triggering operation; currently insert, update, or delete

operation, boolean

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

forEach, Table

the Table object upon which the indicated operation fires the trigger

table, Table[] transitions, RangeVariable[] rangeVars, Expression condition, String conditionSQL, int[] updateColumns, String

the fully qualified name of the class implementing the org.hsqldb.Trigger (trigger body) interface

triggerClassName, boolean

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

noWait, int

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

queueSize)

Constructs a new TriggerDef object to represent an HSQLDB trigger declared in an SQL CREATE TRIGGER statement.

public

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

Method Summary

Modifier and Type	Method and Description
public String	getActionOrientationString()
public String	getActionTimingString()
public HsqlNameManager.HsqlName	getCatalogName() Implements org.hsqldb.SchemaObject.getCatalogName.
public long	getChangeTimestamp() Implements org.hsqldb.SchemaObject.getChangeTimestamp.
public String	getClassName()
public String	getConditionSQL()
public String	getEventTypeString()
public HsqlNameManager.HsqlName	getName() Implements org.hsqldb.SchemaObject.getName.
public String	getNewTransitionRowName()
public String	getNewTransitionTableName()
public String	getOldTransitionRowName()
public String	getOldTransitionTableName()
pack-priv static int	getOperationType(int token) Return the type code for operation tokens
public Grantee	getOwner() Implements org.hsqldb.SchemaObject.getOwner.
public String	getProcedureSQL()
public HsqlNameManager.HsqlName	getSchemaName() Implements org.hsqldb.SchemaObject.getSchemaName.
public String	Returns: the SQL character sequence required to (re)create the trigger getSQL() Implements org.hsqldb.SchemaObject.getSQL. Retrieves the SQL character sequence required to (re)create the trigger, as a String
public StringBuilder	getSQLMain()
public int	getStatementType()
public Table	getTable()
pack-priv static int	getTiming(int token)
public int	getType() Implements org.hsqldb.SchemaObject.getType.
public int[]	getUpdateColumnIndexes()
public boolean	hasNewRow()
public boolean	hasNewTable()
public boolean	hasOldRow()
public boolean	hasOldTable()
public boolean	isBusy()
public boolean	isForEachRow()
public boolean	isSystem()
public boolean	isValid()
pack-priv synchronized TriggerDef.TriggerData	Returns: Description of the Return Value popPair() pop2 method declaration The consumer (trigger) thread waits for an event to be queued Note This push/pop pairing assumes a single producer thread and a single consumer thread _only_.
pack-priv synchronized void	pushPair(Session the session session, Object[] old row oldData, Object[] new row newData) The main thread tells the trigger thread to fire by this call.
public void	run() Implements java.lang.Runnable.run. run method declaration the trigger JSP is run in its own thread here.
pack-priv void	setUpIndexesAndTypes() Given the SQL creating the trigger, set up the index to the HsqlArrayList[] and the associated GRANT type
public synchronized void	start() start the thread if this is threaded
public synchronized void	terminate() signal the thread to stop

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

actionTiming	back to summary
pack-priv int actionTiming

AFTER	back to summary
pack-priv static final int AFTER

BEFORE	back to summary
pack-priv static final int BEFORE

changeTimestamp	back to summary
pack-priv long changeTimestamp

condition	back to summary
pack-priv Expression condition

conditionSQL	back to summary
pack-priv String conditionSQL

emptyArray	back to summary
pack-priv static final TriggerDef[] emptyArray Hides org.hsqldb.SchemaObject.emptyArray.

forEachRow	back to summary
pack-priv boolean forEachRow

hasTransitionRanges	back to summary
pack-priv boolean hasTransitionRanges

hasTransitionTables	back to summary
pack-priv boolean hasTransitionTables

INSTEAD	back to summary
pack-priv static final int INSTEAD

isSystem	back to summary
pack-priv boolean isSystem

keepGoing	back to summary
protected volatile boolean keepGoing

maxRowsQueued	back to summary
pack-priv int maxRowsQueued

name	back to summary
private HsqlNameManager.HsqlName name

NEW_ROW	back to summary
pack-priv static final int NEW_ROW

NEW_TABLE	back to summary
pack-priv static final int NEW_TABLE

nowait	back to summary
pack-priv boolean nowait

NUM_TRIGGER_OPS	back to summary
pack-priv static final int NUM_TRIGGER_OPS

NUM_TRIGS	back to summary
pack-priv static final int NUM_TRIGS

OLD_ROW	back to summary
pack-priv static final int OLD_ROW

OLD_TABLE	back to summary
pack-priv static final int OLD_TABLE

operationType	back to summary
pack-priv int operationType

pendingQueue	back to summary
protected HsqlDeque<TriggerDef.TriggerData> pendingQueue

RANGE_COUNT	back to summary
pack-priv static final int RANGE_COUNT

rangeVars	back to summary
pack-priv RangeVariable[] rangeVars

routine	back to summary
pack-priv Routine routine

rowsQueued	back to summary
protected int rowsQueued

table	back to summary
pack-priv Table table

thread	back to summary
pack-priv Thread thread

transitions	back to summary
pack-priv Table[] transitions

trigger	back to summary
pack-priv Trigger trigger

triggerClassName	back to summary
pack-priv String triggerClassName

triggerType	back to summary
pack-priv int triggerType

updateColumns	back to summary
pack-priv int[] updateColumns

valid	back to summary
protected boolean valid

Constructor Detail

TriggerDef	back to summary
public TriggerDef(HsqlNameManager.HsqlName name, int when, int operation, boolean forEach, Table table, Table[] transitions, RangeVariable[] rangeVars, Expression condition, String conditionSQL, int[] updateColumns, 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:HsqlNameManager.HsqlName The trigger object's HsqlName when:int whether the trigger fires before, after or instead of the triggering event operation:int the triggering operation; currently insert, update, or delete forEach:boolean indicates whether the trigger is fired for each row (true) or statement (false) table:Table the Table object upon which the indicated operation fires the trigger triggerClassName:String the fully qualified name of the class implementing the org.hsqldb.Trigger (trigger body) interface noWait:boolean 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:int 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

back to summary

public TriggerDef(HsqlNameManager.HsqlName name, int when, int operation, boolean forEach, Table table, Table[] transitions, RangeVariable[] rangeVars, Expression condition, String conditionSQL, int[] updateColumns, 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:HsqlNameManager.HsqlName: The trigger object's HsqlName
when:int: whether the trigger fires before, after or instead of the triggering event
operation:int: the triggering operation; currently insert, update, or delete
forEach:boolean: indicates whether the trigger is fired for each row (true) or statement (false)
table:Table: the Table object upon which the indicated operation fires the trigger
triggerClassName:String: the fully qualified name of the class implementing the org.hsqldb.Trigger (trigger body) interface
noWait:boolean: 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:int: 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	back to summary
public TriggerDef(HsqlNameManager.HsqlName name, int when, int operation, boolean forEachRow, Table table, Table[] transitions, RangeVariable[] rangeVars, Expression condition, String conditionSQL, int[] updateColumns)

Method Detail

getActionOrientationString	back to summary
public String getActionOrientationString()

getActionTimingString	back to summary
public String getActionTimingString()

getCatalogName	back to summary
public HsqlNameManager.HsqlName getCatalogName() Implements org.hsqldb.SchemaObject.getCatalogName.

getChangeTimestamp	back to summary
public long getChangeTimestamp() Implements org.hsqldb.SchemaObject.getChangeTimestamp.

getClassName	back to summary
public String getClassName()

getConditionSQL	back to summary
public String getConditionSQL()

getEventTypeString	back to summary
public String getEventTypeString()

getName	back to summary
public HsqlNameManager.HsqlName getName() Implements org.hsqldb.SchemaObject.getName.

getNewTransitionRowName	back to summary
public String getNewTransitionRowName()

getNewTransitionTableName	back to summary
public String getNewTransitionTableName()

getOldTransitionRowName	back to summary
public String getOldTransitionRowName()

getOldTransitionTableName	back to summary
public String getOldTransitionTableName()

getOperationType	back to summary
pack-priv static int getOperationType(int token) Return the type code for operation tokens

getOwner	back to summary
public Grantee getOwner() Implements org.hsqldb.SchemaObject.getOwner.

getProcedureSQL	back to summary
public String getProcedureSQL()

getSchemaName	back to summary
public HsqlNameManager.HsqlName getSchemaName() Implements org.hsqldb.SchemaObject.getSchemaName.

getSQL

back to summary

public String getSQL()

Implements org.hsqldb.SchemaObject.getSQL.

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

Returns:String: the SQL character sequence required to (re)create the trigger

getSQLMain	back to summary
public StringBuilder getSQLMain()

getStatementType	back to summary
public int getStatementType()

getTable	back to summary
public Table getTable()

getTiming	back to summary
pack-priv static int getTiming(int token)

getType	back to summary
public int getType() Implements org.hsqldb.SchemaObject.getType.

getUpdateColumnIndexes	back to summary
public int[] getUpdateColumnIndexes()

hasNewRow	back to summary
public boolean hasNewRow()

hasNewTable	back to summary
public boolean hasNewTable()

hasOldRow	back to summary
public boolean hasOldRow()

hasOldTable	back to summary
public boolean hasOldTable()

isBusy	back to summary
public boolean isBusy()

isForEachRow	back to summary
public boolean isForEachRow()

isSystem	back to summary
public boolean isSystem()

isValid	back to summary
public boolean isValid()

popPair

back to summary

pack-priv synchronized TriggerDef.TriggerData popPair()

pop2 method declaration

The consumer (trigger) thread waits for an event to be queued

Note

This push/pop pairing assumes a single producer thread and a single consumer thread _only_.

Returns:TriggerDef.TriggerData: Description of the Return Value

pushPair

back to summary

pack-priv synchronized void pushPair(Session session, Object[] oldData, Object[] newData)

The main thread tells the trigger thread to fire by this call. If this Trigger is not threaded then the fire method is called immediately and executed by the main thread. Otherwise, the row data objects are added to the queue to be used by the Trigger thread.

Parameters

session:Session: the session
oldData:Object[]: old row
newData:Object[]: new row

run

back to summary

public void run()

Implements java.lang.Runnable.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.

setUpIndexesAndTypes	back to summary
pack-priv void setUpIndexesAndTypes() Given the SQL creating the trigger, set up the index to the HsqlArrayList[] and the associated GRANT type

start	back to summary
public synchronized void start() start the thread if this is threaded

terminate	back to summary
public synchronized void terminate() signal the thread to stop

org.hsqldb back to summary

pack-priv Class TriggerDef.DefaultTrigger

Class Inheritance

extends Object
implements Trigger

java.lang.Object
org.hsqldb.TriggerDef.DefaultTrigger

All Implemented Interfaces

org.hsqldb.trigger.Trigger

Constructor Summary

Access	Constructor and Description
pack-priv	DefaultTrigger()

Method Summary

Modifier and Type	Method and Description
public void	fire(int i, String name, String table, Object[] row1, Object[] row2) Overrides default org.hsqldb.trigger.Trigger.fire. Old fire method.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Constructor Detail

DefaultTrigger	back to summary
pack-priv DefaultTrigger()

Method Detail

fire

back to summary

public void fire(int i, String name, String table, Object[] row1, Object[] row2)

Overrides default org.hsqldb.trigger.Trigger.fire.

Doc from org.hsqldb.trigger.Trigger.fire.

Old fire method.

org.hsqldb back to summary

pack-priv Class TriggerDef.TriggerData

Class Inheritance

extends Object

java.lang.Object
org.hsqldb.TriggerDef.TriggerData

Class to store the data used to fire a trigger. The username attribute is not used but it allows developers to change the signature of the fire method of the Trigger class and pass the user name to the Trigger.

Field Summary

Modifier and Type	Field and Description
public Object[]	newRow
public Object[]	oldRow
public String	username

Constructor Summary

Access	Constructor and Description
public	TriggerData(Session session, Object[] oldRow, Object[] newRow)

Method Summary

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

newRow	back to summary
public Object[] newRow

oldRow	back to summary
public Object[] oldRow

username	back to summary
public String username

Constructor Detail

TriggerData	back to summary
public TriggerData(Session session, Object[] oldRow, Object[] newRow)

public Class TriggerDef

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

pack-priv Class TriggerDef.DefaultTrigger

Constructor Summary

Method Summary

Constructor Detail

Method Detail

pack-priv Class TriggerDef.TriggerData

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail