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

     * @return the result of executing the statement
     */
    Result getResult(Session session) {


        Result          resultOut          = null;
        RowSetNavigator generatedNavigator = null;
        PersistentStore store              = baseTable.getRowStore(session);


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


        if (isSimpleInsert) {
            Type[] colTypes = baseTable.getColumnTypes();
            Object[] data = getInsertData(session, colTypes,
                                          insertExpression.nodes[0].nodes);


            return insertSingleRow(session, store, data);
        }


        RowSetNavigator newDataNavigator = queryExpression == null
                                           ? getInsertValuesNavigator(session)
                                           : getInsertSelectNavigator(session);


        if (newDataNavigator.getSize() > 0) {
            insertRowSet(session, generatedNavigator, newDataNavigator);
        }


        if (baseTable.triggerLists[Trigger.INSERT_AFTER].length > 0) {
            baseTable.fireTriggers(session, Trigger.INSERT_AFTER,
                                   newDataNavigator);
        }


        if (resultOut == null) {
            resultOut = new Result(ResultConstants.UPDATECOUNT,
                                   newDataNavigator.getSize());
        } else {
            resultOut.setUpdateCount(newDataNavigator.getSize());
        }


        return resultOut;
    }

View Full Code Here

        Type[] colTypes  = baseTable.getColumnTypes();
        int[]  columnMap = insertColumnMap;


        //
        Result                result = queryExpression.getResult(session, 0);
        RowSetNavigator       nav         = result.initialiseNavigator();
        Type[]                sourceTypes = result.metaData.columnTypes;
        RowSetNavigatorClient newData     = new RowSetNavigatorClient(2);


        while (nav.hasNext()) {
            Object[] data       = baseTable.getNewRowData(session);
            Object[] sourceData = (Object[]) nav.getNext();


            for (int i = 0; i < columnMap.length; i++) {
                int j = columnMap[i];


                if (j == this.overrideUserValue) {

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


    protected void writeTableTerm(Table t) throws IOException {}


    protected void writeSingleColumnResult(Result r) throws IOException {


        RowSetNavigator nav = r.initialiseNavigator();


        while (nav.hasNext()) {
            Object[] data = (Object[]) nav.getNext();


            writeLogStatement(currentSession, (String) data[0]);
        }
    }

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

            }
        }


        count = 0;


        RowSetNavigator nav = cmd.initialiseNavigator();


        updateCounts = new int[nav.getSize()];


        Result generatedResult = null;


        if (cs.hasGeneratedColumns()) {
            generatedResult =
                Result.newDataResult(cs.generatedResultMetaData());
        }


        Result error = null;


        while (nav.hasNext()) {
            Object[] pvals = (Object[]) nav.getNext();
            Result   in    = executeCompiledStatement(cs, pvals);


            // On the client side, iterate over the vals and throw
            // a BatchUpdateException if a batch status value of
            // esultConstants.EXECUTE_FAILED is encountered in the result
            if (in.isUpdateCount()) {
                if (cs.hasGeneratedColumns()) {
                    RowSetNavigator navgen =
                        in.getChainedResult().getNavigator();


                    while (navgen.hasNext()) {
                        Object[] generatedRow = navgen.getNext();


                        generatedResult.getNavigator().add(generatedRow);
                    }
                }

View Full Code Here

        int[] updateCounts;
        int   count;


        count = 0;


        RowSetNavigator nav = cmd.initialiseNavigator();


        updateCounts = new int[nav.getSize()];


        Result error = null;


        while (nav.hasNext()) {
            Result   in;
            Object[] data = (Object[]) nav.getNext();
            String   sql  = (String) data[0];


            try {
                in = executeDirectStatement(sql);
            } catch (Throwable t) {

View Full Code Here


        if (result.isError()) {
            return 0;
        }


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


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


            return 0;
        }


        Object[] data = navigator.getCurrent();


        return ((Long) data[0]).longValue();
    }

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.