org.h2.message.DbException.addSQL java code examples

Common ways to obtain DbException

private void myMethod () {
 DbException d =DbException.getUnsupportedException("previous")
Throwable e;DbException.convert(e)
DbException.get(errorCode)
Smart code suggestions by Tabnine
}

/**
 * Set the SQL statement of the exception to the given row.
 *
 * @param e the exception
 * @param rowId the row number
 * @param values the values of the row
 * @return the exception
 */
protected DbException setRow(DbException e, int rowId, String values) {
  StringBuilder buff = new StringBuilder();
  if (sqlStatement != null) {
    buff.append(sqlStatement);
  }
  buff.append(" -- ");
  if (rowId > 0) {
    buff.append("row #").append(rowId + 1).append(' ');
  }
  buff.append('(').append(values).append(')');
  return e.addSQL(buff.toString());
}

private DbException getExceptionAlreadyInUse(String reason) {
  DbException e = DbException.get(
      ErrorCode.DATABASE_ALREADY_OPEN_1, reason);
  if (fileName != null) {
    try {
      Properties prop = load();
      String server = prop.getProperty("server");
      if (server != null) {
        String serverId = server + "/" + prop.getProperty("id");
        e = e.addSQL(serverId);
      }
    } catch (DbException e2) {
      // ignore
    }
  }
  return e;
}

/**
 * Parse a statement or a list of statements, and prepare it for execution.
 *
 * @param sql the SQL statement to parse
 * @return the command object
 */
public Command prepareCommand(String sql) {
  try {
    Prepared p = parse(sql);
    boolean hasMore = isToken(";");
    if (!hasMore && currentTokenType != END) {
      throw getSyntaxError();
    }
    p.prepare();
    Command c = new CommandContainer(this, sql, p);
    if (hasMore) {
      String remaining = originalSQL.substring(parseIndex);
      if (remaining.trim().length() != 0) {
        c = new CommandList(this, sql, c, remaining);
      }
    }
    return c;
  } catch (DbException e) {
    throw e.addSQL(originalSQL);
  }
}

private void execute(String sql) {
  try {
    Prepared command = session.prepare(sql);
    if (command.isQuery()) {
      command.query(0);
    } else {
      command.update();
    }
    if (session.getAutoCommit()) {
      session.commit(false);
    }
  } catch (DbException e) {
    throw e.addSQL(sql);
  }
}

/**
 * Parse the statement, but don't prepare it for execution.
 *
 * @param sql the SQL statement to parse
 * @return the prepared object
 */
Prepared parse(String sql) {
  Prepared p;
  try {
    // first, try the fast variant
    p = parse(sql, false);
  } catch (DbException e) {
    if (e.getErrorCode() == ErrorCode.SYNTAX_ERROR_1) {
      // now, get the detailed exception
      p = parse(sql, true);
    } else {
      throw e.addSQL(sql);
    }
  }
  p.setPrepareAlways(recompileAlways);
  p.setParameterList(parameters);
  return p;
}

/**
 * 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;
    }
  }
}

DbException e = DbException.get(
    ErrorCode.DATABASE_ALREADY_OPEN_1, "Server is running");
throw e.addSQL(server + "/" + id);

e = e.addSQL(sql);
SQLException s = e.getSQLException();
database.exceptionThrown(s, sql);

  viewQuery = compiledQuery;
} catch (DbException e) {
  e.addSQL(getCreateSQL());
  createException = e;

e = e.addSQL(sql);
SQLException s = e.getSQLException();
database.exceptionThrown(s, sql);

  ValueEnum.check(enumerators);
} catch (DbException e) {
  throw e.addSQL(original);

/**
 * Set the SQL statement of the exception to the given row.
 *
 * @param e the exception
 * @param rowId the row number
 * @param values the values of the row
 * @return the exception
 */
protected DbException setRow(DbException e, int rowId, String values) {
  StringBuilder buff = new StringBuilder();
  if (sqlStatement != null) {
    buff.append(sqlStatement);
  }
  buff.append(" -- ");
  if (rowId > 0) {
    buff.append("row #").append(rowId + 1).append(' ');
  }
  buff.append('(').append(values).append(')');
  return e.addSQL(buff.toString());
}

/**
 * Set the SQL statement of the exception to the given row.
 *
 * @param e the exception
 * @param rowId the row number
 * @param values the values of the row
 * @return the exception
 */
