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

        }


        PersistentStore store = session.sessionData.getRowStore(t);
        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        Result rs = sys.executeDirectStatement(
            "SELECT GRANTOR, GRANTEE, UDT_CATALOG, UDT_SCHEMA, UDT_NAME, "
            + "PRIVILEGE_TYPE, IS_GRANTABLE "
            + "FROM INFORMATION_SCHEMA.UDT_PRIVILEGES "
            + "JOIN INFORMATION_SCHEMA.APPLICABLE_ROLES ON GRANTEE = ROLE_NAME;", ResultProperties
                .defaultPropsValue);

View Full Code Here

        }


        PersistentStore store = session.sessionData.getRowStore(t);
        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        Result rs = sys.executeDirectStatement(
            "SELECT GRANTOR, GRANTEE, OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, "
            + "OBJECT_TYPE, PRIVILEGE_TYPE, IS_GRANTABLE "
            + "FROM INFORMATION_SCHEMA.USAGE_PRIVILEGES "
            + "JOIN INFORMATION_SCHEMA.APPLICABLE_ROLES ON GRANTEE = ROLE_NAME;", ResultProperties
                .defaultPropsValue);

View Full Code Here


        PersistentStore store = session.sessionData.getRowStore(t);
        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        String sql = (String) statementMap.get("/*sql_features*/");
        Result rs =
            sys.executeDirectStatement(sql,
                                       ResultProperties.defaultPropsValue);


        t.insertSys(store, rs);

View Full Code Here


        PersistentStore store = session.sessionData.getRowStore(t);
        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        String sql = (String) statementMap.get("/*sql_packages*/");
        Result rs =
            sys.executeDirectStatement(sql,
                                       ResultProperties.defaultPropsValue);


        t.insertSys(store, rs);

View Full Code Here


        PersistentStore store = session.sessionData.getRowStore(t);
        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        String sql = (String) statementMap.get("/*sql_parts*/");
        Result rs =
            sys.executeDirectStatement(sql,
                                       ResultProperties.defaultPropsValue);


        t.insertSys(store, rs);

View Full Code Here


        PersistentStore store = session.sessionData.getRowStore(t);
        Session sys = database.sessionManager.newSysSession(
            SqlInvariants.INFORMATION_SCHEMA_HSQLNAME, session.getUser());
        String sql = (String) statementMap.get("/*sql_sizing*/");
        Result rs =
            sys.executeDirectStatement(sql,
                                       ResultProperties.defaultPropsValue);


        t.insertSys(store, rs);

View Full Code Here

        this.zoneSeconds = timeZoneSeconds;
        this.zoneString  = TimeZone.getDefault().getID();


        initStructures();


        Result login = Result.newConnectionAttemptRequest(user, password,
            database, zoneString, timeZoneSeconds);


        initConnection(host, port, isTLS);


        Result resultIn = execute(login);


        if (resultIn.isError()) {
            throw Error.error(resultIn);
        }


        sessionID              = resultIn.getSessionId();
        databaseID             = resultIn.getDatabaseId();
        clientPropertiesString = resultIn.getMainString();
    }

View Full Code Here

            resultOut.setResultType(ResultConstants.REQUESTDATA);
            resultOut.setResultId(navigatorId);
            resultOut.setUpdateCount(offset);
            resultOut.setFetchSize(size);


            Result result = execute(resultOut);


            return (RowSetNavigatorClient) result.getNavigator();
        } catch (Throwable e) {
            throw Error.error(ErrorCode.X_08006, e.toString());
        }
    }

View Full Code Here

    public synchronized Object getAttribute(int id) {


        resultOut.setResultType(ResultConstants.GETSESSIONATTR);
        resultOut.setStatementType(id);


        Result in = execute(resultOut);


        if (in.isError()) {
            throw Error.error(in);
        }


        Object[] data = in.getSingleRowData();


        switch (id) {


            case SessionInterface.INFO_AUTOCOMMIT :
                return data[SessionInterface.INFO_BOOLEAN];

View Full Code Here

            case SessionInterface.INFO_CATALOG :
                data[SessionInterface.INFO_VARCHAR] = value;
                break;
        }


        Result resultIn = execute(resultOut);


        if (resultIn.isError()) {
            throw Error.error(resultIn);
        }
    }

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.