Examples of org.hsqldb_voltpatches.navigator.RowSetNavigator

Package org.hsqldb_voltpatches.navigator

Examples of org.hsqldb_voltpatches.navigator.RowSetNavigator

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

        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 getResult(Session session) {


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


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


        RowSetNavigator newDataNavigator = queryExpression == null
                                           ? getInsertValuesNavigator(session)
                                           : getInsertSelectNavigator(session);
        Expression        checkCondition = null;
        RangeIteratorBase checkIterator  = null;


        if (targetTable != baseTable) {
            QuerySpecification select =
                ((TableDerived) targetTable).getQueryExpression()
                    .getMainSelect();


            checkCondition = select.checkQueryCondition;


            if (checkCondition != null) {
                checkIterator = select.rangeVariables[0].getIterator(session);
            }
        }


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


            if (checkCondition != null) {
                checkIterator.currentData = data;


                boolean check = checkCondition.testCondition(session);


                if (!check) {
                    throw Error.error(ErrorCode.X_44000);
                }
            }


            table.insertRow(session, store, data);


            if (generatedNavigator != null) {
                Object[] generatedValues = getGeneratedColumns(data);


                generatedNavigator.add(generatedValues);
            }
        }


        newDataNavigator.beforeFirst();
        table.fireAfterTriggers(session, Trigger.INSERT_AFTER,
                                newDataNavigator);


        if (resultOut == null) {
            resultOut =
                Result.getUpdateCountResult(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];
                Type sourceType = sourceTypes[i];

View Full Code Here

        }
    }


    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


        Result r = Result.newResult(dataStreamIn, rowIn);


        r.readAdditionalResults(session, dataStreamIn, rowIn);


        RowSetNavigator nav = r.initialiseNavigator();


        while (nav.hasNext()) {
            Object[] data   = (Object[]) nav.getNext();
            String   s      = (String) data[0];
            Result   result = session.executeDirectStatement(s);


            if (result.isError()) {
                db.logger.appLog.logContext(SimpleLog.LOG_ERROR,

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();


        while (navigator.next()) {
            Object[] data = navigator.getCurrent();


            for (int i = 0; i < data.length; i++) {
                if (data[i] instanceof BlobData) {
                    BlobData blob = (BlobData) data[i];
                    long     id   = resultLobs.get(blob.getId());


                    data[i] = database.lobManager.getBlob(session, id);
                } else if (data[i] instanceof ClobData) {
                    ClobData clob = (ClobData) data[i];
                    long     id   = resultLobs.get(clob.getId());


                    data[i] = database.lobManager.getClob(session, id);
                }
            }
        }


        resultLobs.clear();
        navigator.reset();
    }

View Full Code Here

     * 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,
                    getColumnCount());


            insertData(store, newData);

View Full Code Here

     * 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

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


        RowSetNavigator nav = ins.initialiseNavigator();


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


            insertData(store, newData);

View Full Code Here

0 1

TOP

Related Classes of org.hsqldb_voltpatches.navigator.RowSetNavigator

org.hsqldb_voltpatches.jdbc.JDBCPreparedStatement

org.hsqldb_voltpatches.jdbc.JDBCResultSet

org.hsqldb_voltpatches.jdbc.JDBCStatement

org.hsqldb_voltpatches.persist.LobManager

org.hsqldb_voltpatches.result.Result

org.hsqldb_voltpatches.scriptio.ScriptReaderBinary

org.hsqldb_voltpatches.scriptio.ScriptWriterBase

org.hsqldb_voltpatches.Session

org.hsqldb_voltpatches.SessionData

org.hsqldb_voltpatches.StatementDML

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.