Package org.apache.derby.iapi.sql.execute

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

640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
  {
    long            indexConglomerateNumber = tabInfo.getIndexConglomerate( indexNumber );
    IndexRowGenerator      indexRowGenerator = tabInfo.getIndexRowGenerator( indexNumber );
    CatalogRowFactory      rowFactory = tabInfo.getCatalogRowFactory();
    ExecRow            heapRow = rowFactory.makeEmptyRow();
    ExecIndexRow        indexableRow = indexRowGenerator.getIndexRowTemplate();

    ScanController        heapScan =
      tc.openScan(
        heapConglomerateNumber,       // conglomerate to open
        false,                          // don't hold open across commit
        0,                              // for read
                TransactionController.MODE_TABLE,
                TransactionController.ISOLATION_REPEATABLE_READ,
        (FormatableBitSet) null,                 // all fields as objects
        null,                           // start position - first row
        ScanController.GE,              // startSearchOperation
        null,                           //scanQualifier,
        null,                           //stop position-through last row
        ScanController.GT);             // stopSearchOperation

    RowLocation          heapLocation =
            heapScan.newRowLocationTemplate();

    ConglomerateController    indexController =
      tc.openConglomerate(
        indexConglomerateNumber,
                false,
        TransactionController.OPENMODE_FORUPDATE,
        TransactionController.MODE_TABLE,
        TransactionController.ISOLATION_REPEATABLE_READ);

    while ( heapScan.fetchNext(heapRow.getRowArray()) )
        {
       heapScan.fetchLocation( heapLocation );

      indexRowGenerator.getIndexRow( heapRow, heapLocation, indexableRow, (FormatableBitSet) null );

      indexController.insert(indexableRow.getRowArray());
    }

    indexController.close();
    heapScan.close();
  }
View Full Code Here
2892
2893
2894
2895
2896
2897
2898
2899
2900
2901
2902
2903
     * and stop position for scan.
     */
    viewIdOrderable = getIDValueAsCHAR(viewID);

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

    vd = (ViewDescriptor)
          getDescriptorViaIndex(
            SYSVIEWSRowFactory.SYSVIEWS_INDEX1_ID,
            keyRow,
View Full Code Here
2933
2934
2935
2936
2937
2938
2939
2940
2941
2942
2943
     * and stop position for scan.
     */
    viewIdOrderable = getIDValueAsCHAR(vd.getUUID());

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

    ti.deleteRow( tc, keyRow, SYSVIEWSRowFactory.SYSVIEWS_INDEX1_ID );

  }
View Full Code Here
2954
2955
2956
2957
2958
2959
2960
2961
2962
2963
2964
2965
    DataValueDescriptor      idOrderable;
    TabInfoImpl            ti = getNonCoreTI(SYSFILES_CATALOG_NUM);
    idOrderable = getIDValueAsCHAR(id);

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

    return (FileInfoDescriptor)
          getDescriptorViaIndex(
            SYSFILESRowFactory.SYSFILES_INDEX2_ID,
            keyRow,
View Full Code Here
2997
2998
2999
3000
3001
3002
3003
3004
3005
3006
3007
3008
3009
    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
3030
3031
3032
3033
3034
3035
3036
3037
3038
3039
3040
3041
3042
3043
3044
3045
3046
3047
3048
3049
   */
  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
3180
3181
3182
3183
3184
3185
3186
3187
3188
3189
3190
3191
     * 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
3273
3274
3275
3276
3277
3278
3279
3280
3281
3282
3283
3284
3285
     */
    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
3456
3457
3458
3459
3460
3461
3462
3463
3464
3465
3466
3467
3468
3469
3470
3471
3472
3473
3474
3475
3476
3477
3478
3479
3480
3481
3482
3483
3484
3485
3486
3487
3488
3489
3490
3491
3492
3493
3494
3495
3496
3497
3498
3499
3500
      boolean          updateParamDescriptors,
      boolean          wait,
      boolean                 firstCompilation)
            throws StandardException
  {
    ExecIndexRow        keyRow1 = null;
    ExecRow              row;
    DataValueDescriptor      idOrderable;
    DataValueDescriptor      columnNameOrderable;
    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_LASTCOMPILED,
                   SYSSTATEMENTSRowFactory.SYSSTATEMENTS_USINGTEXT,
                   SYSSTATEMENTSRowFactory.SYSSTATEMENTS_CONSTANTSTATE,
                   SYSSTATEMENTSRowFactory.SYSSTATEMENTS_INITIALLY_COMPILABLE};
      }else
      {

        updCols = new int[] {SYSSTATEMENTSRowFactory.SYSSTATEMENTS_VALID,
                     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
3690
3691
3692
3693
3694
3695
3696
3697
3698
3699
3700
3701
    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
TOP

Related Classes of org.apache.derby.iapi.sql.execute.ExecIndexRow

  • org.apache.derby.iapi.sql.dictionary.IndexRowGenerator
  • org.apache.derby.impl.sql.catalog.DataDictionaryImpl
  • org.apache.derby.impl.sql.catalog.DD_Version
  • org.apache.derby.impl.sql.catalog.IndexScan
  • org.apache.derby.impl.sql.catalog.SYSALIASESRowFactory
  • org.apache.derby.impl.sql.catalog.SYSCHECKSRowFactory
  • org.apache.derby.impl.sql.catalog.SYSCOLPERMSRowFactory
  • org.apache.derby.impl.sql.catalog.SYSCOLUMNSRowFactory
  • org.apache.derby.impl.sql.catalog.SYSCONGLOMERATESRowFactory
  • org.apache.derby.impl.sql.catalog.SYSCONSTRAINTSRowFactory
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.