Esempio n. 1
0
  /**
   * Runs the setInitializingFailed prepared statement. <code>
   *  		UPDATE SERVER SET INITIALIZED=NULL
   * </code>
   *
   * @param stmtProvider factory and cache of PreparedStatments
   * @param connection connection to underlying database
   * @return int
   * @throws org.openanzo.jdbc.utils.RdbException
   */
  public static int setInitializingFailed(
      final org.openanzo.jdbc.utils.PreparedStatementProvider stmtProvider,
      final java.sql.Connection connection)
      throws org.openanzo.jdbc.utils.RdbException {
    java.sql.PreparedStatement ps = null;
    // long startTimer=System.currentTimeMillis();
    try {
      ps = stmtProvider.getPreparedSQLStatement(setInitializingFailed, new String[] {}, connection);
      int counter = 0;
      try {
        counter = ps.executeUpdate();
      } catch (java.sql.SQLException sqle) {
        if (sqle.getErrorCode() == 1205) {
          int retries = 0;
          while (retries < 5) {
            try {
              Thread.sleep(5000);
            } catch (InterruptedException ie) {
              throw sqle;
            }
            try {
              counter = ps.executeUpdate();
              break;
            } catch (java.sql.SQLException sqleInner) {
              if (sqleInner.getErrorCode() == 1205) {
                retries++;
              } else {
                throw sqleInner;
              }
            }
          }
          if (retries >= 5) {
            throw sqle;
          }
        } else {
          throw sqle;
        }
      }
      return counter;

    } catch (java.sql.SQLException e) {
      throw new org.openanzo.jdbc.utils.RdbException(
          org.openanzo.exceptions.ExceptionConstants.RDB.FAILED_EXECUTING_SQL,
          e,
          "setInitializingFailed",
          stmtProvider.getSqlString(setInitializingFailed),
          "",
          "");
    } finally {
      if (ps != null) {
        try {
          ps.close();
        } catch (java.sql.SQLException sqle) {
          if (log.isDebugEnabled())
            log.debug(
                org.openanzo.exceptions.LogUtils.RDB_MARKER,
                "Error closing prepared statement",
                sqle);
        }
      }
      // long endtimer=(System.currentTimeMillis()-startTimer);
      // if(endtimer>CUTOFF)System.out.println("[setInitializingFailed]"+endtimer);
    }
  }
Esempio n. 2
0
  /**
   * Runs the lockTable prepared statement. <code>
   *  		LOCK TABLE {0} {1}
   * </code>
   *
   * @param stmtProvider factory and cache of PreparedStatments
   * @param connection connection to underlying database
   * @param tableName template parameter
   * @param tableLocksExtra template parameter
   * @throws org.openanzo.jdbc.utils.RdbException
   */
  public static void lockTable(
      final org.openanzo.jdbc.utils.PreparedStatementProvider stmtProvider,
      final java.sql.Connection connection,
      String tableName,
      String tableLocksExtra)
      throws org.openanzo.jdbc.utils.RdbException {
    java.sql.PreparedStatement ps = null;
    // long startTimer=System.currentTimeMillis();
    try {
      ps =
          stmtProvider.getPreparedSQLStatement(
              lockTable, new String[] {tableName, tableLocksExtra}, connection);
      try {
        ps.execute();
      } catch (java.sql.SQLException sqle) {
        if (sqle.getErrorCode() == 1205) {
          int retries = 0;
          while (retries < 5) {
            try {
              Thread.sleep(5000);
            } catch (InterruptedException ie) {
              throw sqle;
            }
            try {
              ps.execute();
              break;
            } catch (java.sql.SQLException sqleInner) {
              if (sqleInner.getErrorCode() == 1205) {
                retries++;
              } else {
                throw sqleInner;
              }
            }
          }
          if (retries >= 5) {
            throw sqle;
          }
        } else {
          throw sqle;
        }
      }

    } catch (java.sql.SQLException e) {
      throw new org.openanzo.jdbc.utils.RdbException(
          org.openanzo.exceptions.ExceptionConstants.RDB.FAILED_EXECUTING_SQL,
          e,
          "lockTable",
          stmtProvider.getSqlString(lockTable),
          "",
          ""
              + "tableName="
              + ((tableName != null) ? tableName.toString() : "null")
              + ","
              + "tableLocksExtra="
              + ((tableLocksExtra != null) ? tableLocksExtra.toString() : "null"));
    } finally {
      if (ps != null) {
        try {
          ps.close();
        } catch (java.sql.SQLException sqle) {
          if (log.isDebugEnabled())
            log.debug(
                org.openanzo.exceptions.LogUtils.RDB_MARKER,
                "Error closing prepared statement",
                sqle);
        }
      }
      // long endtimer=(System.currentTimeMillis()-startTimer);
      // if(endtimer>CUTOFF)System.out.println("[lockTable]"+endtimer);
    }
  }
Esempio n. 3
0
  /**
   * Runs the getServerVersion prepared statement. <code>
   *  		SELECT VERSION FROM SERVER;
   * </code>
   *
   * @param stmtProvider factory and cache of PreparedStatments
   * @param connection connection to underlying database
   * @return Long
   * @throws org.openanzo.jdbc.utils.RdbException
   */
  public static Long getServerVersion(
      final org.openanzo.jdbc.utils.PreparedStatementProvider stmtProvider,
      final java.sql.Connection connection)
      throws org.openanzo.jdbc.utils.RdbException {
    java.sql.PreparedStatement ps = null;
    // long startTimer=System.currentTimeMillis();
    try {
      ps = stmtProvider.getPreparedSQLStatement(getServerVersion, new String[] {}, connection);
      java.sql.ResultSet rs = null;
      try {
        try {
          rs = ps.executeQuery();
        } catch (java.sql.SQLException sqle) {
          if (sqle.getErrorCode() == 1205) {
            int retries = 0;
            while (retries < 5) {
              try {
                Thread.sleep(5000);
              } catch (InterruptedException ie) {
                throw sqle;
              }
              try {
                rs = ps.executeQuery();
                break;
              } catch (java.sql.SQLException sqleInner) {
                if (sqleInner.getErrorCode() == 1205) {
                  retries++;
                } else {
                  throw sqleInner;
                }
              }
            }
            if (retries >= 5) {
              throw sqle;
            }
          } else {
            throw sqle;
          }
        }
        if (!rs.next()) return null;
        Long val = rs.getLong(1);
        return val;
      } finally {
        if (rs != null) {
          try {
            rs.close();
          } catch (java.sql.SQLException sqle) {
            if (log.isDebugEnabled())
              log.debug(
                  org.openanzo.exceptions.LogUtils.RDB_MARKER, "Error closing result set", sqle);
          }
        }
      }

    } catch (java.sql.SQLException e) {
      throw new org.openanzo.jdbc.utils.RdbException(
          org.openanzo.exceptions.ExceptionConstants.RDB.FAILED_EXECUTING_SQL,
          e,
          "getServerVersion",
          stmtProvider.getSqlString(getServerVersion),
          "",
          "");
    } finally {
      if (ps != null) {
        try {
          ps.close();
        } catch (java.sql.SQLException sqle) {
          if (log.isDebugEnabled())
            log.debug(
                org.openanzo.exceptions.LogUtils.RDB_MARKER,
                "Error closing prepared statement",
                sqle);
        }
      }
      // long endtimer=(System.currentTimeMillis()-startTimer);
      // if(endtimer>CUTOFF)System.out.println("[getServerVersion]"+endtimer);
    }
  }