org.hsqldb

Interface Trigger

Known Implementing Classes:
TriggerSample

public interface Trigger

The interface an HSQLDB TRIGGER must implement

Author:
Peter Hudson

Since:
1.7.0

Field Summary

static int
DELETE_AFTER
static int
DELETE_AFTER_ROW
static int
DELETE_BEFORE
static int
DELETE_BEFORE_ROW
static int
INSERT_AFTER
static int
INSERT_AFTER_ROW
static int
INSERT_BEFORE
static int
INSERT_BEFORE_ROW
static int
UPDATE_AFTER
static int
UPDATE_AFTER_ROW
static int
UPDATE_BEFORE
static int
UPDATE_BEFORE_ROW

Method Summary

void
fire(int type, String trigName, String tabName, Object[] oldRow, Object[] newRow)
The method invoked upon each triggered action.

Field Details

DELETE_AFTER

public static final int DELETE_AFTER

Field Value:
1


DELETE_AFTER_ROW

public static final int DELETE_AFTER_ROW


DELETE_BEFORE

public static final int DELETE_BEFORE


DELETE_BEFORE_ROW

public static final int DELETE_BEFORE_ROW


INSERT_AFTER

public static final int INSERT_AFTER

Field Value:
0


INSERT_AFTER_ROW

public static final int INSERT_AFTER_ROW


INSERT_BEFORE

public static final int INSERT_BEFORE


INSERT_BEFORE_ROW

public static final int INSERT_BEFORE_ROW


UPDATE_AFTER

public static final int UPDATE_AFTER

Field Value:
2


UPDATE_AFTER_ROW

public static final int UPDATE_AFTER_ROW


UPDATE_BEFORE

public static final int UPDATE_BEFORE


UPDATE_BEFORE_ROW

public static final int UPDATE_BEFORE_ROW

Method Details

fire

public void fire(int type,
                 String trigName,
                 String tabName,
                 Object[] oldRow,
                 Object[] newRow)
The method invoked upon each triggered action.

When UPDATE triggers are fired, oldRow contains the existing values of the table row and newRow contains the new values.

For INSERT triggers, oldRow is null and newRow contains the table row to be inserted. For DELETE triggers, newRow is null and oldRow contains the table row to be deleted. type contains the integer index id for trigger type, e.g. TriggerDef.INSERT_AFTER (fredt@users)

Parameters:
trigName - the name of the trigger
tabName - the name of the table upon which the triggered action is occuring
oldRow - the old row
newRow - the new row


Copyright B) 2001 - 2005 HSQL Development Group. All Rights Reserved.