Package org.h2.samples

Class UpdatableView

  • All Implemented Interfaces:
    Trigger
    public class UpdatableView
extends TriggerAdapter
    This sample application shows how to use triggers to create updatable views.

    • Constructor Summary

      Constructors 
      Constructor Description
      UpdatableView()  

    • Method Summary

      All Methods Static Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      void close()
      This method is called when the database is closed.
      void fire​(java.sql.Connection conn, java.sql.ResultSet oldRow, java.sql.ResultSet newRow)
      This method is called for each triggered action by the default fire(Connection conn, Object[] oldRow, Object[] newRow) method.
      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.

      • Methods inherited from class java.lang.Object

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

    • Constructor Detail

      • UpdatableView

        public UpdatableView()

    • Method Detail

      • main

        public static void main​(java.lang.String... args)
                 throws java.lang.Exception
        This method is called when executing this sample application from the command line.
        Parameters:
        args - ignored
        Throws:
        java.lang.Exception - on failure

      • init

        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
        Description copied from class: TriggerAdapter
        This method is called by the database engine once when initializing the trigger. It is called when the trigger is created, as well as when the database is opened. The default implementation initialized the result sets.
        Specified by:
        init in interface Trigger
        Overrides:
        init in class TriggerAdapter
        Parameters:
        conn - a connection to the database
        schemaName - the name of the schema
        triggerName - the name of the trigger used in the CREATE TRIGGER statement
        tableName - the name of the table
        before - whether the fire method is called before or after the operation is performed
        type - the operation type: INSERT, UPDATE, DELETE, SELECT, or a combination (this parameter is a bit field)
        Throws:
        java.sql.SQLException - on SQL exception

      • fire

        public void fire​(java.sql.Connection conn,
                 java.sql.ResultSet oldRow,
                 java.sql.ResultSet newRow)
          throws java.sql.SQLException
        Description copied from class: TriggerAdapter
        This method is called for each triggered action by the default fire(Connection conn, Object[] oldRow, Object[] newRow) method.

        For "before" triggers, the new values of the new row may be changed using the ResultSet.updateX methods.

        Specified by:
        fire in class TriggerAdapter
        Parameters:
        conn - a connection to the database
        oldRow - the old row, or null if no old row is available (for INSERT)
        newRow - the new row, or null if no new row is available (for DELETE)
        Throws:
        java.sql.SQLException - if the operation must be undone

      • close

        public void close()
           throws java.sql.SQLException
        Description copied from interface: Trigger
        This method is called when the database is closed. If the method throws an exception, it will be logged, but closing the database will continue.
        Throws:
        java.sql.SQLException - on SQL exception