/* * Copyright (C) 2006 SQL Explorer Development Team * http://sourceforge.net/projects/eclipsesql * * This program is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */ package net.sourceforge.sqlexplorer.connections.actions; import java.util.Set; import net.sourceforge.sqlexplorer.IConstants; import net.sourceforge.sqlexplorer.Messages; import net.sourceforge.sqlexplorer.dbproduct.SQLConnection; import net.sourceforge.sqlexplorer.dbproduct.Session; import net.sourceforge.sqlexplorer.plugin.SQLExplorerPlugin; import net.sourceforge.sqlexplorer.util.ImageUtil; import org.eclipse.jface.dialogs.IDialogConstants; import org.eclipse.jface.dialogs.MessageDialogWithToggle; import org.eclipse.ui.IViewActionDelegate; /** * @author Davy Vanherbergen * */ public class CloseConnectionAction extends AbstractConnectionTreeAction implements IViewActionDelegate { public CloseConnectionAction() { super("ConnectionsView.Actions.CloseConnection", "ConnectionsView.Actions.CloseConnectionToolTip", "Images.CloseConnIcon"); setDisabledImageDescriptor(ImageUtil.getDescriptor("Images.DisabledCloseConnIcon")); } public void run() { boolean confirm = SQLExplorerPlugin.getDefault().getPluginPreferences().getBoolean(IConstants.CONFIRM_BOOL_CLOSE_CONNECTION); for (SQLConnection connection : getView().getSelectedConnections(false)) { Session session = connection.getSession(); if (session != null && !session.isConnectionInUse()) { if (confirm) { MessageDialogWithToggle dialog = MessageDialogWithToggle.openYesNoQuestion(getView().getSite().getShell(), Messages.getString("ConnectionsView.Actions.CloseAll.Confirm.Title"), Messages.getString("ConnectionsView.Actions.CloseAll.Confirm.Message"), Messages.getString("ConnectionsView.Actions.CloseAll.Confirm.Toggle"), false, null, null); if (dialog.getToggleState() && dialog.getReturnCode() == IDialogConstants.YES_ID) SQLExplorerPlugin.getDefault().getPluginPreferences().setValue(IConstants.CONFIRM_BOOL_CLOSE_CONNECTION, false); if (dialog.getReturnCode() != IDialogConstants.YES_ID) return; } session.disposeConnection(); } else if (session == null) connection.getUser().releaseFromPool(connection); } getView().refresh(); } /** * Action is available when there is at least one session selected. * * @see net.sourceforge.sqlexplorer.connections.actions.AbstractConnectionTreeAction#isAvailable() */ public boolean isAvailable() { if (getView() == null) return false; Set<SQLConnection> connections = getView().getSelectedConnections(false); for (SQLConnection connection : connections) { if (connection.getSession() == null || !connection.getSession().isConnectionInUse()) return true; } return false; } }