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(SYSDEPENDS_COLUMN_COUNT);


    /* 1st column is DEPENDENTID (UUID - char(36)) */
    row.setColumn(SYSDEPENDS_DEPENDENTID, new SQLChar(dependentID));


    /* 2nd column is DEPENDENTFINDER */
    row.setColumn(SYSDEPENDS_DEPENDENTTYPE,
        dvf.getDataValue(dependentBloodhound));


    /* 3rd column is PROVIDERID (UUID - char(36)) */
    row.setColumn(SYSDEPENDS_PROVIDERID, new SQLChar(providerID));


    /* 4th column is PROVIDERFINDER */
    row.setColumn(SYSDEPENDS_PROVIDERTYPE,
        dvf.getDataValue(providerBloodhound));

View Full Code Here


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


    /* 1st column is SCHEMAID (UUID - char(36)) */
    row.setColumn(1, new SQLChar(schemaID));


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


    /* 3rd column is CONGLOMERATENUMBER (long) */
    row.setColumn(3, dvf.getDataValue(conglomNumber));


    /* 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
    *  (user type org.apache.derby.catalog.IndexDescriptor)
    */
    row.setColumn(6,
      dvf.getDataValue(
            (indexRowGenerator == null ?
              (IndexDescriptor) null :
              indexRowGenerator.getIndexDescriptor()
            )
          )
        );


    /* 7th column is ISCONSTRAINT (boolean) */
    row.setColumn(7, dvf.getDataValue(supportsConstraint));


    /* 8th column is CONGLOMERATEID (UUID - char(36)) */
    row.setColumn(8, new SQLChar(conglomUUIDString));


    return row;
  }

View Full Code Here

            updatePriv = tpd.getUpdatePriv();
            referencesPriv = tpd.getReferencesPriv();
            triggerPriv = tpd.getTriggerPriv();
        }
        ExecRow row = getExecutionFactory().getValueRow( COLUMN_COUNT);
        row.setColumn( TABLEPERMSID_COL_NUM, new SQLChar(tablePermID));
        row.setColumn( GRANTEE_COL_NUM, grantee);
        row.setColumn( GRANTOR_COL_NUM, grantor);
        row.setColumn( TABLEID_COL_NUM, new SQLChar(tableID));
        row.setColumn( SELECTPRIV_COL_NUM, new SQLChar(selectPriv));
        row.setColumn( DELETEPRIV_COL_NUM, new SQLChar(deletePriv));
        row.setColumn( INSERTPRIV_COL_NUM, new SQLChar(insertPriv));
        row.setColumn( UPDATEPRIV_COL_NUM, new SQLChar(updatePriv));
        row.setColumn( REFERENCESPRIV_COL_NUM, new SQLChar( referencesPriv));
        row.setColumn( TRIGGERPRIV_COL_NUM, new SQLChar(triggerPriv));


        return row;
    } // end of makeRow

View Full Code Here

            // checking permissions, or add a grantor column to the key, which is necessary for granting or revoking
            // permissions.
            row = getExecutionFactory().getIndexableRow( 2);
            row.setColumn(1, getAuthorizationID( perm.getGrantee()));
            String tableUUIDStr = ((TablePermsDescriptor) perm).getTableUUID().toString();
            row.setColumn(2, new SQLChar(tableUUIDStr));
            break;
        case TABLEPERMSID_INDEX_NUM:
            row = getExecutionFactory().getIndexableRow( 1);
            String tablePermsUUIDStr = perm.getObjectID().toString();
            row.setColumn(1, new SQLChar(tablePermsUUIDStr));
            break;
        case TABLEID_INDEX_NUM:
            row = getExecutionFactory().getIndexableRow( 1);
            tableUUIDStr = ((TablePermsDescriptor) perm).getTableUUID().toString();
            row.setColumn(1, new SQLChar(tableUUIDStr));
            break;
        }
        return row;
    } // end of buildIndexRow

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

    TabInfoImpl            ti = coreInfo[SYSTABLES_CORE_NUM];


    /* Use tableNameOrderable and schemaIdOrderable 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

    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

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.