|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.h2.samples.TriggerPassData
public class TriggerPassData
This sample application shows how to pass data to a trigger. Trigger data can be persisted by storing it in the database.
Field Summary |
---|
Fields inherited from interface org.h2.api.Trigger |
---|
DELETE, INSERT, SELECT, UPDATE |
Constructor Summary | |
---|---|
TriggerPassData()
|
Method Summary | |
---|---|
void |
close()
This method is called when the database is closed. |
void |
fire(java.sql.Connection conn,
java.lang.Object[] old,
java.lang.Object[] row)
This method is called for each triggered action. |
void |
init(java.sql.Connection conn,
java.lang.String schemaName,
java.lang.String triggerName,
java.lang.String tableName,
boolean before,
int type)
This method is called by the database engine once when initializing the trigger. |
static void |
main(java.lang.String... args)
This method is called when executing this sample application from the command line. |
void |
remove()
This method is called when the trigger is dropped. |
static void |
setTriggerData(java.sql.Connection conn,
java.lang.String trigger,
java.lang.String data)
Call this method to change a specific trigger. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public TriggerPassData()
Method Detail |
---|
public static void main(java.lang.String... args) throws java.lang.Exception
args
- the command line parameters
java.lang.Exception
public void init(java.sql.Connection conn, java.lang.String schemaName, java.lang.String triggerName, java.lang.String tableName, boolean before, int type) throws java.sql.SQLException
Trigger
init
in interface Trigger
conn
- a connection to the database (a system connection)schemaName
- the name of the schematriggerName
- the name of the trigger used in the CREATE TRIGGER
statementtableName
- the name of the tablebefore
- whether the fire method is called before or after the
operation is performedtype
- the operation type: INSERT, UPDATE, DELETE, SELECT, or a
combination (this parameter is a bit field)
java.sql.SQLException
public void fire(java.sql.Connection conn, java.lang.Object[] old, java.lang.Object[] row)
Trigger
The row arrays contain all columns of the table, in the same order as defined in the table.
fire
in interface Trigger
conn
- a connection to the databaseold
- the old row, or null if no old row is available (for
INSERT)row
- the new row, or null if no new row is available (for
DELETE)public void close()
Trigger
close
in interface Trigger
public void remove()
Trigger
remove
in interface Trigger
public static void setTriggerData(java.sql.Connection conn, java.lang.String trigger, java.lang.String data) throws java.sql.SQLException
conn
- the connectiontrigger
- the trigger namedata
- the data
java.sql.SQLException
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |