Examples of org.hsqldb.navigator.RowSetNavigator

org.hsqldb.navigator.RowSetNavigator
Encapsulates navigation functionality for lists of objects. The base class provides positional navigation and checking, while the subclasses provide object retreival. @author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.9.0


            Result result = getLobCount.execute(sysLobSession);


            sysLobSession.sessionContext.pop();


            RowSetNavigator navigator = result.getNavigator();
            boolean         next      = navigator.next();


            if (!next) {
                navigator.close();


                return 0;
            }


            Object[] data = navigator.getCurrent();


            return ((Number) data[0]).intValue();
        } finally {
            writeLock.unlock();
        }

View Full Code Here

                                          session.database.sqlEnforceTDCU);
        Type[] colTypes = baseTable.getColumnTypes();
        RangeIterator it = RangeVariable.getIterator(session,
            targetRangeVariables);
        Result          resultOut          = null;
        RowSetNavigator generatedNavigator = null;


        if (generatedIndexes != null) {
            resultOut = Result.newUpdateCountResult(generatedResultMetaData,
                    0);
            generatedNavigator = resultOut.getChainedResult().getNavigator();

View Full Code Here

     */
    Result executeMergeStatement(Session session) {


        Type[]          colTypes           = baseTable.getColumnTypes();
        Result          resultOut          = null;
        RowSetNavigator generatedNavigator = null;


        if (generatedIndexes != null) {
            resultOut = Result.newUpdateCountResult(generatedResultMetaData,
                    0);
            generatedNavigator = resultOut.getChainedResult().getNavigator();

View Full Code Here

     * Multi-row insert method. Used for CREATE TABLE AS ... queries.
     */
    void insertIntoTable(Session session, Result result) {


        PersistentStore store = getRowStore(session);
        RowSetNavigator nav   = result.initialiseNavigator();


        while (nav.hasNext()) {
            Object[] data = (Object[]) nav.getNext();
            Object[] newData =
                (Object[]) ArrayUtil.resizeArrayIfDifferent(data, columnCount);


            insertData(session, store, newData);
        }

View Full Code Here

     * Used for system table inserts. No checks. No identity
     * columns.
     */
    public int insertSys(Session session, PersistentStore store, Result ins) {


        RowSetNavigator nav   = ins.getNavigator();
        int             count = 0;


        while (nav.hasNext()) {
            insertSys(session, store, (Object[]) nav.getNext());


            count++;
        }


        return count;

View Full Code Here

     * Used for subquery inserts. No checks. No identity
     * columns.
     */
    void insertResult(Session session, PersistentStore store, Result ins) {


        RowSetNavigator nav = ins.initialiseNavigator();


        while (nav.hasNext()) {
            Object[] data = (Object[]) nav.getNext();
            Object[] newData =
                (Object[]) ArrayUtil.resizeArrayIfDifferent(data, columnCount);


            insertData(session, store, newData);
        }

View Full Code Here

        return result;
    }


    public static Result newResult(int type) {


        RowSetNavigator navigator = null;
        Result          result    = null;


        switch (type) {


            case ResultConstants.CALL_RESPONSE :

View Full Code Here

    }


    Result getDataResultSlice(long id, int offset, int count) {


        Result          result = (Result) resultMap.get(id);
        RowSetNavigator source = result.getNavigator();


        if (offset + count > source.getSize()) {
            count = source.getSize() - offset;
        }


        return Result.newDataRowsResult(result, offset, count);
    }

View Full Code Here

    }


    RowSetNavigatorClient getRowSetSlice(long id, int offset, int count) {


        Result          result = (Result) resultMap.get(id);
        RowSetNavigator source = result.getNavigator();


        if (offset + count > source.getSize()) {
            count = source.getSize() - offset;
        }


        return new RowSetNavigatorClient(source, offset, count);
    }

View Full Code Here

        }
    }


    public void registerLobForResult(Result result) {


        RowSetNavigator navigator = result.getNavigator();


        if (navigator == null) {
            registerLobsForRow((Object[]) result.valueData);
        } else {
            while (navigator.next()) {
                Object[] data = navigator.getCurrent();


                registerLobsForRow(data);
            }


            navigator.reset();
        }


        resultLobs.clear();
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.navigator.RowSetNavigator

org.hsqldb.ExpressionTable

org.hsqldb.jdbc.JDBCPreparedStatement

org.hsqldb.jdbc.JDBCResultSet

org.hsqldb.jdbc.JDBCStatement

org.hsqldb.persist.LobManager

org.hsqldb.result.Result

org.hsqldb.scriptio.ScriptReaderBinary

org.hsqldb.scriptio.ScriptWriterBase

org.hsqldb.server.ServerConnection

org.hsqldb.Session

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.