Examples of org.hsqldb.navigator.RowIterator

org.hsqldb.navigator.RowIterator
@author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.7.2

    public void changeToDiskTable() {


        cache = session.sessionData.getResultCache();


        if (cache != null) {
            RowIterator iterator = table.rowIterator(this);


            ArrayUtil.fillArray(accessorList, null);


            isCached = true;


            cache.storeCount++;


            while (iterator.hasNext()) {
                Row row    = iterator.getNextRow();
                Row newRow = (Row) getNewCachedObject(session, row.getData());


                indexRow(null, newRow);
                row.destroy();
            }

View Full Code Here


        pointerLookup.setKeysSearchTarget();
        Error.printSystemOut("lookup begins: " + stopw.elapsedTime());


        // all rows
        RowIterator it = table.rowIterator(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            pointerLookup.addUnsorted(row.getPos(), (int) (pos / scale));


            if (count % 50000 == 0) {
                Error.printSystemOut("pointer pair for row " + count + " "
                                     + row.getPos() + " " + pos);
            }


            pos += row.getStorageSize();
        }


        Error.printSystemOut("table: " + table.getName().name + " list done: "
                             + stopw.elapsedTime());


        count = 0;
        it    = table.rowIterator(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            rowOut.reset();
            row.write(rowOut, pointerLookup);
            fileStreamOut.write(rowOut.getOutputStream().getBuffer(), 0,
                                rowOut.size());

View Full Code Here

        int count = 0;


        readLock.lock();


        try {
            RowIterator it = firstRow(session, store);


            while (it.hasNext()) {
                it.getNextRow();


                count++;
            }


            return count;

View Full Code Here

    }


    //
    public final void indexRows() {


        RowIterator it = rowIterator();


        for (int i = 1; i < indexList.length; i++) {
            setAccessor(indexList[i], null);
        }


        while (it.hasNext()) {
            Row row = it.getNextRow();


            ((RowAVL) row).clearNonPrimaryNodes();


            for (int i = 1; i < indexList.length; i++) {
                indexList[i].insert(null, this, row);

View Full Code Here


        if (adjust <= 0 && colindex != -1) {
            oldtype = ((Table) other.getTable()).getColumnTypes()[colindex];
        }


        RowIterator it    = other.rowIterator();
        Table       table = (Table) this.table;


        try {
            while (it.hasNext()) {
                Row      row      = it.getNextRow();
                Object[] olddata  = row.getData();
                Object[] data     = table.getEmptyRowData();
                Object   oldvalue = null;


                if (adjust == 0 && colindex != -1) {

View Full Code Here


    public void unlock() {}


    void dropIndexFromRows(Index primaryIndex, Index oldIndex) {


        RowIterator it       = primaryIndex.firstRow(this);
        int         position = oldIndex.getPosition() - 1;


        while (it.hasNext()) {
            Row     row      = it.getNextRow();
            int     i        = position - 1;
            NodeAVL backnode = ((RowAVL) row).getNode(0);


            while (i-- > 0) {
                backnode = backnode.nNext;

View Full Code Here

    }


    boolean insertIndexNodes(Index primaryIndex, Index newIndex) {


        int           position = newIndex.getPosition();
        RowIterator   it       = primaryIndex.firstRow(this);
        int           rowCount = 0;
        HsqlException error    = null;


        try {
            while (it.hasNext()) {
                Row row = it.getNextRow();


                ((RowAVL) row).insertNode(position);


                // count before inserting
                rowCount++;


                newIndex.insert(null, this, row);
            }


            return true;
        } catch (java.lang.OutOfMemoryError e) {
            error = Error.error(ErrorCode.OUT_OF_MEMORY);
        } catch (HsqlException e) {
            error = e;
        }


        // backtrack on error
        // rowCount rows have been modified
        it = primaryIndex.firstRow(this);


        for (int i = 0; i < rowCount; i++) {
            Row     row      = it.getNextRow();
            NodeAVL backnode = ((RowAVL) row).getNode(0);
            int     j        = position;


            while (--j > 0) {
                backnode = backnode.nNext;

View Full Code Here

     */
    void reindex(Session session, Index index) {


        setAccessor(index, null);


        RowIterator it = table.rowIterator(this);


        while (it.hasNext()) {
            Row row = it.getNextRow();


            // may need to clear the node before insert
            index.insert(session, this, row);
        }
    }

View Full Code Here

        database.schemaManager.recompileDependentObjects(tableSet);
        database.schemaManager.recompileDependentObjects(tn);
        tn.compile(session, null);


        if (column.getDataType().isLobType()) {
            RowIterator it = table.rowIterator(session);


            while (it.hasNext()) {
                Row      row  = it.getNextRow();
                Object[] data = row.getData();


                if (data[colIndex] != null) {
                    session.sessionData.adjustLobUsageCount(data[colIndex],
                            -1);

View Full Code Here

     * @param newCol Column
     */
    void checkConvertColDataType(ColumnSchema oldCol, ColumnSchema newCol) {


        int         colIndex = table.getColumnIndex(oldCol.getName().name);
        RowIterator it       = table.rowIterator(session);


        while (it.hasNext()) {
            Row    row = it.getNextRow();
            Object o   = row.getData()[colIndex];


            newCol.getDataType().convertToType(session, o,
                                               oldCol.getDataType());
        }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.navigator.RowIterator

org.hsqldb.Constraint

org.hsqldb.ExpressionLogical

org.hsqldb.index.IndexAVL

org.hsqldb.persist.DataFileDefrag

org.hsqldb.persist.RowStoreAVL

org.hsqldb.persist.RowStoreAVLDisk

org.hsqldb.persist.RowStoreAVLHybrid

org.hsqldb.persist.RowStoreAVLHybridExtended

org.hsqldb.persist.RowStoreAVLMemory

org.hsqldb.RangeVariable$FullRangeIterator

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.