| gvSIG desktop 1

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program 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 General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package com.iver.cit.gvsig.sde;

import java.sql.SQLException;

import java.util.ArrayList;

import javax.swing.JOptionPane;

import org.apache.log4j.Logger;

import com.iver.andami.PluginServices;

import com.iver.andami.plugins.Extension;

import com.iver.cit.gvsig.sde.gui.sdewizard2.ConnectionSettings;

import com.iver.cit.gvsig.sde.gui.sdewizard2.ConnectionWithParamsSDE;

import com.iver.cit.gvsig.sde.gui.sdewizard2.SDEConnectionManagerDialog;

import com.iver.cit.gvsig.sde.gui.sdewizard2.SingleSDEConnectionManager;

import com.iver.utiles.NotExistInXMLEntity;

import com.iver.utiles.XMLEntity;

/**

 * This extension allows the user to access the single connection manager dialog.

 *

 * @see com.iver.cit.gvsig.fmap.drivers.jdbc.utils.SingleJDBCConnectionManager

 *

 * @author jldominguez

 *

 */

public class SingleSDEConnectionExtension extends Extension {

    private static Logger logger = Logger.getLogger(SingleSDEConnectionExtension.class.getName());

    /**

     * This method simply loads the connections stored in gvSIG's persistence file

     * as closed connections

     */

    public void initialize() {

        loadPersistenceConnections();

    }

    /**

     * The only command available is the one to open the connection manager

     * dialog ("GESTOR_SDE")

     */

    public void execute(String actionCommand) {

        if (actionCommand.compareToIgnoreCase("GESTOR_SDE") == 0) {

            SDEConnectionManagerDialog dlg = new SDEConnectionManagerDialog();

            dlg.showDialog();

            saveAllToPersistence();

            return;

        }

    }

        public boolean isEnabled() {

                return true;

        }

        public boolean isVisible() {

                return true;

        }

    private void saveAllToPersistence() {

        XMLEntity xml = PluginServices.getPluginServices(this).getPersistentXML();

        xml.remove("sde-connections");

        ConnectionWithParamsSDE[] all = SingleSDEConnectionManager.instance()

                                                                .getAllConnections();

        if (all == null) {

            return;

        }

        for (int i = 0; i < all.length; i++) {

            addToPersistence(all[i]);

        }

    }

    private void addToPersistence(ConnectionWithParamsSDE cwp) {

        if (cwp == null) {

            return;

        }

        ConnectionSettings _cs = new ConnectionSettings();

        _cs.setHost(cwp.getHost());

        _cs.setPort(cwp.getPort());

        _cs.setDb(cwp.getDb());

        _cs.setDriver(cwp.getDrvName());

        _cs.setUser(cwp.getUser());

        _cs.setName(cwp.getName());

        String newstr = _cs.toString();

        XMLEntity xml = PluginServices.getPluginServices(this).getPersistentXML();

        String[] old = null;

        if (xml.contains("sde-connections")) {

            old = xml.getStringArrayProperty("sde-connections");

        }

        ArrayList oldl = stringArrayToArrayList(old);

        oldl.add(newstr);

        String[] newarr = (String[]) oldl.toArray(new String[0]);

        xml.remove("sde-connections");

        xml.putProperty("sde-connections", newarr);

        PluginServices.getPluginServices(this).setPersistentXML(xml);

    }

    private ArrayList stringArrayToArrayList(String[] arr) {

        ArrayList resp = new ArrayList();

        if ((arr != null) && (arr.length > 0)) {

            for (int i = 0; i < arr.length; i++) {

                resp.add(arr[i]);

            }

        }

        return resp;

    }

    private void loadPersistenceConnections() {

        XMLEntity xml = PluginServices.getPluginServices(this).getPersistentXML();

        if (xml == null) {

            xml = new XMLEntity();

        }

        if (!xml.contains("sde-connections")) {

            String[] servers = new String[0];

            xml.putProperty("sde-connections", servers);

        }

        // add drivers to connection manager

        String[] servers = null;

        try {

            servers = xml.getStringArrayProperty("sde-connections");

        }

        catch (NotExistInXMLEntity e) {

            System.err.println(

                "Error while getting projects sde-connections: " +

                e.getMessage());

            return;

        }

        for (int i = 0; i < servers.length; i++) {

            ConnectionSettings cs = new ConnectionSettings();

            boolean params_ok = true;

            try {

                    cs.setFromString(servers[i]);

            } catch (Exception ex) {

                    logger.error("Found misconfigured connection: " + servers[i]);

                    params_ok = false;

            }

            if (params_ok) addDisconnected(cs);

        }

    }

    private void addDisconnected(ConnectionSettings _cs) {

        try {

            SingleSDEConnectionManager.instance()

                                       .getConnection(_cs.getDriver(),

                _cs.getUser(), null, _cs.getName(), _cs.getHost(),

                _cs.getPort(), _cs.getDb(), false);

        }

        catch (SQLException e) {

            System.err.println("While getting connection: " + e.getMessage());

            showConnectionErrorMessage(e.getMessage());

        }

    }

    private void showConnectionErrorMessage(String _msg) {

        String msg = (_msg.length() > 300) ? "" : (": " + _msg);

        String title = PluginServices.getText(this, "connection_error");

        JOptionPane.showMessageDialog(null, title + msg, title,

            JOptionPane.ERROR_MESSAGE);

    }

 public void terminate() {

        SingleSDEConnectionManager.instance().closeAllBeforeTerminate();

    }

}