protected DbException setRow(DbException e, int rowId, String values) {
  StringBuilder buff = new StringBuilder();
  if (sqlStatement != null) {
    buff.append(sqlStatement);
  }
  buff.append(" -- ");
  if (rowId > 0) {
    buff.append("row #").append(rowId + 1).append(' ');
  }
  buff.append('(').append(values).append(')');
  return e.addSQL(buff.toString());
}

private DbException getExceptionAlreadyInUse(String reason) {
  DbException e = DbException.get(
      ErrorCode.DATABASE_ALREADY_OPEN_1, reason);
  if (fileName != null) {
    try {
      Properties prop = load();
      String server = prop.getProperty("server");
      if (server != null) {
        String serverId = server + "/" + prop.getProperty("id");
        e = e.addSQL(serverId);
      }
    } catch (DbException e2) {
      // ignore
    }
  }
  return e;
}

private DbException getExceptionAlreadyInUse(String reason) {
  DbException e = DbException.get(
      ErrorCode.DATABASE_ALREADY_OPEN_1, reason);
  if (fileName != null) {
    try {
      Properties prop = load();
      String server = prop.getProperty("server");
      if (server != null) {
        String serverId = server + "/" + prop.getProperty("id");
        e = e.addSQL(serverId);
      }
    } catch (DbException e2) {
      // ignore
    }
  }
  return e;
}

private void execute(String sql) {
  try {
    Prepared command = session.prepare(sql);
    if (command.isQuery()) {
      command.query(0);
    } else {
      command.update();
    }
    if (session.getAutoCommit()) {
      session.commit(false);
    }
  } catch (DbException e) {
    throw e.addSQL(sql);
  }
}

private void execute(String sql) {
  try {
    Prepared command = session.prepare(sql);
    if (command.isQuery()) {
      command.query(0);
    } else {
      command.update();
    }
    if (session.getAutoCommit()) {
      session.commit(false);
    }
  } catch (DbException e) {
    throw e.addSQL(sql);
  }
}

/**
 * Parse the statement, but don't prepare it for execution.
 *
 * @param sql the SQL statement to parse
 * @return the prepared object
 */
Prepared parse(String sql) {
  Prepared p;
  try {
    // first, try the fast variant
    p = parse(sql, false);
  } catch (DbException e) {
    if (e.getErrorCode() == ErrorCode.SYNTAX_ERROR_1) {
      // now, get the detailed exception
      p = parse(sql, true);
    } else {
      throw e.addSQL(sql);
    }
  }
  p.setPrepareAlways(recompileAlways);
  p.setParameterList(parameters);
  return p;
}

/**
 * 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;
    }
  }
}

/**
 * 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;
    }
  }
}

Javadoc

Set the SQL statement of the given exception. This method may create a new object.

Popular methods of DbException

getUnsupportedException
Gets a SQL exception meaning this feature is not supported.
throwInternalError
Throw an internal error. This method seems to return an exception object, so that it can be used ins
convert
Convert a throwable to an SQL exception using the default mapping. All errors except the following a
get
Create a database exception for a specific error code.
<init>
convertIOException
Convert an IO exception to a database exception.
convertInvocation
Convert an InvocationTarget exception to a database exception.
convertToIOException
Convert an exception to an IO exception.
getCause
getErrorCode
Get the error code.
getInvalidValueException
Gets a SQL exception meaning this value is invalid.
getJdbcSQLException
Gets the SQL exception object for a specific error code.

Popular in Java

Reading from database using SQL prepared statement
setRequestProperty (URLConnection)
getApplicationContext (Context)
setScale (BigDecimal)
FileWriter (java.io)
A specialized Writer that writes to a file in the file system. All write requests made by calling me
ServerSocket (java.net)
This class represents a server-side socket that waits for incoming client connections. A ServerSocke
Permission (java.security)
Legacy security code; do not use.
Deque (java.util)
A linear collection that supports element insertion and removal at both ends. The name deque is shor
Semaphore (java.util.concurrent)
A counting semaphore. Conceptually, a semaphore maintains a set of permits. Each #acquire blocks if
Reflections (org.reflections)
Reflections one-stop-shop objectReflections scans your classpath, indexes the metadata, allows you t
PhpStorm for WordPress

How to use addSQLmethodin org.h2.message.DbException

Best Java code snippets using org.h2.message.DbException.addSQL (Showing top 20 results out of 315)

How to use
addSQL
method
in
org.h2.message.DbException