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.

    }


    /* Use constraintNameOrderable and schemaIdOrderable in both start 
     * and stop position for index 2 scan. 
     */
    constraintNameOrderable = new SQLVarchar(descriptor.getConstraintName());
    schemaIDOrderable = getIDValueAsCHAR(descriptor.getSchemaDescriptor().getUUID());


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

View Full Code Here

    ExecIndexRow        keyRow2 = null;
    DataValueDescriptor      nameOrderable;
    DataValueDescriptor      schemaIDOrderable = null;
    TabInfoImpl            ti = coreInfo[SYSCONGLOMERATES_CORE_NUM];


    nameOrderable = new SQLVarchar(indexName);
    schemaIDOrderable = getIDValueAsCHAR(sd.getUUID());


    /* Set up the start/stop position for the scan */
    keyRow2 = exFactory.getIndexableRow(2);
    keyRow2.setColumn(1, nameOrderable);

View Full Code Here

    ExecIndexRow      keyRow2 = null;
    DataValueDescriptor    nameOrderable;
    DataValueDescriptor    schemaIDOrderable = null;
    TabInfoImpl          ti = coreInfo[SYSCONGLOMERATES_CORE_NUM];


    nameOrderable = new SQLVarchar(conglomerate.getConglomerateName());
    schemaIDOrderable = getIDValueAsCHAR(conglomerate.getSchemaID());


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

View Full Code Here

    TabInfoImpl            ti = coreInfo[SYSSCHEMAS_CORE_NUM];


    /* Use schemaNameOrderable in both start 
     * and stop position for index 1 scan. 
     */
    schemaNameOrderable = new SQLVarchar(schemaName);


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


    SYSSCHEMASRowFactory  rf = (SYSSCHEMASRowFactory) ti.getCatalogRowFactory();
    ExecRow row = rf.makeEmptyRow();


    row.setColumn(SYSSCHEMASRowFactory.SYSSCHEMAS_SCHEMAAID,
            new SQLVarchar(authorizationId));


    boolean[] bArray = {false, false};


    int[] colsToUpdate = {SYSSCHEMASRowFactory.SYSSCHEMAS_SCHEMAAID};

View Full Code Here

    SYSALIASESRowFactory    rf = (SYSALIASESRowFactory) ti.getCatalogRowFactory();


    /* Use aliasNameOrderable and aliasTypeOrderable in both start 
     * and stop position for scan. 
     */
    aliasNameOrderable = new SQLVarchar(aliasName);
    char[] charArray = new char[1];
    charArray[0] = nameSpace;
    nameSpaceOrderable = new SQLChar(new String(charArray));


    /* Set up the start/stop position for the scan */

View Full Code Here

    charArray[0] = ad.getNameSpace();


    /* Set up the start/stop position for the scan */
        ExecIndexRow keyRow1 = (ExecIndexRow) exFactory.getIndexableRow(3);
    keyRow1.setColumn(1, getIDValueAsCHAR(ad.getSchemaUUID()));
    keyRow1.setColumn(2, new SQLVarchar(ad.getDescriptorName()));
    keyRow1.setColumn(3, new SQLChar(new String(charArray)));


    ti.deleteRow( tc, keyRow1, SYSALIASESRowFactory.SYSALIASES_INDEX1_ID );


  }

View Full Code Here

    row = exFactory.getValueRow(1);


    /* Use tableNameOrderable and schemaIdOrderable in both start 
     * and stop position for scan. 
     */
    tableNameOrderable = new SQLVarchar(tableName);
    schemaIDOrderable = new SQLChar(schemaUUID);


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

View Full Code Here


    /* 2nd column is SCHEMAID (UUID - char(36)) */
    row.setColumn(SCHEMA_ID_COL_NUM, new SQLChar(schemaId_S));


    /* 3rd column is NAME (varchar(30)) */
    row.setColumn(NAME_COL_NUM, new SQLVarchar(SQLname));


    /* 4th column is GENERATIONID (long) */
    row.setColumn(GENERATION_ID_COL_NUM, dvf.getDataValue(generationId));


    return row;

View Full Code Here


    /* 1st column is ALIASID (UUID - char(36)) */
    row.setColumn(SYSALIASES_ALIASID, new SQLChar(aliasID));


    /* 2nd column is ALIAS (varchar(128))) */
    row.setColumn(SYSALIASES_ALIAS, new SQLVarchar(aliasName));
    //    System.out.println(" added row-- " + aliasName);


    /* 3rd column is SCHEMAID (UUID - char(36)) */
    row.setColumn(SYSALIASES_SCHEMAID, new SQLChar(schemaID));


    /* 4th column is JAVACLASSNAME (longvarchar) */
    row.setColumn(SYSALIASES_JAVACLASSNAME, dvf.getLongvarcharDataValue(javaClassName));


    /* 5th column is ALIASTYPE (char(1)) */
    row.setColumn(SYSALIASES_ALIASTYPE, new SQLChar(sAliasType));


    /* 6th column is NAMESPACE (char(1)) */
    String sNameSpace = new String(new char[] { cNameSpace });


    row.setColumn
      (SYSALIASES_NAMESPACE, new SQLChar(sNameSpace));




    /* 7th column is SYSTEMALIAS (boolean) */
    row.setColumn
      (SYSALIASES_SYSTEMALIAS, dvf.getDataValue(systemAlias));


    /* 8th column is ALIASINFO (org.apache.derby.catalog.AliasInfo) */
    row.setColumn(SYSALIASES_ALIASINFO, 
      dvf.getDataValue(aliasInfo));


    /* 9th column is specific name */
    row.setColumn
      (SYSALIASES_SPECIFIC_NAME, new SQLVarchar(specificName));




    return row;
  }

View Full Code Here


    /* 1st column is REFERENCEID (UUID - char(36)) */
    row.setColumn(SYSCOLUMNS_REFERENCEID, new SQLChar(tabID));


    /* 2nd column is COLUMNNAME (varchar(128)) */
    row.setColumn(SYSCOLUMNS_COLUMNNAME, new SQLVarchar(colName));


    /* 3rd column is COLUMNNUMBER (int) */
    row.setColumn(SYSCOLUMNS_COLUMNNUMBER, new SQLInteger(colID));


    /* 4th column is COLUMNDATATYPE */

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.