Examples of org.apache.derby.iapi.sql.dictionary.TriggerDescriptor

Package org.apache.derby.iapi.sql.dictionary

Examples of org.apache.derby.iapi.sql.dictionary.TriggerDescriptor

org.apache.derby.iapi.sql.dictionary.TriggerDescriptor
A trigger.
We are dependent on TableDescriptors, SPSDescriptors (for our WHEN clause and our action). Note that we don't strictly need to be dependent on out SPSes because we could just disallow anyone from dropping an sps of type 'T', but to keep dependencies uniform, we'll do be dependent.
We are a provider for DML (PreparedStatements or SPSes) The public methods for this class are:
1. getUUID
2. getName
3. getSchemaDescriptor
4. public boolean listensForEvent(int event);
5. public int getTriggerEventMask();
6. public Timestamp getCreationTimestamp();
7. public boolean isBeforeTrigger();
8. public boolean isRowTrigger();
9. public UUID getActionId();
10. public SPSDescriptor getActionSPS();
11. public UUID getWhenClauseId();
12. public SPSDescriptor getWhenClauseSPS()
13. public TableDescriptor getTableDescriptor()
14. public ReferencedColumns getReferencedColumnsDescriptor()
15. public int[] getReferencedCols();
16. public boolean isEnabled();
17. public void setEnabled();
18. public void setDisabled();
19. public boolean needsToFire(int stmtType, int[] modifiedCols)
20. public String getTriggerDefinition();
21. public boolean getReferencingOld();
22. public boolean getReferencingNew();
23. public String getOldReferencingName();
24. public String getNewReferencingName();

    //truncate is not allowed when there are enabled DELETE triggers
    GenericDescriptorList tdl = dd.getTriggerDescriptors(td);
    Enumeration descs = tdl.elements();
    while (descs.hasMoreElements())
    {
      TriggerDescriptor trd = (TriggerDescriptor) descs.nextElement();
      if (trd.listensForEvent(TriggerDescriptor.TRIGGER_EVENT_DELETE) &&
        trd.isEnabled())
      {
        throw
          StandardException.newException(SQLState.LANG_NO_TRUNCATE_ON_ENABLED_DELETE_TRIGGERS,
                           td.getName(),trd.getName());  
      }
    }


    //gather information from the existing conglomerate to create new one.
    emptyHeapRow = td.getEmptyExecRow();

