## org.hsqldb
Interface Trigger

All Known Implementing Classes:
  TriggerSample

public interface Trigger

The interface an HSQLDB TRIGGER must implement. The user-supplied class that implements this must have a default constructor.

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[] oldRow, java.lang.Object[] newRow)` 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

See Also:
  Constant Field Values

### DELETE_BEFORE

    public static final int DELETE_BEFORE

See Also:
  Constant Field Values

### UPDATE_BEFORE

    public static final int UPDATE_BEFORE

See Also:
  Constant Field Values

### INSERT_AFTER_ROW

    public static final int INSERT_AFTER_ROW

See Also:
  Constant Field Values

### DELETE_AFTER_ROW

    public static final int DELETE_AFTER_ROW

See Also:
  Constant Field Values

### UPDATE_AFTER_ROW

    public static final int UPDATE_AFTER_ROW

See Also:
  Constant Field Values

### INSERT_BEFORE_ROW

    public static final int INSERT_BEFORE_ROW

See Also:
  Constant Field Values

### DELETE_BEFORE_ROW

    public static final int DELETE_BEFORE_ROW

See Also:
  Constant Field Values

### UPDATE_BEFORE_ROW

    public static final int UPDATE_BEFORE_ROW

See Also:
  Constant Field Values

Method Detail

### fire

    public void fire(int type,
                     java.lang.String trigName,
                     java.lang.String tabName,
                     java.lang.Object[] oldRow,
                     java.lang.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 © 2001 - 2005 HSQL Development Group. All Rights Reserved.