public class DB_Trigger
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
private static java.lang.String |
EVENT |
private static java.lang.String |
FIRINGTIME |
private static java.lang.String |
NEWREFERENCINGNAME |
private static java.lang.String |
OLDREFERENCINGNAME |
private static java.lang.String |
REFERENCEDCOLUMNS |
private static java.lang.String |
REFERENCINGNEW |
private static java.lang.String |
REFERENCINGOLD |
private static java.lang.String |
SCHEMAID |
private static java.lang.String |
TABLEID |
private static java.lang.String |
TRIGGERDEFINITION |
private static java.lang.String |
TRIGGERNAME |
private static java.lang.String |
TYPE |
private static java.lang.String |
WHENCLAUSETEXT |
Constructor and Description |
---|
DB_Trigger() |
Modifier and Type | Method and Description |
---|---|
private static java.lang.String |
createTrigger(java.lang.String trigName,
java.lang.String tableName,
java.lang.String whenClause,
java.sql.ResultSet aTrig)
Generate DDL for a specific trigger.
|
static void |
doTriggers(java.sql.Connection conn,
boolean supportsWhenClause)
Generate the DDL for all triggers in a given
database.
|
private static final java.lang.String TRIGGERNAME
private static final java.lang.String SCHEMAID
private static final java.lang.String EVENT
private static final java.lang.String FIRINGTIME
private static final java.lang.String TYPE
private static final java.lang.String TABLEID
private static final java.lang.String REFERENCEDCOLUMNS
private static final java.lang.String TRIGGERDEFINITION
private static final java.lang.String REFERENCINGOLD
private static final java.lang.String REFERENCINGNEW
private static final java.lang.String OLDREFERENCINGNAME
private static final java.lang.String NEWREFERENCINGNAME
private static final java.lang.String WHENCLAUSETEXT
public static void doTriggers(java.sql.Connection conn, boolean supportsWhenClause) throws java.sql.SQLException
conn
- Connection to the source database.supportsWhenClause
- Tells whether the database supports the
trigger WHEN clause.java.sql.SQLException
private static java.lang.String createTrigger(java.lang.String trigName, java.lang.String tableName, java.lang.String whenClause, java.sql.ResultSet aTrig) throws java.sql.SQLException
trigName
- Name of the trigger.tableName
- Name of the table on which the trigger
fires.whenClause
- The WHEN clause text (possibly null
).aTrig
- Information about the trigger.java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.