+ "'");
+ "'))");
  private void deleteAssignmentsAndProxies()  throws    HibernateException,    ClassNotFoundException,    SQLException  {    // There's currently no API for deleting Assignments (June 2005),    // so we'll just do it via straight SQL.        Configuration cfg = new Configuration();    // Read the "hibernate.cfg.xml" file. It is expected to be in a root    // directory of the classpath.    cfg.configure();    String dbUsername      = cfg.getProperty("hibernate.connection.username");    String dbPassword      = cfg.getProperty("hibernate.connection.password");    String dbUrl      = cfg.getProperty("hibernate.connection.url");    String jdbcDriverName      = cfg.getProperty("hibernate.connection.driver_class");        Class.forName(jdbcDriverName);    java.sql.Connection conn      = DriverManager.getConnection(dbUrl, dbUsername, dbPassword);    Statement stmt = conn.createStatement();    stmt.executeUpdate      ("DELETE"       + " FROM signet_assignmentLimit_history"       + " WHERE assignment_historyID IN"       + "   (SELECT historyID"       + "    FROM signet_assignment_history"       + "    WHERE subsystemID='"       + Constants.SUBSYSTEM_ID       + "')");    stmt.executeUpdate      ("DELETE FROM signet_assignment_history WHERE subsystemID='"       + Constants.SUBSYSTEM_ID       + "'");    stmt.executeUpdate      ("DELETE FROM"       + "   signet_assignmentLimit"       + " WHERE"       + "   assignmentID IN"       + "    (SELECT assignmentID FROM signet_assignment WHERE subsystemID='"       + Constants.SUBSYSTEM_ID       + "')");    stmt.executeUpdate      ("DELETE FROM signet_assignment WHERE subsystemID='"       + Constants.SUBSYSTEM_ID       + "'");    stmt.executeUpdate      ("DELETE FROM signet_proxy_history WHERE subsystemID='"       + Constants.SUBSYSTEM_ID       + "' OR subsystemID IS NULL");    stmt.executeUpdate      ("DELETE FROM signet_proxy WHERE subsystemID='"       + Constants.SUBSYSTEM_ID       + "' OR subsystemID IS NULL");    conn.commit();    conn.close();  }