Examples with Command org.h2.command.Command used on opensource projects

Example 71 with Command

use of org.h2.command.Command in project h2database by h2database.

the class Session method prepareLocal.

/**
 * Parse and prepare the given SQL statement.
 * This method also checks if the connection has been closed.
 *
 * @param sql the SQL statement
 * @return the prepared statement
 */
public Command prepareLocal(String sql) {
    if (closed) {
        throw DbException.get(ErrorCode.CONNECTION_BROKEN_1, "session closed");
    }
    Command command;
    if (queryCacheSize > 0) {
        if (queryCache == null) {
            queryCache = SmallLRUCache.newInstance(queryCacheSize);
            modificationMetaID = database.getModificationMetaId();
        } else {
            long newModificationMetaID = database.getModificationMetaId();
            if (newModificationMetaID != modificationMetaID) {
                queryCache.clear();
                modificationMetaID = newModificationMetaID;
            }
            command = queryCache.get(sql);
            if (command != null && command.canReuse()) {
                command.reuse();
                return command;
            }
        }
    }
    Parser parser = new Parser(this);
    try {
        command = parser.prepareCommand(sql);
    } finally {
        // we can't reuse sub-query indexes, so just drop the whole cache
        subQueryIndexCache = null;
    }
    command.prepareJoinBatch();
    if (queryCache != null) {
        if (command.isCacheable()) {
            queryCache.put(sql, command);
        }
    }
    return command;
}

Example 72 with Command

use of org.h2.command.Command in project h2database by h2database.

the class MetaRecord method execute.

/**
 * Execute the meta data statement.
 *
 * @param db the database
 * @param systemSession the system session
 * @param listener the database event listener
 */
void execute(Database db, Session systemSession, DatabaseEventListener listener) {
    try {
        Prepared command = systemSession.prepare(sql);
        command.setObjectId(id);
        command.update();
    } catch (DbException e) {
        e = e.addSQL(sql);
        SQLException s = e.getSQLException();
        db.getTrace(Trace.DATABASE).error(s, sql);
        if (listener != null) {
            listener.exceptionThrown(s, sql);
        // continue startup in this case
        } else {
            throw e;
        }
    }
}

Example 73 with Command

use of org.h2.command.Command in project h2database by h2database.

the class TcpServerThread method closeSession.

private void closeSession() {
    if (session != null) {
        RuntimeException closeError = null;
        try {
            Command rollback = session.prepareLocal("ROLLBACK");
            rollback.executeUpdate(false);
        } catch (RuntimeException e) {
            closeError = e;
            server.traceError(e);
        } catch (Exception e) {
            server.traceError(e);
        }
        try {
            session.close();
            server.removeConnection(threadId);
        } catch (RuntimeException e) {
            if (closeError == null) {
                closeError = e;
                server.traceError(e);
            }
        } catch (Exception e) {
            server.traceError(e);
        } finally {
            session = null;
        }
        if (closeError != null) {
            throw closeError;
        }
    }
}

Example 74 with Command

use of org.h2.command.Command in project h2database by h2database.

the class TcpServerThread method setParameters.

private void setParameters(Command command) throws IOException {
    int len = transfer.readInt();
    ArrayList<? extends ParameterInterface> params = command.getParameters();
    for (int i = 0; i < len; i++) {
        Parameter p = (Parameter) params.get(i);
        p.setValue(transfer.readValue());
    }
}

Example 75 with Command

use of org.h2.command.Command in project h2database by h2database.

the class Parser method parseUpdate.

private Update parseUpdate() {
    Update command = new Update(session);
    currentPrepared = command;
    int start = lastParseIndex;
    TableFilter filter = readSimpleTableFilter(0, null);
    command.setTableFilter(filter);
    parseUpdateSetClause(command, filter, start);
    return command;
}