Examples of 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
org.hsqldb_voltpatches.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

Examples of org.hsqldb.navigator.RowSetNavigator

        return result;
    }


    public static Result newResult(int type) {


        RowSetNavigator navigator = null;
        Result          result    = null;


        switch (type) {


            case ResultConstants.CALL_RESPONSE :

View Full Code Here

Examples of org.hsqldb.navigator.RowSetNavigator

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


        PersistentStore store = session.sessionData.getRowStore(this);
        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

Examples of org.hsqldb.navigator.RowSetNavigator

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


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


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


            count++;
        }


        return count;

View Full Code Here

Examples of org.hsqldb.navigator.RowSetNavigator

     * 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

Examples of org.hsqldb.navigator.RowSetNavigator

            return Result.newErrorResult(Error.error(ErrorCode.X_07501));
        }


        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

Examples of org.hsqldb.navigator.RowSetNavigator

        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, ResultProperties.defaultPropsValue);

View Full Code Here

Examples of org.hsqldb.navigator.RowSetNavigator

     * @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

Examples of org.hsqldb.navigator.RowSetNavigator

        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

Examples of org.hsqldb.navigator.RowSetNavigator

    }


    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

Examples of org.hsqldb.navigator.RowSetNavigator

        }
    }


    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

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.