Apache Derby Tools 10.17.1.0 · org.apache.derby.impl.tools.dblook.DB_Trigger

Field Summary

Access	Constructor and Description
public	DB_Trigger()

Modifier and Type	Method and Description
private static String	Returns: The DDL for the current trigger is returned as a String. createTrigger(String Name of the trigger. trigName, String Name of the table on which the trigger fires. tableName, String The WHEN clause text (possibly `null`). whenClause, ResultSet Information about the trigger. aTrig) Generate DDL for a specific trigger.
public static void	doTriggers(Connection Connection to the source database. conn, boolean Tells whether the database supports the trigger WHEN clause. supportsWhenClause) Generate the DDL for all triggers in a given database.

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

EVENT	back to summary
private static final String EVENT

FIRINGTIME	back to summary
private static final String FIRINGTIME

NEWREFERENCINGNAME	back to summary
private static final String NEWREFERENCINGNAME

OLDREFERENCINGNAME	back to summary
private static final String OLDREFERENCINGNAME

REFERENCEDCOLUMNS	back to summary
private static final String REFERENCEDCOLUMNS

REFERENCINGNEW	back to summary
private static final String REFERENCINGNEW

REFERENCINGOLD	back to summary
private static final String REFERENCINGOLD

SCHEMAID	back to summary
private static final String SCHEMAID

TABLEID	back to summary
private static final String TABLEID

TRIGGERDEFINITION	back to summary
private static final String TRIGGERDEFINITION

TRIGGERNAME	back to summary
private static final String TRIGGERNAME

TYPE	back to summary
private static final String TYPE

WHENCLAUSETEXT	back to summary
private static final String WHENCLAUSETEXT

DB_Trigger	back to summary
public DB_Trigger()

createTrigger back to summary

createTrigger	back to summary
private static String createTrigger(String trigName, String tableName, String whenClause, ResultSet aTrig) throws SQLException Generate DDL for a specific trigger. Parameters trigName:String Name of the trigger. tableName:String Name of the table on which the trigger fires. whenClause:String The WHEN clause text (possibly `null`). aTrig:ResultSet Information about the trigger. Returns:String The DDL for the current trigger is returned as a String.

private static String createTrigger(String trigName, String tableName, String whenClause, ResultSet aTrig) throws SQLException

Generate DDL for a specific trigger.

Parameters

Returns:String

The DDL for the current trigger is returned as a String.

doTriggers	back to summary
public static void doTriggers(Connection conn, boolean supportsWhenClause) throws SQLException Generate the DDL for all triggers in a given database. Parameters conn:Connection Connection to the source database. supportsWhenClause:boolean Tells whether the database supports the trigger WHEN clause.

doTriggers

public static void doTriggers(Connection conn, boolean supportsWhenClause) throws SQLException

Generate the DDL for all triggers in a given database.

Parameters

conn:Connection: Connection to the source database.
supportsWhenClause:boolean: Tells whether the database supports the trigger WHEN clause.