Package org.apache.derby.iapi.types

Examples of org.apache.derby.iapi.types.SQLVarchar


    /* 1st column is TRIGGERID */
    row.setColumn(1, new SQLChar((uuid == null) ? null : uuid.toString()));

    /* 2nd column is TRIGGERNAME */
    row.setColumn(2, new SQLVarchar(name));

    /* 3rd column is SCHEMAID */
    row.setColumn(3, new SQLChar((suuid == null) ? null : suuid.toString()));

    /* 4th column is CREATIONTIMESTAMP */
    row.setColumn(4, dvf.getDataValue(createTime));

    /* 5th column is EVENT */
    row.setColumn(5, new SQLChar(event));

    /* 6th column is FIRINGTIME */
    row.setColumn(6, new SQLChar(time));

    /* 7th column is TYPE */
    row.setColumn(7, new SQLChar(type));

    /* 8th column is STATE */
    row.setColumn(8, new SQLChar(enabled));

    /* 9th column is TABLEID */
    row.setColumn(9, new SQLChar((tuuid == null) ? null : tuuid.toString()));

    /* 10th column is WHENSTMTID */
    row.setColumn(10, new SQLChar((whenSPSID == null) ? null : whenSPSID.toString()));

    /* 11th column is ACTIONSTMTID */
    row.setColumn(11, new SQLChar((actionSPSID == null) ? null : actionSPSID.toString()));

    /* 12th column is REFERENCEDCOLUMNS
     *  (user type org.apache.derby.catalog.ReferencedColumns)
     */
    row.setColumn(12, dvf.getDataValue(rcd));

    /* 13th column is TRIGGERDEFINITION */
    row.setColumn(13, dvf.getLongvarcharDataValue(triggerDefinition));

    /* 14th column is REFERENCINGOLD */
    row.setColumn(14, dvf.getDataValue(referencingOld));

    /* 15th column is REFERENCINGNEW */
    row.setColumn(15, dvf.getDataValue(referencingNew));

    /* 16th column is OLDREFERENCINGNAME */
    row.setColumn(16, new SQLVarchar(oldReferencingName));

    /* 17th column is NEWREFERENCINGNAME */
    row.setColumn(17, new SQLVarchar(newReferencingName));

    return row;
  }
View Full Code Here


        //
        // Get the aliasID of SYSCS_INPLACE_COMPRESS_TABLE
        //
    TabInfoImpl          aliasTI = getNonCoreTI(SYSALIASES_CATALOG_NUM);
    ExecIndexRow         aliasKeyRow = exFactory.getIndexableRow(3);
    DataValueDescriptor  aliasNameOrderable = new SQLVarchar( "SYSCS_INPLACE_COMPRESS_TABLE" );;
    DataValueDescriptor   nameSpaceOrderable = new SQLChar
            ( new String( new char[] { AliasInfo.ALIAS_TYPE_PROCEDURE_AS_CHAR } ) );
       
    aliasKeyRow.setColumn(1, new SQLChar( SchemaDescriptor.SYSCS_UTIL_SCHEMA_UUID ));
    aliasKeyRow.setColumn(2, aliasNameOrderable);
    aliasKeyRow.setColumn(3, nameSpaceOrderable);

        AliasDescriptor      oldAD = (AliasDescriptor) getDescriptorViaIndex
            (
             SYSALIASESRowFactory.SYSALIASES_INDEX1_ID,
             aliasKeyRow,
             (ScanQualifier [][]) null,
             aliasTI,
             (TupleDescriptor) null,
             (List) null,
             true,
             TransactionController.ISOLATION_REPEATABLE_READ,
             tc);
        UUID                 aliasID = oldAD.getUUID();

        //
        // Now delete the permissions tuple which has a null grantor
        //
    TabInfoImpl          rpTI = getNonCoreTI(SYSROUTINEPERMS_CATALOG_NUM);
    ExecIndexRow         rpKeyRow = exFactory.getIndexableRow(3);

    rpKeyRow.setColumn(1, new SQLVarchar( "PUBLIC" ));
    rpKeyRow.setColumn(2, new SQLChar( aliasID.toString() ));
    rpKeyRow.setColumn(3, new SQLVarchar( (String) null ) );

    int deleteCount = rpTI.deleteRow(tc, rpKeyRow, SYSROUTINEPERMSRowFactory.GRANTEE_ALIAS_GRANTOR_INDEX_NUM);
    }
