public class ApplicationWorkbenchWindowAdvisor extends WorkbenchWindowAdvisor {
{
	public boolean preWindowShellClose() {
		// prompt a dialog to let user close all connections
		super.preWindowShellClose();

		Shell shell = PlatformUI.getWorkbench().getActiveWorkbenchWindow()
				.getShell();
		if (!ConnectionManager.getInstance()
				.getAllOpenedConnections().isEmpty()) {
			CloseAllConnectionsDialog closeAllDlg = new CloseAllConnectionsDialog(
					shell);
			int result = closeAllDlg.open();
			return result == IDialogConstants.YES_ID;
		} else {
			boolean confirmed = MessageDialog.openConfirm(shell,
					"Exit application",
					"Are you sure you want to exit the application?");
			return confirmed;
		}
	}
}

public class CloseAllConnectionsDialog extends TitleAreaDialog {
	protected void buttonPressed(int buttonId) {
		super.buttonPressed(buttonId);
		setReturnCode(buttonId);
		if (buttonId == IDialogConstants.YES_ID) {
			// at first, I call closeAllOpenedConnections, it
			// will fire event, and every editor or view will correspond, and
			// close itself
			// ConnectionManager.getInstance()
			// .closeAllOpenedConnections();

			// but it doesn't work, so I close editor manually here, but ei
			Collection openedCollections = ConnectionManager.getInstance()
					.getAllOpenedConnections();
			Iterator iterator = openedCollections.iterator();
			while (iterator.hasNext()) {
				Connection connection = (Connection) iterator
						.next();
				ConnectionManager.getInstance().removeAndCloseConnection(
						connection.getId());
				CommandEditor editor = (CommandEditor) PlatformUI
						.getWorkbench()
						.getActiveWorkbenchWindow()
						.getActivePage()
						.findEditor(
								new CommandEditorInput(connection));
				editor.close(false);
			}
		}
		close();
	}
}