Beispiel #1
0
 public static boolean changeDatabase(String DBname) {
   File dir = new File(PropertyManager.getInstance().getPathProperty("path_database"));
   Database rollbackDB = selectedDB;
   try {
     selectedDB.setDefaultDB(false);
     selectedDB.saveToFile(new File(dir.getAbsolutePath() + selectedDB.getName() + ".properties"));
     HibernateUtil.shutdown();
     HibernateUtil.selectDatabase(DBname);
     selectedDB.setDefaultDB(true);
     selectedDB.saveToFile(new File(dir.getAbsolutePath() + selectedDB.getName() + ".properties"));
     HibernateUtil.initSessionFactory();
     AlbumPane.getInstance().refresh();
     BottomBarPane.getInstance().refreshStats();
   } catch (Exception ex) {
     MessagePaneManager.showExceptionPane(ex, true);
     try {
       selectedDB.setDefaultDB(false);
       selectedDB.saveToFile(
           new File(dir.getAbsolutePath() + selectedDB.getName() + ".properties"));
       HibernateUtil.shutdown();
       HibernateUtil.selectDatabase(rollbackDB.getName());
       selectedDB.setDefaultDB(true);
       selectedDB.saveToFile(
           new File(dir.getAbsolutePath() + selectedDB.getName() + ".properties"));
     } catch (Exception e) {
       logger.error("Error during the rollback", e);
     }
     return false;
   }
   return true;
 }
Beispiel #2
0
  public static void initSessionFactory()
      throws FileNotFoundException, IOException, HibernateException, SQLException {
    types.put(POSTGRESQL, LocaleManager.getInstance().getString("db_postgresql"));
    types.put(MYSQL, LocaleManager.getInstance().getString("db_mysql"));
    types.put(HSQLDB, LocaleManager.getInstance().getString("db_hsqldb"));

    String dbName = HibernateUtil.getDefaultDatabase();
    try {
      HibernateUtil.selectDatabase(dbName);
    } catch (FileNotFoundException e) {
      Database newDatabase = new Database();
      newDatabase.setName("database");
      newDatabase.setDefaultDB(true);
      newDatabase.setDialect(HSQLDB);
      newDatabase.setDriver(getDriverClass(HSQLDB));
      newDatabase.setUsername("sa");
      newDatabase.setPassword("");
      newDatabase.setUrl(
          "jdbc:hsqldb:file:"
              + PropertyManager.getInstance().getPathProperty("path_resources")
              + PropertyManager.sep
              + "database");
      newDatabase.saveToFile(
          new File(
              PropertyManager.getInstance().getPathProperty("path_database")
                  + PropertyManager.sep
                  + "database.properties"));
      File coverDir =
          new File(
              PropertyManager.getInstance().getPathProperty("path_cover")
                  + PropertyManager.sep
                  + "database");
      if (!coverDir.mkdir()) {
        MessagePaneManager.showCheckErrorPane(
            LocaleManager.getInstance().getString("error_cover_dir"));
      }
      HibernateUtil.selectDatabase("database");
    }

    HibernateUtil.loadSessionFactory(selectedDB);

    DatabaseUpgrader du = DatabaseUpgrader.getInstance();
    try {
      if (!du.checkDatabase(selectedDB.getDriver(), selectedDB.getHibernateDialect()))
        du.upgradeDatabase();
    } catch (SQLException e) {
      MessagePaneManager.showExceptionPane(e, true);
      e.printStackTrace();
    }
  }
Beispiel #3
0
 public static void createDatabase(DatabaseGuiObject dgo)
     throws FileNotFoundException, IOException {
   Database db = new Database();
   db.setName(dgo.getName());
   db.setDefaultDB(dgo.isDefaultDB());
   db.setDialect(dgo.getDialect());
   if (dgo.getDialect().equals(HSQLDB)) {
     db.setUrl(
         "jdbc:hsqldb:file:"
             + PropertyManager.getInstance().getPathProperty("path_resources")
             + PropertyManager.sep
             + dgo.getName());
     db.setPassword("");
     db.setUsername("sa");
   } else {
     db.setUrl(dgo.getUrl());
     db.setPassword(dgo.getPassword());
     db.setUsername(dgo.getUsername());
   }
   db.setDriver(HibernateUtil.getDriverClass(dgo.getDialect()));
   db.saveToFile(
       new File(
           PropertyManager.getInstance().getPathProperty("path_database")
               + PropertyManager.sep
               + dgo.getName()
               + ".properties"));
   if (db.isDefaultDB()) {
     HibernateUtil.setDatabaseToDefault(db, false);
   }
   File coverDir =
       new File(
           PropertyManager.getInstance().getPathProperty("path_cover")
               + PropertyManager.sep
               + dgo.getName());
   if (!coverDir.mkdir()) {
     MessagePaneManager.showCheckErrorPane(
         LocaleManager.getInstance().getString("error_cover_dir"));
   }
 }