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);
        int             count;


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


        count = newDataNavigator.getSize();


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

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


        if (resultIn.isError()) {
            throw Util.sqlException(resultIn);
        }


        RowSetNavigator navigator    = resultIn.getNavigator();
        int[]           updateCounts = new int[navigator.getSize()];


        for (int i = 0; i < updateCounts.length; i++) {
            Object[] data = navigator.getNext();


            updateCounts[i] = ((Integer) data[0]).intValue();
        }


        if (updateCounts.length != batchCount) {

View Full Code Here


        if (resultIn.isError()) {
            throw Util.sqlException(resultIn);
        }


        RowSetNavigator navigator    = resultIn.getNavigator();
        int[]           updateCounts = new int[navigator.getSize()];


        for (int i = 0; i < updateCounts.length; i++) {
            Object[] data = navigator.getNext();


            updateCounts[i] = ((Integer) data[0]).intValue();
        }


        if (updateCounts.length != batchCount) {

View Full Code Here

     *   available.
     * @return Object[]
     */
    private Object[] getCurrent() throws SQLException {


        final RowSetNavigator lnavigator = this.navigator;


        if (lnavigator == null) {
            throw Util.sqlException(ErrorCode.X_24501);
        } else if (lnavigator.isEmpty()) {
            throw Util.sqlException(ErrorCode.X_24504, ErrorCode.M_RS_EMPTY);
        } else if (lnavigator.isBeforeFirst()) {
            throw Util.sqlException(ErrorCode.X_24504,
                                    ErrorCode.M_RS_BEFORE_FIRST);
        } else if (lnavigator.isAfterLast()) {
            throw Util.sqlException(ErrorCode.X_24504,
                                    ErrorCode.M_RS_AFTER_LAST);
        }


        Object[] data = lnavigator.getCurrent();


        if (data == null) {
            throw Util.sqlException(ErrorCode.X_24501);
        }

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

     * 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

            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;


        isBatch = true;


        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

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.