Examples of ExecIndexRow

org.apache.derby.iapi.sql.execute.ExecIndexRow
This is an extension of ExecRow for use with indexes and sorting. @author jeff after ames

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow


    nameOrderable = new SQLVarchar(name);
    schemaIDOrderable = getIDValueAsCHAR(schemaId);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(2);
    keyRow.setColumn(1, nameOrderable);
    keyRow.setColumn(2, schemaIDOrderable);
    FileInfoDescriptor r = (FileInfoDescriptor)
          getDescriptorViaIndex(
            SYSFILESRowFactory.SYSFILES_INDEX1_ID,
            keyRow,
            (ScanQualifier [][]) null,

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

   */
  public void  dropFileInfoDescriptor(FileInfoDescriptor fid)
            throws StandardException
  {
    ConglomerateController  heapCC;
    ExecIndexRow      keyRow1 = null;
    DataValueDescriptor    idOrderable;
    TabInfoImpl          ti = getNonCoreTI(SYSFILES_CATALOG_NUM);
    TransactionController   tc = getTransactionExecute();
    
    /* Use tableIdOrderable and schemaIdOrderable in both start 
     * and stop position for index 1 scan. 
     */
    idOrderable = getIDValueAsCHAR(fid.getUUID());


    /* Set up the start/stop position for the scan */
    keyRow1 = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow1.setColumn(1, idOrderable);
    ti.deleteRow( tc, keyRow1, SYSFILESRowFactory.SYSFILES_INDEX2_ID );
  }

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

     * and stop position for scan. 
     */
    stmtIDOrderable = new SQLChar(stmtUUID);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, stmtIDOrderable);


    SPSDescriptor spsd = (SPSDescriptor)
          getDescriptorViaIndex(
            SYSSTATEMENTSRowFactory.SYSSTATEMENTS_INDEX1_ID,
            keyRow,

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

     */
    stmtNameOrderable = new SQLVarchar(stmtName);
    schemaIDOrderable = new SQLChar(schemaUUID);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(2);
    keyRow.setColumn(1, stmtNameOrderable);
    keyRow.setColumn(2, schemaIDOrderable);


    SPSDescriptor spsd = (SPSDescriptor)
          getDescriptorViaIndex(
            SYSSTATEMENTSRowFactory.SYSSTATEMENTS_INDEX2_ID,
            keyRow,

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

      boolean                 recompile,
      boolean          updateParamDescriptors,
      boolean                 firstCompilation)
            throws StandardException
  {
    ExecIndexRow        keyRow1 = null;
    ExecRow              row;
    DataValueDescriptor      idOrderable;
    TabInfoImpl            ti = getNonCoreTI(SYSSTATEMENTS_CATALOG_NUM);
    SYSSTATEMENTSRowFactory  rf = (SYSSTATEMENTSRowFactory) ti.getCatalogRowFactory();
    int[] updCols;
    if (recompile)
    {
      if(firstCompilation)
      {
        updCols = new int[] {SYSSTATEMENTSRowFactory.SYSSTATEMENTS_VALID,
             SYSSTATEMENTSRowFactory.SYSSTATEMENTS_TEXT,
                   SYSSTATEMENTSRowFactory.SYSSTATEMENTS_LASTCOMPILED,
                   SYSSTATEMENTSRowFactory.SYSSTATEMENTS_USINGTEXT,
                   SYSSTATEMENTSRowFactory.SYSSTATEMENTS_CONSTANTSTATE,
                   SYSSTATEMENTSRowFactory.SYSSTATEMENTS_INITIALLY_COMPILABLE};
      }else
      {


        updCols = new int[] {SYSSTATEMENTSRowFactory.SYSSTATEMENTS_VALID,
             SYSSTATEMENTSRowFactory.SYSSTATEMENTS_TEXT,
                     SYSSTATEMENTSRowFactory.SYSSTATEMENTS_LASTCOMPILED,
                     SYSSTATEMENTSRowFactory.SYSSTATEMENTS_USINGTEXT,
                     SYSSTATEMENTSRowFactory.SYSSTATEMENTS_CONSTANTSTATE };
      }
    }
    else 
    {
      updCols = new int[]  {SYSSTATEMENTSRowFactory.SYSSTATEMENTS_VALID} ;
    }
      
    idOrderable = getIDValueAsCHAR(spsd.getUUID());


    /* Set up the start/stop position for the scan */
    keyRow1 = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow1.setColumn(1, idOrderable);


    row = rf.makeSYSSTATEMENTSrow(false,   // don't compile
                    spsd);


    /*

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

    TabInfoImpl          ti = getNonCoreTI(SYSSTATEMENTS_CATALOG_NUM);


    stmtIdOrderable = getIDValueAsCHAR(uuid);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow.setColumn(1, stmtIdOrderable);


    ti.deleteRow( tc, keyRow, SYSSTATEMENTSRowFactory.SYSSTATEMENTS_INDEX1_ID );


    /* drop all columns in SYSCOLUMNS */  
    dropAllColumnDescriptors(uuid, tc);

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

  {
    TabInfoImpl            ti = getNonCoreTI(SYSTRIGGERS_CATALOG_NUM);
    DataValueDescriptor triggerIdOrderable = getIDValueAsCHAR(uuid);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, triggerIdOrderable);


    return (TriggerDescriptor)
          getDescriptorViaIndex(
            SYSTRIGGERSRowFactory.SYSTRIGGERS_INDEX1_ID,
            keyRow,

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

     */
    triggerNameOrderable = new SQLVarchar(name);
    schemaIDOrderable = getIDValueAsCHAR(sd.getUUID());


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(2);
    keyRow.setColumn(1, triggerNameOrderable);
    keyRow.setColumn(2, schemaIDOrderable);


    return (TriggerDescriptor)
          getDescriptorViaIndex(
            SYSTRIGGERSRowFactory.SYSTRIGGERS_INDEX2_ID,
            keyRow,

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow


    /* Use tableIDOrderable in both start and stop positions for scan */
    tableIDOrderable = getIDValueAsCHAR(td.getUUID());


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = (ExecIndexRow) exFactory.getIndexableRow(1);


    keyRow.setColumn(1, tableIDOrderable);


    getDescriptorViaIndex(
          SYSTRIGGERSRowFactory.SYSTRIGGERS_INDEX3_ID,
          keyRow,
          (ScanQualifier [][]) null,

View Full Code Here

Examples of org.apache.derby.iapi.sql.execute.ExecIndexRow

    TabInfoImpl          ti = getNonCoreTI(SYSTRIGGERS_CATALOG_NUM);


    idOrderable = getIDValueAsCHAR(descriptor.getUUID());


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = (ExecIndexRow) exFactory.getIndexableRow(1);
    keyRow.setColumn(1, idOrderable);


    ti.deleteRow(tc, keyRow, SYSTRIGGERSRowFactory.SYSTRIGGERS_INDEX1_ID);
  }

View Full Code Here

0 1 2 3 4 5

TOP

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.