View Full Code Here

    /* Use tableIDOrderable and columnNameOrderable in both start
     * and stop position for scan.
     */
    tableIdOrderable = getIDValueAsCHAR(tableID);
    columnNameOrderable = new SQLVarchar(columnName);

    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(2);
    keyRow.setColumn(1, tableIdOrderable);
    keyRow.setColumn(2, columnNameOrderable);
View Full Code Here

    ConglomerateController heapCC = tc.openConglomerate(
      ti.getHeapConglomerate(), false, 0,
      TransactionController.MODE_RECORD,
      TransactionController.ISOLATION_REPEATABLE_READ);

    DataValueDescriptor authIdOrderable = new SQLVarchar(authId);
    ScanQualifier[][] scanQualifier = exFactory.getScanQualifier(1);

    scanQualifier[0][0].setQualifier(
      columnNo - 1/* to zero-based */
      authIdOrderable,
 
View Full Code Here

    HashMap hm = new HashMap();

    TabInfoImpl ti = getNonCoreTI(SYSROLES_CATALOG_NUM);
    SYSROLESRowFactory rf = (SYSROLESRowFactory) ti.getCatalogRowFactory();

    DataValueDescriptor isDefOrderable = new SQLVarchar("N");
    ScanQualifier[][] scanQualifier = exFactory.getScanQualifier(1);

    scanQualifier[0][0].setQualifier(
      SYSROLESRowFactory.SYSROLES_ISDEF - 1, /* to zero-based */
      isDefOrderable,
 
View Full Code Here

    ConglomerateController heapCC = tc.openConglomerate(
      ti.getHeapConglomerate(), false, 0,
      TransactionController.MODE_RECORD,
      TransactionController.ISOLATION_REPEATABLE_READ);

    DataValueDescriptor authIdOrderable = new SQLVarchar(authId);
    ScanQualifier[][] scanQualifier = exFactory.getScanQualifier(1);

    scanQualifier[0][0].setQualifier(
      granteeColnoInIndex - 1/* to zero-based */
      authIdOrderable,
 
View Full Code Here

    /* Use objectID/columnName in both start
     * and stop position for index 1 scan.
     */
    refIDOrderable = getIDValueAsCHAR(formerUUID);
    columnNameOrderable = new SQLVarchar(formerName);

    /* Set up the start/stop position for the scan */
    keyRow1 = (ExecIndexRow) exFactory.getIndexableRow(2);
    keyRow1.setColumn(1, refIDOrderable);
    keyRow1.setColumn(2, columnNameOrderable);
View Full Code Here

  {
    DataValueDescriptor      schemaIDOrderable;
    DataValueDescriptor      nameOrderable;
    TabInfoImpl            ti = getNonCoreTI(SYSFILES_CATALOG_NUM);

    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);
View Full Code Here

    TabInfoImpl            ti = getNonCoreTI(SYSSTATEMENTS_CATALOG_NUM);

    /* Use stmtNameOrderable and schemaIdOrderable in both start
     * and stop position for scan.
     */
    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);
View Full Code Here

    TabInfoImpl            ti = getNonCoreTI(SYSTRIGGERS_CATALOG_NUM);

    /* Use triggerNameOrderable and schemaIdOrderable in both start
     * and stop position for scan.
     */
    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);
View Full Code Here

TOP

Related Classes of org.apache.derby.iapi.types.SQLVarchar

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.