Examples with Prepared org.h2.test.db.Db.Prepared used on opensource projects

Example 51 with Prepared

use of org.h2.test.db.Db.Prepared 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 52 with Prepared

use of org.h2.test.db.Db.Prepared in project h2database by h2database.

the class WebApp method executeLoop.

private String executeLoop(Connection conn, int count, String sql) throws SQLException {
    ArrayList<Integer> params = New.arrayList();
    int idx = 0;
    while (!stop) {
        idx = sql.indexOf('?', idx);
        if (idx < 0) {
            break;
        }
        if (isBuiltIn(sql.substring(idx), "?/*rnd*/")) {
            params.add(1);
            sql = sql.substring(0, idx) + "?" + sql.substring(idx + "/*rnd*/".length() + 1);
        } else {
            params.add(0);
        }
        idx++;
    }
    boolean prepared;
    Random random = new Random(1);
    long time = System.currentTimeMillis();
    if (isBuiltIn(sql, "@statement")) {
        sql = sql.substring("@statement".length()).trim();
        prepared = false;
        Statement stat = conn.createStatement();
        for (int i = 0; !stop && i < count; i++) {
            String s = sql;
            for (Integer type : params) {
                idx = s.indexOf('?');
                if (type.intValue() == 1) {
                    s = s.substring(0, idx) + random.nextInt(count) + s.substring(idx + 1);
                } else {
                    s = s.substring(0, idx) + i + s.substring(idx + 1);
                }
            }
            if (stat.execute(s)) {
                ResultSet rs = stat.getResultSet();
                while (!stop && rs.next()) {
                // maybe get the data as well
                }
                rs.close();
            }
        }
    } else {
        prepared = true;
        PreparedStatement prep = conn.prepareStatement(sql);
        for (int i = 0; !stop && i < count; i++) {
            for (int j = 0; j < params.size(); j++) {
                Integer type = params.get(j);
                if (type.intValue() == 1) {
                    prep.setInt(j + 1, random.nextInt(count));
                } else {
                    prep.setInt(j + 1, i);
                }
            }
            if (session.getContents().isSQLite()) {
                // SQLite currently throws an exception on prep.execute()
                prep.executeUpdate();
            } else {
                if (prep.execute()) {
                    ResultSet rs = prep.getResultSet();
                    while (!stop && rs.next()) {
                    // maybe get the data as well
                    }
                    rs.close();
                }
            }
        }
    }
    time = System.currentTimeMillis() - time;
    StatementBuilder buff = new StatementBuilder();
    buff.append(time).append(" ms: ").append(count).append(" * ");
    if (prepared) {
        buff.append("(Prepared) ");
    } else {
        buff.append("(Statement) ");
    }
    buff.append('(');
    for (int p : params) {
        buff.appendExceptFirst(", ");
        buff.append(p == 0 ? "i" : "rnd");
    }
    return buff.append(") ").append(sql).toString();
}

Example 53 with Prepared

use of org.h2.test.db.Db.Prepared in project h2database by h2database.

the class TableLink method updateRows.

@Override
public void updateRows(Prepared prepared, Session session, RowList rows) {
    boolean deleteInsert;
    checkReadOnly();
    if (emitUpdates) {
        for (rows.reset(); rows.hasNext(); ) {
            prepared.checkCanceled();
            Row oldRow = rows.next();
            Row newRow = rows.next();
            linkedIndex.update(oldRow, newRow);
            session.log(this, UndoLogRecord.DELETE, oldRow);
            session.log(this, UndoLogRecord.INSERT, newRow);
        }
        deleteInsert = false;
    } else {
        deleteInsert = true;
    }
    if (deleteInsert) {
        super.updateRows(prepared, session, rows);
    }
}

Example 54 with Prepared

use of org.h2.test.db.Db.Prepared in project h2database by h2database.

the class TableLink method execute.

/**
 * Execute a SQL statement using the given parameters. Prepared
 * statements are kept in a hash map to avoid re-creating them.
 *
 * @param sql the SQL statement
 * @param params the parameters or null
 * @param reusePrepared if the prepared statement can be re-used immediately
 * @return the prepared statement, or null if it is re-used
 */
public PreparedStatement execute(String sql, ArrayList<Value> params, boolean reusePrepared) {
    if (conn == null) {
        throw connectException;
    }
    for (int retry = 0; ; retry++) {
        try {
            synchronized (conn) {
                PreparedStatement prep = preparedMap.remove(sql);
                if (prep == null) {
                    prep = conn.getConnection().prepareStatement(sql);
                }
                if (trace.isDebugEnabled()) {
                    StatementBuilder buff = new StatementBuilder();
                    buff.append(getName()).append(":\n").append(sql);
                    if (params != null && !params.isEmpty()) {
                        buff.append(" {");
                        int i = 1;
                        for (Value v : params) {
                            buff.appendExceptFirst(", ");
                            buff.append(i++).append(": ").append(v.getSQL());
                        }
                        buff.append('}');
                    }
                    buff.append(';');
                    trace.debug(buff.toString());
                }
                if (params != null) {
                    for (int i = 0, size = params.size(); i < size; i++) {
                        Value v = params.get(i);
                        v.set(prep, i + 1);
                    }
                }
                prep.execute();
                if (reusePrepared) {
                    reusePreparedStatement(prep, sql);
                    return null;
                }
                return prep;
            }
        } catch (SQLException e) {
            if (retry >= MAX_RETRY) {
                throw DbException.convert(e);
            }
            conn.close(true);
            connect();
        }
    }
}

Example 55 with Prepared

use of org.h2.test.db.Db.Prepared in project h2database by h2database.

the class TableView method compileViewQuery.

private Query compileViewQuery(Session session, String sql, boolean literalsChecked, String viewName) {
    Prepared p;
    session.setParsingCreateView(true, viewName);
    try {
        p = session.prepare(sql, false, literalsChecked);
    } finally {
        session.setParsingCreateView(false, viewName);
    }
    if (!(p instanceof Query)) {
        throw DbException.getSyntaxError(sql, 0);
    }
    Query q = (Query) p;
    // only potentially recursive cte queries need to be non-lazy
    if (isTableExpression && allowRecursive) {
        q.setNeverLazy(true);
    }
    return q;
}