Examples of DataValueDescriptor

org.apache.derby.iapi.types.DataValueDescriptor
The DataValueDescriptor interface provides methods to get the data from a column returned by a statement.
This interface matches the getXXX methods on java.sql.ResultSet. This means everyone satisfies getString and getObject; all of the numeric types, within the limits of representation, satisfy all of the numeric getXXX methods; all of the character types satisfy all of the getXXX methods except getBytes and getBinaryStream; all of the binary types satisfy getBytes and all of the getXXXStream methods; Date satisfies getDate and getTimestamp; Time satisfies getTime; and Timestamp satisfies all of the date/time getXXX methods. The "preferred" method (one that will always work, I presume) is the one that matches the type most closely. See the comments below for "preferences". See the JDBC guide for details.
This interface does not include the getXXXStream methods.
The preferred methods for JDBC are:
CHAR and VARCHAR - getString()
BIT - getBoolean()
TINYINT - getByte()
SMALLINT - getShort()
INTEGER - getInt()
BIGINT - getLong()
REAL - getFloat()
FLOAT and DOUBLE - getDouble()
DECIMAL and NUMERIC - getBigDecimal()
BINARY and VARBINARY - getBytes()
DATE - getDate()
TIME - getTime()
TIMESTAMP - getTimestamp()
No JDBC type corresponds to getObject(). Use this for user-defined types or to get the JDBC types as java Objects. All primitive types will be wrapped in their corresponding Object type, i.e. int will be wrapped in an Integer.
getStream()

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

     */
    if (tableScan.lastCursorKey == null)
      tableScan.lastCursorKey = new ValueRow(aRow.nColumns() - 1);
    for (int i = 1; i <= tableScan.lastCursorKey.nColumns(); i++)
    {
      DataValueDescriptor aCol = aRow.getColumn(i);
      if (aCol != null)
        tableScan.lastCursorKey.setColumn(i, aCol.getClone());
    }
  }

View Full Code Here

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


          /* 
          ** The last column is a Ref, which contains a 
          ** RowLocation.
          */
          DataValueDescriptor rlColumn = deferredTempRow2.getColumn(numberOfBaseColumns + 1);
          RowLocation baseRowLocation = 
              (RowLocation) (rlColumn).getObject();
  
          /* Get the base row at the given RowLocation */
          boolean row_exists =

