com.mckoi.database

Class ConnectionTriggerManager

java.lang.Object

com.mckoi.database.ConnectionTriggerManager

public final class ConnectionTriggerManager
extends Object

A trigger manager on a DatabaseConnection that maintains a list of all triggers set in the database, and the types of triggers they are. This object is closely tied to a DatabaseConnection.

The trigger manager actually uses a trigger itself to maintain a list of tables that have triggers, and the action to perform on the trigger.

Author:

Tobias Downer

Method Summary

Modifier and Type	Method and Description
void	createTableTrigger(String schema, String name, int type, TableName on_table, String procedure_name, TObject[] params) Creates a new trigger action on a stored procedure and makes the change to the transaction of this DatabaseConnection.
void	dropTrigger(String schema, String name) Drops a trigger that has previously been defined.
boolean	triggerExists(String schema, String name) Returns true if the trigger exists, false otherwise.

Methods inherited from class java.lang.Object

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

Method Detail

createTableTrigger

public void createTableTrigger(String schema,
                               String name,
                               int type,
                               TableName on_table,
                               String procedure_name,
                               TObject[] params)
                        throws DatabaseException

Creates a new trigger action on a stored procedure and makes the change to the transaction of this DatabaseConnection. If the connection is committed then the trigger is made a perminant change to the database.

Parameters:

schema - the schema name of the trigger.

name - the name of the trigger.

type - the type of trigger.

procedure_name - the name of the procedure to execute.

params - any constant parameters for the triggering procedure.

Throws:

DatabaseException

dropTrigger

public void dropTrigger(String schema,
                        String name)
                 throws DatabaseException

Drops a trigger that has previously been defined.

Throws:

DatabaseException

triggerExists

public boolean triggerExists(String schema,
                             String name)

Returns true if the trigger exists, false otherwise.