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

org.apache.derby.iapi.types.SQLVarchar
SQLVarchar satisfies the DataValueDescriptor interfaces (i.e., OrderableDataType). It implements a String holder, e.g. for storing a column value; it can be specified when constructed to not allow nulls. Nullability cannot be changed after construction.
Because OrderableDataType is a subclass of DataType, SQLVarchar can play a role in either a DataType/ValueRow or a OrderableDataType/KeyRow, interchangeably. SQLVarchar is mostly the same as SQLChar, so it is implemented as a subclass of SQLChar. Only those methods with different behavior are implemented here.


    /* 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

0 1 2 3 4 5 6 7 8 9

TOP

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

org.apache.derby.impl.sql.catalog.DataDictionaryImpl

org.apache.derby.impl.sql.catalog.PermissionsCatalogRowFactory

org.apache.derby.impl.sql.catalog.SYSALIASESRowFactory

org.apache.derby.impl.sql.catalog.SYSCOLUMNSRowFactory

org.apache.derby.impl.sql.catalog.SYSCONGLOMERATESRowFactory

org.apache.derby.impl.sql.catalog.SYSCONSTRAINTSRowFactory

org.apache.derby.impl.sql.catalog.SYSFILESRowFactory

org.apache.derby.impl.sql.catalog.SYSPERMSRowFactory

org.apache.derby.impl.sql.catalog.SYSROLESRowFactory

org.apache.derby.impl.sql.catalog.SYSSCHEMASRowFactory

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.