Examples with CouldntUpdateDatabaseException com.google.security.zynamics.binnavi.Database.Exceptions.CouldntUpdateDatabaseException used on opensource projects

Example 1 with CouldntUpdateDatabaseException

use of com.google.security.zynamics.binnavi.Database.Exceptions.CouldntUpdateDatabaseException in project binnavi by google.

the class CDatabaseLoader method loadDatabase.

/**
 * Loads the content of a database.
 *
 * @param parent Parent window used for dialogs.
 * @param database The database to load.
 */
public static void loadDatabase(final Window parent, final IDatabase database) {
    final CDatabaseLoaderOperation operation = new CDatabaseLoaderOperation(database);
    try {
        database.connect();
        database.load();
    } catch (final CouldntLoadDriverException exception) {
        final String message = "E00012: " + "Database driver could not be loaded";
        final String description = CUtilityFunctions.createDescription(String.format("BinNavi could not create a database connection because the database " + "driver '%s' could not be loaded", database.getConfiguration().getDriver()), new String[] { "The database driver string is wrong.", "The database driver file could not be found." }, new String[] { "BinNavi can not load data from the given database until the " + "problem is resolved." });
        NaviErrorDialog.show(parent, message, description, exception);
    } catch (final CouldntLoadDataException exception) {
        final String message = "E00014: " + "Could not load data from the database";
        final String description = CUtilityFunctions.createDescription("An error occurred when loading data from the database.", new String[] { "The connection to the database was dropped while the data was loaded.", "The database contains inconsistent information." }, new String[] { "Close the database and open it again. Maybe close and re-start " + "BinNavi too. If the program persists, please contact the BinNavi support." });
        NaviErrorDialog.show(parent, message, description, exception);
    } catch (final InvalidDatabaseException exception) {
        final String message = "E00015: " + "Database is in an inconsistent state";
        final String description = CUtilityFunctions.createDescription("The selected database contains an invalid combination of BinNavi tables.", new String[] { "An earlier connection attempt failed and left the database in an " + "inconsistent state.", "Some BinNavi tables were deleted accidentally by an outside program." }, new String[] { "BinNavi can not use this database anymore. If the database is " + "empty, please delete the database and create a new database to work with " + "BinNavi. If the database already contains data please contact the BinNavi " + "support." });
        NaviErrorDialog.show(parent, message, description, exception);
    } catch (final CouldntInitializeDatabaseException exception) {
        final String message = "E00016: Database could not be initialized";
        final String description = CUtilityFunctions.createDescription("BinNavi could not initialize the tables required for storing disassembly data " + "in the database.", new String[] { "There might have been a communication problem with the database." }, new String[] { "The database is probably corrupted at this point. It is " + "recommended to delete the database. Afterwards you can try again with a " + "fresh database. If you do not want to do this please contact the BinNavi " + "support to find out what other options exist for you." });
        NaviErrorDialog.show(parent, message, description, exception);
    } catch (final InvalidExporterDatabaseFormatException exception) {
        final String message = "E00017: " + "Database has invalid exporter tables";
        final String description = CUtilityFunctions.createDescription("BinNavi could not load data from the selected database because the database " + "contains invalid exporter tables", new String[] { "The database is too old to use with BinNavi." }, new String[] { "It is recommended to create a database for this version of " + "BinNavi. If you do not want to do this please contact the BinNavi support " + "to find out what other options exist for you." });
        NaviErrorDialog.show(parent, message, description, exception);
    } catch (final InvalidDatabaseVersionException exception) {
        final String exceptionVersion = exception.getVersion().getString();
        if (!exceptionVersion.equals("4.0.0") || !exceptionVersion.equals("5.0.0")) {
            CMessageBox.showInformation(parent, String.format("You are trying to connect to an outdated BinNavi %s database.\n\n" + "Unfortunately you can not upgrade this database. Please create a " + "new database and export your modules again.", exceptionVersion));
        } else {
            CMessageBox.showInformation(parent, String.format("You are trying to connect to an outdated BinNavi %s database.\n\n" + "You have the option to update the database.", exceptionVersion));
            if (JOptionPane.YES_OPTION == CMessageBox.showYesNoQuestion(parent, "Do you want to upgrade the database now?\n\n(The upgrade process can take " + "very long depending on the size of your current database)\n\n(Make " + "sure that the identity field contains a user name)")) {
                final CDefaultProgressOperation updateOperation = new CDefaultProgressOperation("Upgrading database", true, false);
                updateOperation.getProgressPanel().setText("Upgrading database");
                try {
                    database.update();
                    database.close();
                } catch (final CouldntUpdateDatabaseException upgradeException) {
                    CUtilityFunctions.logException(upgradeException);
                    final String message = "E00018: " + "Database could not be upgraded";
                    final String description = CUtilityFunctions.createDescription(String.format("BinNavi could not upgrade the database (database error %d). " + "This is a serious problem because the database could be " + "left in an inconsistent state. Please try to fix the " + "problem that led to the error and try to update the " + "database again.", upgradeException.getErrorCode()), new String[] { getErrorCode(upgradeException) }, new String[] { "Please note that nobody must work with this database " + "until the database conversion process is complete. If someone " + "works with the database in its current state, partial or total " + "data loss could happen." });
                    NaviErrorDialog.show(parent, message, description, exception);
                } finally {
                    updateOperation.stop();
                }
                loadDatabase(parent, database);
            } else {
                database.close();
            }
        }
    } catch (final CouldntConnectException exception) {
        final CDatabaseConfiguration config = database.getConfiguration();
        if (exception.getSqlState().equalsIgnoreCase(PostgreSQLErrorCodes.INVALID_PASSWORD)) {
            CMessageBox.showInformation(parent, String.format("The password for user '%s' on database '%s' is invalid", config.getUser(), config.getUrl()));
            return;
        }
        if (exception.getSqlState().equalsIgnoreCase(PostgreSQLErrorCodes.POSTGRES_INVALID_CATALOG_NAME)) {
            if (JOptionPane.YES_OPTION == CMessageBox.showYesNoCancelQuestion(parent, String.format("The database '%s' does not exist. Do you want to create it now?", config.getUrl()))) {
                CDatabaseCreator.createDatabase(parent, config);
            }
        } else {
            final String message = "E00013: Database connection could not be established";
            final String description = CUtilityFunctions.createDescription(String.format("BinNavi could not connect to the database '%s'", database.getConfiguration().getName()), new String[] { exception.getMessage() }, new String[] { "BinNavi can not load data from the given database until the " + "problem is resolved." });
            NaviErrorDialog.show(parent, message, description, exception);
        }
    } catch (final LoadCancelledException exception) {
    // We do not signal to the user that he cancelled loading.
    } finally {
        operation.stop();
    }
}

