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

org.apache.derby.iapi.types.SQLChar
The SQLChar represents a CHAR value with UCS_BASIC collation. SQLChar may be used directly by any code when it is guaranteed that the required collation is UCS_BASIC, e.g. system columns.
The state may be in char[], a String, a Clob, or an unread stream, depending on how the datatype was created.
Stream notes:
When the datatype comes from the database layer and the length of the bytes necessary to store the datatype on disk exceeds the size of a page of the container holding the data then the store returns a stream rather than reading all the bytes into a char[] or String. The hope is that the usual usage case is that data never need be expanded in the derby layer, and that client can just be given a stream that can be read a char at a time through the jdbc layer. Even though SQLchar's can't ever be this big, this code is shared by all the various character datatypes including SQLClob which is expected to usually larger than a page.
The state can also be a stream in the case of insert/update where the client has used a jdbc interface to set the value as a stream rather than char[]. In this case the hope is that the usual usage case is that stream never need be read until it is passed to store, read once, and inserted into the database.


    /* Build the row to insert */
    row = getExecutionFactory().getValueRow(SYSTRIGGERS_COLUMN_COUNT);


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

View Full Code Here


    /* 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);
    keyRow.setColumn(2, schemaIDOrderable);

View Full Code Here

    TableDescriptor        td;
    TabInfoImpl            ti = coreInfo[SYSTABLES_CORE_NUM];


    /* Use tableIDOrderable in both start and stop position for scan.
     */
    tableIDOrderable = new SQLChar(tableUUID);


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

View Full Code Here

        throws StandardException
    {
    TabInfoImpl          ti = getNonCoreTI(SYSALIASES_CATALOG_NUM);
    ExecIndexRow         keyRow = exFactory.getIndexableRow(3);
    DataValueDescriptor  aliasNameOrderable = new SQLVarchar( "CLOBGETSUBSTRING" );;
    DataValueDescriptor   nameSpaceOrderable = new SQLChar
            ( new String( new char[] { AliasInfo.ALIAS_TYPE_FUNCTION_AS_CHAR } ) );
        
    keyRow.setColumn(1, new SQLChar( SchemaDescriptor.SYSIBM_SCHEMA_UUID ));
    keyRow.setColumn(2, aliasNameOrderable);
    keyRow.setColumn(3, nameSpaceOrderable);


        AliasDescriptor      oldAD = (AliasDescriptor) getDescriptorViaIndex
            (

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

    TabInfoImpl            ti = getNonCoreTI(SYSSTATEMENTS_CATALOG_NUM);


    /* Use stmtIdOrderable in both start 
     * and stop position for scan. 
     */
    stmtIDOrderable = new SQLChar(stmtUUID);


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

View Full Code Here


    /* 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);
    keyRow.setColumn(2, schemaIDOrderable);

View Full Code Here

              new DataValueDescriptor[SYSCONSTRAINTSRowFactory.SYSCONSTRAINTS_COLUMN_COUNT];
      FormatableBitSet  columnToGetSet = 
              new FormatableBitSet(SYSCONSTRAINTSRowFactory.SYSCONSTRAINTS_COLUMN_COUNT);
      columnToGetSet.set(columnNum - 1);


      rowTemplate[columnNum - 1] = new SQLChar();
  
      // Scan the index and go to the data pages for qualifying rows 
      scanController = tc.openScan(
          ti.getIndexConglomerate(indexId),// conglomerate to open
          false,               // don't hold open across commit

View Full Code Here

    List          ddlList = newSList();
    DataValueDescriptor    dependentIDOrderable;
    TabInfoImpl          ti = getNonCoreTI(SYSDEPENDS_CATALOG_NUM);


    /* Use dependentIDOrderable in both start and stop positions for scan */
    dependentIDOrderable = new SQLChar(dependentID);


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

View Full Code Here

    List          ddlList = newSList();
    DataValueDescriptor    providerIDOrderable;
    TabInfoImpl          ti = getNonCoreTI(SYSDEPENDS_CATALOG_NUM);


    /* Use providerIDOrderable in both start and stop positions for scan */
    providerIDOrderable = new SQLChar(providerID);


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

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

org.apache.derby.iapi.db.DatabaseContext

org.apache.derby.iapi.services.io.CounterOutputStream

org.apache.derby.iapi.services.io.FormatIdInputStream

org.apache.derby.iapi.services.io.FormatIdOutputStream

org.apache.derby.iapi.sql.conn.StatementContext

org.apache.derby.iapi.types.SQLDate

org.apache.derby.iapi.types.SQLInteger

org.apache.derby.iapi.types.SQLTime

org.apache.derby.iapi.types.SQLTimestamp

org.apache.derby.iapi.types.StringDataValue

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.