Esempio n. 1
0
  /**
   * Method declaration
   *
   * @param compact
   * @throws SQLException
   */
  void close(boolean compact) throws SQLException {

    if (Trace.TRACE) {
      Trace.trace();
    }

    if (bReadOnly) {
      return;
    }

    // no more scripting
    closeScript();

    // create '.script.new' (for this the cache may be still required)
    writeScript(compact);

    // flush the cache (important: after writing the script)
    if (cCache != null) {
      cCache.flush();
    }

    closeAllTextCaches(compact);

    // create '.backup.new' using the '.data'
    backup();

    // we have the new files
    pProperties.setProperty("modified", "yes-new-files");
    pProperties.save();

    // old files can be removed and new files renamed
    renameNewToCurrent(sFileScript);
    renameNewToCurrent(sFileBackup);

    // now its done completely
    pProperties.setProperty("modified", "no");
    pProperties.setProperty("version", jdbcDriver.VERSION);
    pProperties.setProperty("hsqldb.compatible_version", "1.7.0");
    pProperties.save();
    pProperties.close();

    if (compact) {

      // stop the runner thread of this process (just for security)
      stop();

      // delete the .data so then a new file is created
      (new File(sFileCache)).delete();
      (new File(sFileBackup)).delete();

      // tony_lai@users 20020820
      // The database re-open and close has been moved to
      // Database#close(int closemode) for saving memory usage.
    }
  }
Esempio n. 2
0
  /**
   * Method declaration
   *
   * @throws SQLException
   */
  void checkpoint(boolean defrag) throws SQLException {

    if (defrag) {
      ArrayList rootsArray = cCache.defrag();

      for (int i = 0; i < rootsArray.size(); i++) {
        int[] roots = (int[]) rootsArray.get(i);

        if (roots != null) {
          Trace.printSystemOut(org.hsqldb.lib.StringUtil.getList(roots, " ", ""));
        }
      }

      DataFileDefrag2.updateTableIndexRoots(dDatabase.getTables(), rootsArray);
    }

    close(false);
    pProperties.setProperty("modified", "yes");
    pProperties.save();

    if (cCache != null) {
      cCache.open(false);
    }

    reopenAllTextCaches();
    openScript();
  }
Esempio n. 3
0
  private void create() throws SQLException {

    if (Trace.TRACE) {
      Trace.trace(sName);
    }

    pProperties.setProperty("version", jdbcDriver.VERSION);
    pProperties.setProperty("sql.strict_fk", true);
    pProperties.save();
  }
  /** Creates file with defaults if it didn't exist. Returns false if file already existed. */
  public boolean createFile() throws SQLException {

    if (checkFileExists()) {
      return false;
    }

    setProperty("version", jdbcDriver.VERSION);
    setProperty("sql.strict_fk", true);
    save();

    return true;
  }
  /**
   * check by trying to delete the properties file this will not work if some application has the
   * file open this is why the properties file is kept open when running ;-) todo: check if this
   * works in all operating systems
   *
   * @return true if file is open
   * @exception java.sql.SQLException
   */
  protected boolean isFileOpen() throws java.sql.SQLException {

    close();

    if (Trace.TRACE) {
      Trace.trace();
    }

    if ((new File(fileName + ".properties")).delete() == false) {
      return true;
    }

    // the file was deleted, so recreate it now
    save();

    return false;
  }
Esempio n. 6
0
  /**
   * When opening a database, the hsqldb.compatible_version property is used to determine if this
   * version of the engine is equal to or greater than the earliest version of the engine capable of
   * opening that database.
   *
   * <p>
   *
   * @return
   * @throws SQLException
   */
  boolean open() throws SQLException {

    if (Trace.TRACE) {
      Trace.trace();
    }

    if (!pProperties.checkFileExists()) {
      create();
      open();

      // this is a new database
      return true;
    }

    // todo: some parts are not necessary for ready-only access
    pProperties.load();

    sFileScript = sName + ".script";
    sFileCache = sName + ".data";
    sFileBackup = sName + ".backup";
    scriptChecker = new File(sFileScript);

    // tony_lai@users 20020820
    // Allows the user to modify log size from the properties file.
    iLogSize = pProperties.getIntegerProperty("hsqldb.log_size", iLogSize);

    String version = pProperties.getProperty("hsqldb.compatible_version");

    // fredt@users 20020428 - patch 1.7.0 by fredt
    int check = version.substring(0, 5).compareTo(jdbcDriver.VERSION);

    Trace.check(check <= 0, Trace.WRONG_DATABASE_FILE_VERSION);

    // save the current version
    pProperties.setProperty("hsqldb.version", jdbcDriver.VERSION);

    if (pProperties.isPropertyTrue("readonly")) {
      bReadOnly = true;

      dDatabase.setReadOnly();

      if (cCache != null) {
        cCache.open(true);
      }

      reopenAllTextCaches();
      runScript();

      return false;
    }

    boolean needbackup = false;
    String state = pProperties.getProperty("modified");

    if (state.equals("yes-new-files")) {
      renameNewToCurrent(sFileScript);
      renameNewToCurrent(sFileBackup);
    } else if (state.equals("yes")) {
      if (isAlreadyOpen()) {
        throw Trace.error(Trace.DATABASE_ALREADY_IN_USE);
      }

      // recovering after a crash (or forgot to close correctly)
      restoreBackup();

      needbackup = true;
    }

    pProperties.setProperty("modified", "yes");
    pProperties.save();

    if (cCache != null) {
      cCache.open(false);
    }

    reopenAllTextCaches();
    runScript();

    if (needbackup) {
      close(false);
      pProperties.setProperty("modified", "yes");
      pProperties.save();

      if (cCache != null) {
        cCache.open(false);
      }

      reopenAllTextCaches();
    }

    openScript();

    // this is an existing database
    return false;
  }