Example 2 with CouldntUpdateDatabaseException

use of com.google.security.zynamics.binnavi.Database.Exceptions.CouldntUpdateDatabaseException in project binnavi by google.

the class PostgreSQLDatabaseFunctions method databaseUpdater.

/**
 * Performs an update of a postgresql database with the resource passed as argument.
 *
 * @param connection The connection to the database.
 * @param resource The resource SQL file to perform the update with.
 * @throws CouldntUpdateDatabaseException if the update fails.
 */
private static void databaseUpdater(final CConnection connection, final String resource) throws CouldntUpdateDatabaseException {
    final BufferedReader input = new BufferedReader(new InputStreamReader(ClassLoader.getSystemResourceAsStream(resource)));
    final StringBuffer contents = new StringBuffer();
    String line = null;
    try {
        while ((line = input.readLine()) != null) {
            if (line.length() > 0 && line.charAt(0) == '#') {
                continue;
            }
            contents.append(line);
            contents.append('\n');
        }
        input.close();
    } catch (final IOException exception) {
        throw new CouldntUpdateDatabaseException(exception.toString(), 40);
    }
    try (PreparedStatement statement = connection.getConnection().prepareStatement(contents.toString())) {
        statement.execute();
    } catch (final SQLException exception) {
        throw new CouldntUpdateDatabaseException(exception.toString(), 41);
    }
}