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 SCHEMAID */
    row.setColumn(1, new SQLChar(uuid));


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


    /* 3rd column is SCHEMAAID */
    row.setColumn(3, new SQLVarchar(aid));


    return row;
  }

View Full Code Here


    /* 2nd column is TABLEID (UUID - char(36)) */
    row.setColumn(SYSCONSTRAINTS_TABLEID, new SQLChar(tableID));


    /* 3rd column is NAME (varchar(128)) */
    row.setColumn(SYSCONSTRAINTS_CONSTRAINTNAME, new SQLVarchar(constraintName));


    /* 4th column is TYPE (char(1)) */
    row.setColumn(SYSCONSTRAINTS_TYPE, new SQLChar(constraintSType));


    /* 5th column is SCHEMAID (UUID - char(36)) */

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

    /* 4th column is CONGLOMERATENAME (varchar(128)) 
    ** If null, use the tableid so we always
    ** have a unique column
    */
    row.setColumn(4, (conglomName == null) ?
                new SQLVarchar(tabID): new SQLVarchar(conglomName));


    /* 5th  column is ISINDEX (boolean) */
    row.setColumn(5, dvf.getDataValue(supportsIndex));


    /* 6th column is DESCRIPTOR

View Full Code Here


    /* 1st column is STMTID */
    row.setColumn(1, new SQLChar(uuidStr));


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


    /* 3rd column is SCHEMAID */
    row.setColumn(3, new SQLChar(suuidStr));


    /* 4th column is TYPE */

View Full Code 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

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.