View Full Code Here

    // need to deal with triggers if has referencedColumns
    GenericDescriptorList tdl = dd.getTriggerDescriptors(td);
    Enumeration descs = tdl.elements();
    while (descs.hasMoreElements())
    {
      TriggerDescriptor trd = (TriggerDescriptor) descs.nextElement();
      int[] referencedCols = trd.getReferencedCols();
      if (referencedCols == null)
        continue;
      int refColLen = referencedCols.length, j;
      boolean changed = false;
      for (j = 0; j < refColLen; j++)
      {
        if (referencedCols[j] > columnPosition)
          changed = true;
        else if (referencedCols[j] == columnPosition)
        {
          if (cascade)
          {
            DropTriggerConstantAction.dropTriggerDescriptor(lcc, dm, dd, tc, trd, activation);
            activation.addWarning(
              StandardException.newWarning(SQLState.LANG_TRIGGER_DROPPED,
                trd.getName(), td.getName()));
          }
          else
          {  // we'd better give an error if don't drop it,
            // otherwsie there would be unexpected behaviors
            throw StandardException.newException(SQLState.LANG_PROVIDER_HAS_DEPENDENT_OBJECT,
                    dm.getActionString(DependencyManager.DROP_COLUMN),
                    columnInfo[ix].name, "TRIGGER",
                    trd.getName() );
          }
          break;
        }
      }

View Full Code Here

    //truncate is not allowed when there are enabled DELETE triggers
    GenericDescriptorList tdl = dd.getTriggerDescriptors(td);
    Enumeration descs = tdl.elements();
    while (descs.hasMoreElements())
    {
      TriggerDescriptor trd = (TriggerDescriptor) descs.nextElement();
      if (trd.listensForEvent(TriggerDescriptor.TRIGGER_EVENT_DELETE) &&
        trd.isEnabled())
      {
        throw
          StandardException.newException(SQLState.LANG_NO_TRUNCATE_ON_ENABLED_DELETE_TRIGGERS,
                           td.getName(),trd.getName());  
      }
    }


    //gather information from the existing conglomerate to create new one.
    emptyHeapRow = td.getEmptyExecRow(lcc.getContextManager());

View Full Code Here

    // need to deal with triggers if has referencedColumns
    GenericDescriptorList tdl = dd.getTriggerDescriptors(td);
    Enumeration descs = tdl.elements();
    while (descs.hasMoreElements())
    {
      TriggerDescriptor trd = (TriggerDescriptor) descs.nextElement();
      int[] referencedCols = trd.getReferencedCols();
      if (referencedCols == null)
        continue;
      int refColLen = referencedCols.length, j;
      boolean changed = false;
      for (j = 0; j < refColLen; j++)
      {
        if (referencedCols[j] > droppedColumnPosition)
                {
          changed = true;
                }
        else if (referencedCols[j] == droppedColumnPosition)
        {
          if (cascade)
          {
                        trd.drop(lcc);
            activation.addWarning(
              StandardException.newWarning(
                                SQLState.LANG_TRIGGER_DROPPED, 
                                trd.getName(), td.getName()));
          }
          else
          {  // we'd better give an error if don't drop it,
            // otherwsie there would be unexpected behaviors
            throw StandardException.newException(
                            SQLState.LANG_PROVIDER_HAS_DEPENDENT_OBJECT,
                            dm.getActionString(DependencyManager.DROP_COLUMN),
                            columnInfo[ix].name, "TRIGGER",
                            trd.getName() );
          }
          break;
        }
      }

View Full Code Here

    //truncate is not allowed when there are enabled DELETE triggers
    GenericDescriptorList tdl = dd.getTriggerDescriptors(td);
    Enumeration descs = tdl.elements();
    while (descs.hasMoreElements())
    {
      TriggerDescriptor trd = (TriggerDescriptor) descs.nextElement();
      if (trd.listensForEvent(TriggerDescriptor.TRIGGER_EVENT_DELETE) &&
        trd.isEnabled())
      {
        throw
          StandardException.newException(SQLState.LANG_NO_TRUNCATE_ON_ENABLED_DELETE_TRIGGERS,
                           td.getName(),trd.getName());  
      }
    }


    //gather information from the existing conglomerate to create new one.
    emptyHeapRow = td.getEmptyExecRow();

View Full Code Here

    /* Drop the triggers */
    GenericDescriptorList tdl = dd.getTriggerDescriptors(td);
    Enumeration descs = tdl.elements();
    while (descs.hasMoreElements())
    {
      TriggerDescriptor trd = (TriggerDescriptor) descs.nextElement();
            trd.drop(lcc);
    }


    /* Drop all defaults */
    ColumnDescriptorList cdl = td.getColumnDescriptorList();
    int           cdlSize = cdl.size();

View Full Code Here

      executorLists[i] = new Vector();
    }


    for (int i = 0; i < triggerInfo.triggerArray.length; i++)
    {
      TriggerDescriptor td = triggerInfo.triggerArray[i];
      switch (td.getTriggerEventMask())
      {
        case TriggerDescriptor.TRIGGER_EVENT_INSERT:
          if (td.isBeforeTrigger())
          {
            executorLists[TriggerEvent.BEFORE_INSERT].addElement(td);
          }
          else
          {
            executorLists[TriggerEvent.AFTER_INSERT].addElement(td);
          }
          break;




        case TriggerDescriptor.TRIGGER_EVENT_DELETE:
          if (td.isBeforeTrigger())
          {
            executorLists[TriggerEvent.BEFORE_DELETE].addElement(td);
          }
          else
          {
            executorLists[TriggerEvent.AFTER_DELETE].addElement(td);
          }
          break;


        case TriggerDescriptor.TRIGGER_EVENT_UPDATE:
          if (td.isBeforeTrigger())
          {
            executorLists[TriggerEvent.BEFORE_UPDATE].addElement(td);
          }
          else
          {
            executorLists[TriggerEvent.AFTER_UPDATE].addElement(td);
          }
          break;
        default:
          if (SanityManager.DEBUG)
          {
            SanityManager.THROWASSERT("bad trigger event "+td.getTriggerEventMask());
          }
      }
    }


    for (int i = 0; i < executorLists.length; i++)
    {
      int size = executorLists[i].size();
      if (size > 0)
      {
        executors[i] = new GenericTriggerExecutor[size];
        for (int j = 0; j < size; j++)
        {
          TriggerDescriptor td = (TriggerDescriptor)executorLists[i].elementAt(j);
          executors[i][j] =  (td.isRowTrigger()) ? 
                (GenericTriggerExecutor)new RowTriggerExecutor(tec, td, activation, lcc) :
                (GenericTriggerExecutor)new StatementTriggerExecutor(tec, td, activation, lcc);
        }
      }
    }

View Full Code Here

        ** For now, we don't allow bulk insert replace when 
        ** there is a trigger. 
        */
        if (triggerInfo != null)
        {
          TriggerDescriptor td = triggerInfo.getTriggerArray()[0];
          throw StandardException.newException(SQLState.LANG_NO_BULK_INSERT_REPLACE_WITH_TRIGGER_DURING_EXECUTION, constants.getTableName(), td.getName());
        }
      }
    }


    //System.out.println("new InsertResultSet " + sourceResultSet.getClass());

