Example usage for com.google.gwt.gears.client.database Database close

Introduction

In this page you can find the example usage for com.google.gwt.gears.client.database Database close.

Prototype

public void close() throws DatabaseException 

Source Link

Document

Closes the database connection, if any, currently associated with this Database instance.

Usage

From source file:org.sigmah.client.offline.sigmah.handler.GetOrganizationHandler.java

License:Open Source License

@Override
public CommandResult execute(GetOrganization cmd, User user) throws CommandException {
    OrganizationDTO organizationDTO = null;

    final Factory factory = Factory.getInstance();
    if (factory != null) {

        final Database database = factory.createDatabase();
        database.open(OnlineMode.LOCAL_DATABASE_NAME);
        try {/*from www.  j ava 2 s .c  om*/
            organizationDTO = OrganizationDAO.selectOrganization(cmd.getId(), database);

        } catch (DatabaseException ex) {
            Log.debug("Error while reading the organization dto " + cmd.getId() + " from the local database.",
                    ex);

        } finally {
            try {
                database.close();
            } catch (DatabaseException ex) {
                Log.debug("Database closing error.", ex);
            }
        }
    }

    return organizationDTO;
}

---

From source file:org.sigmah.client.offline.sigmah.Query.java

License:Open Source License

public ResultSet execute() throws DatabaseException {
    final Factory factory = Factory.getInstance();
    final Database database = factory.createDatabase();

    database.open(OnlineMode.LOCAL_DATABASE_NAME);

    final ResultSet resultSet = database.execute(statement, arguments);

    database.close();

    return resultSet;
}

---

From source file:org.sigmah.client.offline.sigmah.sync.OrganizationSynchronizer.java

License:Open Source License

@Override
public void synchronizeLocalDatabase() {
    fireOnStart();//  w w w. j a v a2s  .  c om
    fireOnTaskChange(I18N.CONSTANTS.synchronizerOrganizationDownload_0());

    final Factory factory = Factory.getInstance();

    if (factory != null) {

        dispatcher.execute(new GetOrganization(authentication.getOrganizationId()), null,
                new AsyncCallback<OrganizationDTO>() {

                    @Override
                    public void onFailure(Throwable caught) {
                        fireOnFailure(false, I18N.CONSTANTS.synchronizerOrganizationDownload_0_failed()
                                + caught.getMessage());
                    }

                    @Override
                    public void onSuccess(OrganizationDTO result) {
                        final Database database = factory.createDatabase();
                        database.open(OnlineMode.LOCAL_DATABASE_NAME);

                        try {
                            fireOnUpdate(0.1);
                            fireOnTaskChange(I18N.CONSTANTS.synchronizerOrganizationDownload_1());
                            OrganizationDAO.createTablesIfNotExists(database);

                            fireOnUpdate(0.2);
                            fireOnTaskChange(I18N.CONSTANTS.synchronizerOrganizationDownload_2());
                            OrganizationDAO.insertOrReplaceOrganization(result, database);

                            final LocalServer localServer = factory.createLocalServer();
                            final ResourceStore store = localServer.createStore(OnlineMode.LOCAL_DATABASE_NAME);

                            fireOnUpdate(0.8);
                            fireOnTaskChange(I18N.CONSTANTS.synchronizerOrganizationDownload_3());
                            store.capture(new ResourceStoreUrlCaptureHandler() {

                                @Override
                                public void onCapture(ResourceStoreUrlCaptureEvent event) {
                                    fireOnComplete();
                                }
                            }, GWT.getModuleBaseURL() + "image-provider?" + FileUploadUtils.IMAGE_URL + "="
                                    + result.getLogo());

                        } catch (DatabaseException ex) {
                            Log.debug("Error while writing the organization dto to the local database.", ex);
                            fireOnFailure(false, I18N.CONSTANTS.synchronizerOrganizationDownload_0_failed()
                                    + ex.getMessage());

                        } finally {
                            try {
                                database.close();
                            } catch (DatabaseException ex) {
                                Log.debug("Database closing error.", ex);
                                fireOnFailure(false, I18N.CONSTANTS.synchronizerOrganizationDownload_0_failed()
                                        + ex.getMessage());
                            }
                        }
                    }
                });

    } else
        fireOnFailure(false,
                I18N.CONSTANTS.synchronizerOrganizationDownload_0_failed() + "Google Gears isn't available.");
}

---

From source file:org.sigmah.client.offline.sigmah.sync.OrganizationSynchronizer.java

License:Open Source License

@Override
public void updateDistantDatabase() {
    fireOnStart();//w ww. j a v  a  2s .  co m
    fireOnTaskChange(I18N.CONSTANTS.synchronizerOrganizationUpload_0());

    final Factory factory = Factory.getInstance();

    if (factory != null) {
        final Database database = factory.createDatabase();
        database.open(OnlineMode.LOCAL_DATABASE_NAME);

        try {
            OrganizationDAO.truncateTables(database);

            fireOnComplete();

        } catch (DatabaseException ex) {
            Log.debug("Error while removing the organization dto from the local database.", ex);
            fireOnFailure(false, I18N.CONSTANTS.synchronizerOrganizationUpload_0_failed() + ex.getMessage());

        } finally {
            try {
                database.close();
            } catch (DatabaseException ex) {
                Log.debug("Database closing error.", ex);
                fireOnFailure(false,
                        I18N.CONSTANTS.synchronizerOrganizationUpload_0_failed() + ex.getMessage());
            }
        }

    } else
        fireOnFailure(false,
                I18N.CONSTANTS.synchronizerOrganizationUpload_0_failed() + "Google Gears isn't available.");
}

---