Method isConnectionOK

src/main/java/com/oltpbenchmark/util/SQLUtil.java:734–741

Checks to see if a connection looks OK. @param conn @param checkValid Whether or not to issue a isValid() check on the connection. Note: this can be expensive since it may actually issue a noop query. @return boolean @throws SQLException

(Connection conn, boolean checkValid)

   * @throws SQLException
   */
  public static boolean isConnectionOK(Connection conn, boolean checkValid) throws SQLException {
    boolean ret = conn != null && !conn.isClosed();
    if (checkValid) {
      // isValid() can be expensive, so only do it if we have to and timeout after 1 second
      ret = ret && conn.isValid(1);
    }
    return ret;
  }

  /**
   * Checks to see if a connection looks OK without issuing an isValid() check.