View Full Code Here

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

    throws StandardException
  {
    ExecRow        scanRow;
    boolean        foundMatch = false;
    Object[]       checkRowArray = checkRow.getRowArray();
    DataValueDescriptor  checkCol;
    DataValueDescriptor  scanCol;


    CursorResultSet rs = rowHolder.getResultSet();
    try
    {  
      /*

View Full Code Here

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

  public ExecRow  getNextRowCore() throws StandardException
  {
      ExecRow result = null;
    boolean haveRow = false;
      boolean restrict = false;
      DataValueDescriptor restrictBoolean;


    beginTime = getCurrentTimeMillis();
    if (! isOpen)
      throw StandardException.newException(SQLState.LANG_RESULT_SET_NOT_OPEN, "next");


    /* Close right and advance left if we found no match
     * on right on last next().
     */
    if (returnedEmptyRight)
    {
      /* Current scan on right is exhausted.  Need to close old scan 
       * and open new scan with new "parameters".  openRight will
        * reopen the scan.
       */
      leftRow = leftResultSet.getNextRowCore();
      if (leftRow == null)
      {
        closeRight();
      }
      else
      {
        rowsSeenLeft++;
        openRight();
      }
      returnedEmptyRight = false;
    }


    while (leftRow != null && !haveRow)
    {
      rightRow = rightResultSet.getNextRowCore();


      if (rightRow == null)
      {
        /* If we haven't found a match on the right, then
         * we join the left with a row of nulls from the
         * right.
         */
        if (! matchRight)
        {
          haveRow = true;
          returnedEmptyRight = true;
          if (rightEmptyRow == null)
          {
            rightEmptyRow = (ExecRow) emptyRowFun.invoke(activation);
          }


          getMergedRow(leftRow, rightEmptyRow);
          emptyRightRowsReturned++;
          continue;
        }


        /* Current scan on right is exhausted.  Need to close old scan 
         * and open new scan with new "parameters".  openRight()
         * will reopen the scan.
         */
        matchRight = false;
        leftRow = leftResultSet.getNextRowCore();
        if (leftRow == null)
        {
          closeRight();
        }
        else
        {
          rowsSeenLeft++;
          openRight();
        }
      }
      else
      {
        rowsSeenRight++;


        if (restriction != null)
        {
          restrictBoolean =
            (DataValueDescriptor) restriction.invoke(activation);


              // if the result is null, we make it false --
          // so the row won't be returned.
          restrict = (! restrictBoolean.isNull()) &&
                  restrictBoolean.getBoolean();


          if (! restrict)
          {
            /* Update the run time statistics */
            rowsFiltered++;

View Full Code Here

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

         * because that method will increment probeValIndex.
         */
        if (probeValIndex == 0)
            rowsThisScan = 0;


        DataValueDescriptor pv = null;
        if (moreInListVals())
        {
            pv = getNextProbeValue();
            if (pv == null)
            {

View Full Code Here

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

  private boolean filterRow(ExecRow currRow, ExecRow newRow)
    throws StandardException
  {
    for (int index = 1; index <= numColumns; index++)
    {
      DataValueDescriptor currOrderable = currRow.getColumn(index);
      DataValueDescriptor newOrderable = newRow.getColumn(index);
      if (! (currOrderable.compare(DataValueDescriptor.ORDER_OP_EQUALS, newOrderable, true, true)))
      {
        return false;
      }
    }

View Full Code Here

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

      SanityManager.ASSERT(addend instanceof OrderableAggregator,
        "addend is supposed to be the same type of aggregator for the merge operator");
    }


    // Don't bother merging if the other has never been used.
    DataValueDescriptor bv = ((OrderableAggregator)addend).value;
    if (bv != null)
      this.accumulate(bv);
  }

View Full Code Here

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

   */
  public ExecRow getCurrentRow() throws StandardException {
      ExecRow candidateRow = null;
      ExecRow result = null;
      boolean restrict = false;
      DataValueDescriptor restrictBoolean;


    if (SanityManager.DEBUG)
      SanityManager.ASSERT(isOpen, "PRRS is expected to be open");


    /* Nothing to do if we're not currently on a row */
    if (currentRow == null)
    {
      return null;
    }


    /* Call the child result set to get it's current row.
     * If no row exists, then return null, else requalify it
     * before returning.
     */
    candidateRow = ((CursorResultSet) source).getCurrentRow();
    if (candidateRow != null) {
      setCurrentRow(candidateRow);
        /* If restriction is null, then all rows qualify */
            restrictBoolean = (DataValueDescriptor) 
          ((singleTableRestriction == null) ? null : singleTableRestriction.invoke(activation));


            // if the result is null, we make it false --
      // so the row won't be returned.
            restrict = (restrictBoolean == null) ||
            ((! restrictBoolean.isNull()) &&
              restrictBoolean.getBoolean());
    }


      if (candidateRow != null && restrict) 
    {
      result = doProjection(candidateRow);

View Full Code Here

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

     * hash table.
     */
     while (execRow != null)
    {
        boolean restrict = false;
        DataValueDescriptor restrictBoolean;


      rowsSeen++;


      /* If restriction is null, then all rows qualify */
            restrictBoolean = (DataValueDescriptor) 
          ((singleTableRestriction == null) ? null : singleTableRestriction.invoke(activation));


            // if the result is null, we make it false --
      // so the row won't be returned.
            restrict = (restrictBoolean == null) ||
            ((! restrictBoolean.isNull()) &&
              restrictBoolean.getBoolean());
      if (!restrict)
      {
        execRow = source.getNextRowCore();
        continue;
      }

View Full Code Here

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

                            // For hashing only use the AND qualifiers 
                            // located in nextQualifiers[0][0...N], OR 
                            // qualifiers are checked down a bit by calling
                            // qualifyRow on rows returned from hash.


                            DataValueDescriptor dvd = 
                                nextQualifiers[0][index].getOrderable();


                            if (dvd == null)
                            {
                                mh = null;

View Full Code Here

0 1 2 3 4 5

TOP

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.