| 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;

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.vectorialdb.ConnectionSettings;

import com.iver.utiles.NotExistInXMLEntity;

import com.iver.utiles.XMLEntity;

/**

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

 *

 * @see org.gvsig.fmap.drivers.formats.db.utils.SingleVectorialDBConnectionManager

 *

 * @author jldominguez

 *

 */

public class SingleVectorialDBConnectionExtension extends Extension {

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

    /**

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

     * as closed connections

     */

    public void initialize() {

        loadPersistenceConnections();

        registerIcons();

    }

    private void registerIcons(){

    	PluginServices.getIconTheme().register(

    			"conn-image",

    			this.getClass().getClassLoader().getResource("images/conn.png")

    	);

    	PluginServices.getIconTheme().register(

    			"disconn-image",

    			this.getClass().getClassLoader().getResource("images/disconn.png")

    	);

    }

    /**

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

     * dialog ("GESTOR_JDBC")

     */

    public void execute(String actionCommand) {

//    	FIXME

//        if (actionCommand.compareToIgnoreCase("GESTOR_VECTORIALDB") == 0) {

//            VectorialDBConnectionManagerDialog dlg = new VectorialDBConnectionManagerDialog();

//            dlg.showDialog();

////            saveAllToPersistence();

//

//            return;

//        }

    }

    public boolean isEnabled() {

        return true;

    }

    public boolean isVisible() {

        return true;

    }

    public static void saveAllToPersistence() {

        SingleVectorialDBConnectionExtension ext=new SingleVectorialDBConnectionExtension();

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

        xml.putProperty("literalDBName",true);

        xml.remove("db-connections");

//        ConnectionWithParams[] all = SingleVectorialDBConnectionManager.instance()

//                                                                .getAllConnections();

//

//        if (all == null) {

//        	PluginServices.getPluginServices(ext).setPersistentXML(xml);

//            return;

//        }

//

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

//            addToPersistence(all[i],ext);

//        }

    }

//    private static void addToPersistence(ConnectionWithParams cwp, Extension ext) {

//        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(ext).getPersistentXML();

//

//        String[] old = null;

//

//        if (xml.contains("db-connections")) {

//            old = xml.getStringArrayProperty("db-connections");

//        }

//

//        ArrayList oldl = stringArrayToArrayList(old);

//        oldl.add(newstr);

//

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

//

//        xml.remove("db-connections");

//        xml.putProperty("db-connections", newarr);

//        PluginServices.getPluginServices(ext).setPersistentXML(xml);

//    }

    private static 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();

        boolean literalDBNames;

        if (!xml.contains("literalDBName")){

        	// For back compatibility

        	literalDBNames = false;

        }else{

        	// For back compatibility: Normaly always true

        	literalDBNames = xml.getBooleanProperty("literalDBName");

        }

        if (xml == null) {

            xml = new XMLEntity();

        }

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

            String[] servers = new String[0];

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

        }

        // add drivers to connection manager

        String[] servers = null;

        try {

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

        }

        catch (NotExistInXMLEntity e) {

            System.err.println(

                "Error while getting projects db-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]);

            	// For back compatibility

            	if (!literalDBNames){

            		cs.setDb(cs.getDb().toLowerCase());

            	}

            } catch (Exception ex) {

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

            	params_ok = false;

            }

            if (params_ok) {

				addDisconnected(cs);

			}

        }

        PluginServices ps= PluginServices.getPluginServices("com.iver.cit.gvsig.jdbc_spatial");

        if (ps==null) {

			return;

		}

        XMLEntity xmlJDBC =ps.getPersistentXML();

        if (xmlJDBC==null || !xmlJDBC.contains("jdbc-connections")) {

			return;

		}

//      add drivers to connection manager

        String[] serversOld = null;

        try {

            serversOld = xmlJDBC.getStringArrayProperty("jdbc-connections");

        }

        catch (NotExistInXMLEntity e) {

            System.err.println(

                "Error while getting projects jdbc-connections: " +

                e.getMessage());

            return;

        }

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

            ConnectionSettings cs = new ConnectionSettings();

            boolean params_ok = true;

            try {

            	cs.setFromString(serversOld[i]);

            	cs.setDb(cs.getDb().toLowerCase());

            } catch (Exception ex) {

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

            	params_ok = false;

            }

            if (params_ok) {

				addDisconnected(cs);

			}

        }

    }

    private void addDisconnected(ConnectionSettings _cs) {

//        try {

//            SingleVectorialDBConnectionManager.instance()

//                                       .getConnection(_cs.getDriver(),

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

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

//        }

//        catch (DBException 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() {

    	saveAllToPersistence();

//        SingleVectorialDBConnectionManager.instance().closeAllBeforeTerminate();

    }

}

<?xml version="1.0" encoding="UTF-8"?>

<classpath>

	<classpathentry kind="src" path="src"/>

	<classpathentry kind="src" output="bin-test" path="src-test"/>

	<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>

	<classpathentry combineaccessrules="false" kind="src" path="/appgvSIG"/>

	<classpathentry combineaccessrules="false" kind="src" path="/_fwAndami"/>

	<classpathentry kind="lib" path="lib/org.gvsig.fmap.dal-spi.jar"/>

	<classpathentry kind="lib" path="lib/org.gvsig.fmap.dal.jar"/>

	<classpathentry kind="lib" path="lib/org.gvsig.tools.jar"/>

	<classpathentry kind="lib" path="lib/org.cresques.cts.jar"/>

	<classpathentry kind="lib" path="lib/org.gvsig.fmap.geometry.jar"/>

	<classpathentry combineaccessrules="false" kind="src" path="/libFMap_controls"/>

	<classpathentry combineaccessrules="false" kind="src" path="/libFMap_mapcontext"/>

	<classpathentry kind="lib" path="/_fwAndami/lib/org.gvsig.ui.jar" sourcepath="/libUIComponent"/>

	<classpathentry kind="lib" path="/_fwAndami/lib/iver-utiles.jar" sourcepath="/libIverUtiles"/>

	<classpathentry kind="output" path="bin"/>

</classpath>

<?xml version="1.0" encoding="UTF-8"?>

<projectDescription>

	<name>extGeoDB</name>

	<comment></comment>

	<projects>

	</projects>

	<buildSpec>

		<buildCommand>

			<name>org.eclipse.jdt.core.javabuilder</name>

			<arguments>

			</arguments>

		</buildCommand>

	</buildSpec>

	<natures>

		<nature>org.eclipse.jdt.core.javanature</nature>

	</natures>

</projectDescription>