Examples of org.hsqldb.Statement

org.hsqldb.Statement
Base class for compiled statement objects.
@author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.9.0

        HashMappedList   map        = lg.getAsMap();


        lg.close();


        String sql = (String) map.get("/*lob_schema_definition*/");
        Statement statement = sysLobSession.compileStatement(sql,
            ResultProperties.defaultPropsValue);
        Result result = statement.execute(sysLobSession);


        if (result.isError()) {
            throw result.getException();
        }

View Full Code Here

                ResultProperties.defaultPropsValue);
    }


    synchronized public void initialiseLobSpace() {


        Statement statement =
            sysLobSession.compileStatement(initialiseBlocksSQL,
                                           ResultProperties.defaultPropsValue);
        Object[] params = new Object[3];


        params[0] = ValuePool.INTEGER_0;

View Full Code Here

        database.setReferentialIntegrity(false);


        ScriptReaderBase scr = null;
        String           statement;
        int              statementType;
        Statement dummy = new StatementDML(StatementTypes.UPDATE_CURSOR,
                                           StatementTypes.X_SQL_DATA_CHANGE,
                                           null);


        try {
            StopWatch sw     = new StopWatch();

View Full Code Here

                result.fetchSize    = in.readInt();
                result.statementID  = in.readLong();
                result.rsProperties = in.readByte();
                result.queryTimeout = in.readShort();


                Statement statement =
                    session.statementManager.getStatement(session,
                        result.statementID);


                result.statement = statement;

View Full Code Here

    }


    protected void readDDL(Session session) throws IOException {


        for (; readLoggedStatement(session); ) {
            Statement cs     = null;
            Result    result = null;


            if (rowIn.getStatementType() == INSERT_STATEMENT) {
                isInsert = true;


                break;
            }


            try {
                cs = session.compileStatement(
                    statement, ResultProperties.defaultPropsValue);
                result = session.executeCompiledStatement(cs,
                        ValuePool.emptyObjectArray);
            } catch (HsqlException e) {
                result = Result.newErrorResult(e);
            }


            if (result.isError()) {


                // handle grants on math and library routines in old versions
                if (cs == null) {}
                else if (cs.getType() == StatementTypes.GRANT) {
                    continue;
                } else if (cs.getType() == StatementTypes.CREATE_ROUTINE) {


                    // ignore legacy references
                    if (result.getMainString().contains(
                            "org.hsqldb.Library")) {
                        continue;
                    }
                }
            }


            if (result.isError()) {
                database.logger.logWarningEvent(result.getMainString(),
                                                result.getException());


                if (cs != null
                        && cs.getType() == StatementTypes.CREATE_ROUTINE) {
                    continue;
                }


                throw Error.error(result.getException(),
                                  ErrorCode.ERROR_IN_SCRIPT_FILE,

View Full Code Here

        HashMappedList   map        = lg.getAsMap();


        lg.close();


        String    sql       = (String) map.get("/*lob_schema_definition*/");
        Statement statement = sysLobSession.compileStatement(sql);
        Result    result    = statement.execute(sysLobSession);


        if (result.isError()) {
            throw result.getException();
        }

View Full Code Here

        }
    }


    private void initialiseLobSpace() {


        Statement statement = sysLobSession.compileStatement(existsBlocksSQL);
        Result    result    = statement.execute(sysLobSession);


        if (result.isError()) {
            throw result.getException();
        }

View Full Code Here

        IntKeyHashMap sessionMap = new IntKeyHashMap();
        Session       current    = null;
        int           currentId  = 0;
        String        statement;
        int           statementType;
        Statement dummy = new StatementDML(StatementTypes.UPDATE_CURSOR,
                                           StatementTypes.X_SQL_DATA_CHANGE,
                                           null);
        String databaseFile = database.getPath();
        boolean fullReplay = database.getURLProperties().isPropertyTrue(
            HsqlDatabaseProperties.hsqldb_full_log_replay);


        dummy.setCompileTimestamp(Long.MAX_VALUE);
        database.setReferentialIntegrity(false);


        try {
            StopWatch sw = new StopWatch();


            while (scr.readLoggedStatement(current)) {
                int sessionId = scr.getSessionNumber();


                if (current == null || currentId != sessionId) {
                    currentId = sessionId;
                    current   = (Session) sessionMap.get(currentId);


                    if (current == null) {
                        current =
                            database.getSessionManager().newSessionForLog(
                                database);


                        sessionMap.put(currentId, current);
                    }
                }


                if (current.isClosed()) {
                    sessionMap.remove(currentId);


                    continue;
                }


                Result result = null;


                statementType = scr.getStatementType();


                switch (statementType) {


                    case ScriptReaderBase.ANY_STATEMENT :
                        statement = scr.getLoggedStatement();


                        Statement cs;


                        try {
                            cs = current.compileStatement(statement);


                            if (database.getProperties().isVersion18()) {


                                // convert BIT columns in .log to BOOLEAN
                                if (cs.getType()
                                        == StatementTypes.CREATE_TABLE) {
                                    Table table =
                                        (Table) ((StatementSchema) cs)
                                            .getArguments()[0];

View Full Code Here


        row    = t.getEmptyRowData();
        row[0] = "CURRENT STATEMENT";
        row[1] = "";


        Statement st = session.sessionContext.currentStatement;


        if (st != null) {
            row[1] = st.getSQL();
        }


        t.insertSys(session, store, row);


        return t;

View Full Code Here

                }


                row[it_waited] = sb.toString();
            }


            Statement st = s.sessionContext.currentStatement;


            row[it_statement]   = st == null ? ""
                                             : st.getSQL();
            row[it_latch_count] = new Long(s.latch.getCount());


            t.insertSys(session, store, row);
        }

View Full Code Here

0 1 2

TOP

Related Classes of org.hsqldb.Statement

org.hsqldb.dbinfo.DatabaseInformationFull

org.hsqldb.persist.LobManager

org.hsqldb.persist.ScriptRunner

org.hsqldb.result.Result

org.hsqldb.scriptio.ScriptReaderText

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.