Examples of org.hsqldb.result.Result

org.hsqldb.result.Result
The primary unit of communication between Connection, Server and Session objects. An HSQLDB Result object encapsulates all requests (such as to alter or query session settings, to allocate and execute statements, etc.) and all responses (such as exception indications, update counts, result sets and result set metadata). It also implements the HSQL wire protocol for comunicating all such requests and responses across the network. Uses a navigator for data. @author Campbell Boucher-Burnett (boucherb@users dot sourceforge.net) @author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.9.0

                int  databaseID = inStream.readInt();
                long sessionID  = inStream.readLong();
                int  mode       = inStream.readByte();
                Session session = DatabaseManager.getSession(databaseID,
                    sessionID);
                Result resultIn = Result.newResult(session, mode, inStream,
                                                   rowIn);


                resultIn.setDatabaseId(databaseID);
                resultIn.setSessionId(sessionID);


                Result resultOut;


                if (resultIn.getType() == ResultConstants.CONNECT) {
                    try {
                        session = DatabaseManager.newSession(
                            dbType, dbPath, resultIn.getMainString(),
                            resultIn.getSubString(), new HsqlProperties(),
                            resultIn.getZoneString(),
                            resultIn.getUpdateCount());


                        resultIn.readAdditionalResults(null, inStream, rowIn);


                        resultOut = Result.newConnectionAcknowledgeResponse(
                            session.getDatabase(), session.getId(),
                            session.getDatabase().getDatabaseID());
                    } catch (HsqlException e) {
                        resultOut = Result.newErrorResult(e);
                    }
                } else {
                    int  dbId      = resultIn.getDatabaseId();
                    long sessionId = resultIn.getSessionId();


                    session = DatabaseManager.getSession(dbId, sessionId);


                    resultIn.readAdditionalResults(session, inStream, rowIn);


                    resultOut = session.execute(resultIn);
                }


                //
                response.setContentType("application/octet-stream");
                response.setContentLength(rowOut.size());


                //
                dataOut = new DataOutputStream(response.getOutputStream());


                resultOut.write(dataOut, rowOut);


                iQueries++;
            } catch (HsqlException e) {}
            finally {
                if (dataOut != null) {

View Full Code Here

*/
    }


    public Object[] getValues(Session session) {


        Result r    = getResult(session, 2);
        int    size = r.getNavigator().getSize();


        if (size == 0) {
            return new Object[r.metaData.getColumnCount()];
        } else if (size == 1) {
            return r.getSingleRowData();
        } else {
            throw Error.error(ErrorCode.X_21000);
        }
    }

View Full Code Here

        }
    }


    public Object[] getSingleRowValues(Session session) {


        Result r    = getResult(session, 2);
        int    size = r.getNavigator().getSize();


        if (size == 0) {
            return null;
        } else if (size == 1) {
            return r.getSingleRowData();
        } else {
            throw Error.error(ErrorCode.X_21000);
        }
    }

View Full Code Here


    Result getResult(Session session, int maxRows) {


        int    currentMaxRows = unionType == UNION_ALL ? maxRows
                                                       : 0;
        Result first = leftQueryExpression.getResult(session, currentMaxRows);
        RowSetNavigatorData navigator =
            (RowSetNavigatorData) first.getNavigator();
        Result second = rightQueryExpression.getResult(session,
            currentMaxRows);
        RowSetNavigatorData rightNavigator =
            (RowSetNavigatorData) second.getNavigator();


        if (unionCorresponding) {
            RowSetNavigatorData rowSet;
            boolean memory =
                session.resultMaxMemoryRows == 0

View Full Code Here

    /**
     * Returns the schema and authorisation statements for the database.
     */
    public Result getScript(boolean indexRoots) {


        Result r = Result.newSingleColumnResult("COMMAND", Type.SQL_VARCHAR);


        // properties
        String[] list = logger.getPropertiesSQL();


        addRows(r, list);

View Full Code Here

//#ifdef JAVA4
    public synchronized void releaseSavepoint(
            Savepoint savepoint) throws SQLException {


        JDBCSavepoint sp;
        Result        req;


        checkClosed();


        if (savepoint == null) {
            throw Util.nullArgument();

View Full Code Here

                            Error.error(ErrorCode.X_07502));
                    }
                }


                Object[] pvals  = (Object[]) cmd.valueData;
                Result   result = executeCompiledStatement(cs, pvals);


                result = performPostExecute(cmd, result);


                return result;
            }
            case ResultConstants.BATCHEXECUTE : {
                isBatch = true;


                Result result = executeCompiledBatchStatement(cmd);


                result = performPostExecute(cmd, result);


                return result;
            }
            case ResultConstants.EXECDIRECT : {
                Result result = executeDirectStatement(cmd);


                result = performPostExecute(cmd, result);


                return result;
            }
            case ResultConstants.BATCHEXECDIRECT : {
                isBatch = true;


                Result result = executeDirectBatchStatement(cmd);


                result = performPostExecute(cmd, result);


                return result;
            }
            case ResultConstants.PREPARE : {
                Statement cs;


                try {
                    cs = statementManager.compile(this, cmd);
                } catch (Throwable t) {
                    String errorString = cmd.getMainString();


                    if (database.getProperties().getErrorLevel()
                            == HsqlDatabaseProperties.NO_MESSAGE) {
                        errorString = null;
                    }


                    return Result.newErrorResult(t, errorString);
                }


                Result result = Result.newPrepareResponse(cs);


                if (cs.getType() == StatementTypes.SELECT_CURSOR
                        || cs.getType() == StatementTypes.CALL) {
                    sessionData.setResultSetProperties(cmd, result);
                }


                result = performPostExecute(cmd, result);


                return result;
            }
            case ResultConstants.CLOSE_RESULT : {
                closeNavigator(cmd.getResultId());


                return Result.updateZeroResult;
            }
            case ResultConstants.UPDATE_RESULT : {
                Result result = this.executeResultUpdate(cmd);


                result = performPostExecute(cmd, result);


                return result;
            }

View Full Code Here

            result = sessionData.getDataResultHead(command, result, isNetwork);
        }


        if (sqlWarnings != null && sqlWarnings.size() > 0) {
            if (result.mode == ResultConstants.UPDATECOUNT) {
                result = new Result(ResultConstants.UPDATECOUNT,
                                    result.getUpdateCount());
            }


            HsqlException[] warnings = getAndClearWarnings();

View Full Code Here

            list = parser.compileStatements(sql, cmd);
        } catch (Exception e) {
            return Result.newErrorResult(e);
        }


        Result result = null;


        for (int i = 0; i < list.size(); i++) {
            Statement cs = (Statement) list.get(i);


            cs.setGeneratedColumnInfo(cmd.getGeneratedResultType(),

View Full Code Here

            cs = parser.compileStatement(props);
        } catch (HsqlException e) {
            return Result.newErrorResult(e);
        }


        Result result = executeCompiledStatement(cs,
            ValuePool.emptyObjectArray);


        return result;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.result.Result

org.hsqldb.ClientConnection

org.hsqldb.ClientConnectionHTTP

org.hsqldb.ColumnBase

org.hsqldb.Constraint

org.hsqldb.Database

org.hsqldb.dbinfo.DatabaseInformationFull

org.hsqldb.dbinfo.DatabaseInformationMain

org.hsqldb.Expression

org.hsqldb.ExpressionTable

org.hsqldb.FunctionSQLInvoked

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.