org.hsqldb
Interface Trigger

All Known Implementing Classes:

TriggerSample

public interface Trigger

The interface an HSQLDB TRIGGER must implement

Since:

1.7.0

Author:

Peter Hudson

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, java.lang.String trigName, java.lang.String tabName, java.lang.Object[] row1, java.lang.Object[] row2) The method invoked upon each triggered action.

Field Detail

INSERT_AFTER

public static final int INSERT_AFTER

See Also:

Constant Field Values

DELETE_AFTER

public static final int DELETE_AFTER

See Also:

Constant Field Values

UPDATE_AFTER

public static final int UPDATE_AFTER

See Also:

Constant Field Values

INSERT_BEFORE

public static final int INSERT_BEFORE

DELETE_BEFORE

public static final int DELETE_BEFORE

UPDATE_BEFORE

public static final int UPDATE_BEFORE

INSERT_AFTER_ROW

public static final int INSERT_AFTER_ROW

DELETE_AFTER_ROW

public static final int DELETE_AFTER_ROW

UPDATE_AFTER_ROW

public static final int UPDATE_AFTER_ROW

INSERT_BEFORE_ROW

public static final int INSERT_BEFORE_ROW

DELETE_BEFORE_ROW

public static final int DELETE_BEFORE_ROW

UPDATE_BEFORE_ROW

public static final int UPDATE_BEFORE_ROW

Method Detail

fire

public void fire(int type,
                 java.lang.String trigName,
                 java.lang.String tabName,
                 java.lang.Object[] row1,
                 java.lang.Object[] row2)

The method invoked upon each triggered action.

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

For INSERT triggers, row1 is null and row2 contains the table row to be inserted. For DELETE triggers, row2 is null and row1 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

row1 - the old row

row2 - the new row