View Full Code Here

    // need to deal with triggers if has referencedColumns
    GenericDescriptorList tdl = dd.getTriggerDescriptors(td);
    Enumeration descs = tdl.elements();
    while (descs.hasMoreElements())
    {
      TriggerDescriptor trd = (TriggerDescriptor) descs.nextElement();
      int[] referencedCols = trd.getReferencedCols();
      if (referencedCols == null)
        continue;
      int refColLen = referencedCols.length, j;
      boolean changed = false;
      for (j = 0; j < refColLen; j++)
      {
        if (referencedCols[j] > droppedColumnPosition)
                {
          changed = true;
                }
        else if (referencedCols[j] == droppedColumnPosition)
        {
          if (cascade)
          {
                        trd.drop(lcc);
            activation.addWarning(
              StandardException.newWarning(
                                SQLState.LANG_TRIGGER_DROPPED, 
                                trd.getName(), td.getName()));
          }
          else
          {  // we'd better give an error if don't drop it,
            // otherwsie there would be unexpected behaviors
            throw StandardException.newException(
                            SQLState.LANG_PROVIDER_HAS_DEPENDENT_OBJECT,
                            dm.getActionString(DependencyManager.DROP_COLUMN),
                            columnName, "TRIGGER",
                            trd.getName() );
          }
          break;
        }
      }

View Full Code Here

    //truncate is not allowed when there are enabled DELETE triggers
    GenericDescriptorList tdl = dd.getTriggerDescriptors(td);
    Enumeration descs = tdl.elements();
    while (descs.hasMoreElements())
    {
      TriggerDescriptor trd = (TriggerDescriptor) descs.nextElement();
      if (trd.listensForEvent(TriggerDescriptor.TRIGGER_EVENT_DELETE) &&
        trd.isEnabled())
      {
        throw
          StandardException.newException(SQLState.LANG_NO_TRUNCATE_ON_ENABLED_DELETE_TRIGGERS,
                           td.getName(),trd.getName());  
      }
    }


    //gather information from the existing conglomerate to create new one.
    emptyHeapRow = td.getEmptyExecRow();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.derby.iapi.sql.dictionary.TriggerDescriptor

org.apache.derby.catalog.UUID

org.apache.derby.iapi.sql.compile.CompilerContext

org.apache.derby.iapi.sql.compile.Parser

org.apache.derby.iapi.sql.compile.Visitable

org.apache.derby.iapi.sql.conn.LanguageConnectionContext

org.apache.derby.iapi.sql.depend.DependencyManager

org.apache.derby.iapi.store.access.TransactionController

org.apache.derby.impl.sql.catalog.SYSTRIGGERSRowFactory

org.apache.derby.impl.sql.compile.DeleteNode

org.apache.derby.impl.sql.compile.DMLModStatementNode

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.