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.

    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

    DataValueDescriptor    UUIDStringOrderable;
    DataValueDescriptor    constraintNameOrderable;
    TabInfoImpl          ti = getNonCoreTI(SYSCONSTRAINTS_CATALOG_NUM);


    /* Construct keys for both start and stop positions for scan */
    constraintNameOrderable = new SQLVarchar(constraintName);
    UUIDStringOrderable = getIDValueAsCHAR(schemaID);


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

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

        super(uuidf,ef,dvf,convertIdToLower);
    }


    DataValueDescriptor getAuthorizationID( String value)
    {
        return new SQLVarchar(value);
    }

View Full Code Here

        return new SQLVarchar(value);
    }


    DataValueDescriptor getNullAuthorizationID()
    {
        return new SQLVarchar();
    }

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 TABLEID (UUID - char(36)) */
    row.setColumn(SYSTABLES_TABLEID, new SQLChar(tableID));


    /* 2nd column is NAME (varchar(30)) */
    row.setColumn(SYSTABLES_TABLENAME, new SQLVarchar(tableName));


    /* 3rd column is TABLETYPE (char(1)) */
    row.setColumn(SYSTABLES_TABLETYPE, new SQLChar(tabSType));


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

View Full Code Here


    switch( indexNumber )
    {
        case SYSTABLES_INDEX1_ID:
        /* 1st column is TABLENAME (varchar(128)) */
        row.setColumn(1, new SQLVarchar());


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


        break;

View Full Code 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, new SQLTimestamp(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, new UserType(rcd));


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


    /* 14th column is REFERENCINGOLD */
    row.setColumn(14, new SQLBoolean(referencingOld));


    /* 15th column is REFERENCINGNEW */
    row.setColumn(15, new SQLBoolean(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

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.