Application: gvSIG desktop » gvSIG data provider for PostgreSQL

#Tue Oct 08 20:52:46 CEST 2013

buildNumber=2077

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugin-config>

  <libraries library-dir="lib/"/>

  <depends plugin-name="org.gvsig.app.mainplugin"/>

  <resourceBundle name="text"/>

  <extensions>

     <extension class-name="org.gvsig.andami.LibraryExtension" active="false"/>

  </extensions>    

</plugin-config>

org.gvsig.exportto.swing.prov.postgresql.ExporttoV2PostgreSQLProviderLibrary

<assembly>

  <id>gvsig-plugin-package</id>

  <formats>

    <format>zip</format>

  </formats>

  <baseDirectory>${project.artifactId}</baseDirectory>

  <includeBaseDirectory>true</includeBaseDirectory>

  <files>

    <file>

      <source>target/${project.artifactId}-${project.version}.jar</source>

      <outputDirectory>lib</outputDirectory>

    </file>

    <file>

      <source>target/package.info</source>

    </file>

    <file>

      <source>src/main/resources-plugin/config.xml</source>

    </file>

  </files>

  <dependencySets>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

        <include>org.gvsig:org.gvsig.postgresql.provider</include>

      </includes>

    </dependencySet>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

		<include>postgresql:postgresql</include>

		<include>commons-dbcp:commons-dbcp</include>

		<include>commons-collections:commons-collections</include>

		<include>commons-pool:commons-pool</include>

      </includes>

    </dependencySet>

  </dependencySets>

</assembly>

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3

 * 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., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto;

import org.gvsig.tools.library.AbstractLibrary;

import org.gvsig.tools.library.LibraryException;

import org.gvsig.tools.service.spi.ProviderManager;

import org.gvsig.exportto.swing.ExporttoSwingLibrary;

import org.gvsig.exportto.swing.spi.ExporttoSwingProviderLocator;

/**

 * Library to initialize and register the file Exporto provider

 * implementation.

 * 

 * @author gvSIG Team

 * @version $Id$

 */

public class ExporttoPostgreSQLProviderLibrary extends AbstractLibrary {

    @Override

    public void doRegistration() {

        registerAsServiceOf(ExporttoSwingLibrary.class);

    }

    @Override

    protected void doInitialize() throws LibraryException {

        // Nothing to do

    }

    @Override

    protected void doPostInitialize() throws LibraryException {

        ProviderManager providerManager =

            ExporttoSwingProviderLocator.getManager();

        providerManager

            .addProviderFactory(new ExporttoPostgreSQLProviderFactory());

    }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3

 * 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., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto;

import org.cresques.cts.IProjection;

import org.gvsig.exportto.swing.ExporttoSwingManager;

import org.gvsig.exportto.swing.spi.AbstractExporttoProviderFactory;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.tools.dynobject.DynObject;

import org.gvsig.tools.service.ServiceException;

import org.gvsig.tools.service.spi.Provider;

import org.gvsig.tools.service.spi.ProviderServices;

/**

 * Factory of file {@link ExportoProvider} objects.

 * 

 * @author gvSIG Team

 * @version $Id$

 */

public class ExporttoPostgreSQLProviderFactory extends

    AbstractExporttoProviderFactory {

    private static final String PROVIDER_NAME = "PostgreSQLv2";

    public ExporttoPostgreSQLProviderFactory() {

        super(new int[] {

            ExporttoSwingManager.VECTORIAL_TABLE_WITHOUT_GEOMETRY,

            ExporttoSwingManager.VECTORIAL_TABLE_WITH_GEOMETRY });

    }

    public Provider create(DynObject parameters, ProviderServices services)

        throws ServiceException {

        return new ExporttoPostgreSQLProvider(services,

            (FeatureStore) parameters.getDynValue(PARAMETER_FEATURESTORE),

            (IProjection) parameters.getDynValue(PARAMETER_PROJECTION));

    }

    public String getName() {

        return PROVIDER_NAME;

    }

}

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

<!--

    gvSIG. Desktop Geographic Information System.

    Copyright (C) 2007-2013 gvSIG Association.

    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 3

    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., 51 Franklin Street, Fifth Floor, Boston,

    MA  02110-1301, USA.

    For any additional information, do not hesitate to contact us

    at info AT gvsig.com, or visit our website www.gvsig.com.

-->

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<title>org.gvsig.exporto package documentation</title>

</head>

<body>

	<p>Exporto provider which gets Exporto from a file.</p>

</body>

</html>

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3

 * 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., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto.panel;

import java.awt.BorderLayout;

import javax.swing.JTextField;

import org.gvsig.exportto.swing.ExporttoSwingLocator;

import org.gvsig.exportto.swing.ExporttoSwingManager;

import org.gvsig.exportto.swing.spi.ExporttoPanelValidationException;

import org.gvsig.exportto.swing.spi.ExporttoSwingProviderPanel;

/**

 * @author gvSIG Team

 * @version $Id$

 * 

 */

public class SelectTableNamePanel extends ExporttoSwingProviderPanel {

    private static final long serialVersionUID = 6269512983586358017L;

    private static final ExporttoSwingManager EXPORTTO_SWING_MANAGER =

        ExporttoSwingLocator.getSwingManager();

    protected JTextField textField = null;

    protected void initializeComponents() {

        this.setLayout(new BorderLayout());

        textField = new JTextField();

        add(textField, BorderLayout.NORTH);

    }

    public String getText() {

        String field = textField.getText();

        if ((field == null) || (field.equals(""))) {

            return null;

        }

        return field;

    }

    public String getPanelTitle() {

        return EXPORTTO_SWING_MANAGER.getTranslation("intro_tablename");

    }

    public boolean isValidPanel() throws ExporttoPanelValidationException {

        if (getText() == null || getText().equals("")) {

            throw new ExporttoPanelValidationException(

                "The table cannot be empty");

        }

        return true;

    }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3 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., 51

 * Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us at info AT

 * gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto.panel;

import java.awt.BorderLayout;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import org.gvsig.exportto.swing.ExporttoSwingLocator;

import org.gvsig.exportto.swing.ExporttoSwingManager;

import org.gvsig.exportto.swing.spi.ExporttoPanelValidationException;

import org.gvsig.exportto.swing.spi.ExporttoSwingProviderPanel;

import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor;

import org.gvsig.fmap.dal.feature.FeatureType;

/**

 * @author gvSIG Team

 * @version $Id$

 *

 */

public class SelectPkPanel extends ExporttoSwingProviderPanel {

    private static final long serialVersionUID = 2652404227373508779L;

    private static final ExporttoSwingManager EXPORTTO_SWING_MANAGER

            = ExporttoSwingLocator.getSwingManager();

    private FeatureType featType = null;

    protected JTextField textField = null;

    public SelectPkPanel() {

        super();

    }

    public SelectPkPanel(FeatureType ft) {

        super();

        featType = ft;

    }

    protected void initializeComponents() {

        this.setLayout(new BorderLayout());

        JPanel topPanel = new JPanel(new BorderLayout());

        textField = new JTextField();

        String msg = EXPORTTO_SWING_MANAGER.getTranslation(

                "_Enter_new_field_name_for_primary_key_or_blank_to_not_add_primary_key");

        topPanel.add(new JLabel(msg + ":"), BorderLayout.NORTH);

        topPanel.add(textField, BorderLayout.CENTER);

        // ==============================================

        add(topPanel, BorderLayout.NORTH);

    }

    public String getText() {

        String field = textField.getText();

        if ((field == null) || (field.trim().equals(""))) {

            return null;

        }

        return field;

    }

    @Override

    public String getPanelTitle() {

        return EXPORTTO_SWING_MANAGER.getTranslation("_Primary_key");

    }

    @Override

    public boolean isValidPanel() throws ExporttoPanelValidationException {

        String txt = this.getText();

        if (isFieldName(txt, featType)) {

            throw new ExporttoPanelValidationException(

                    EXPORTTO_SWING_MANAGER.getTranslation(

                            "_Field_name_already_exists"));

        }

        return true;

    }

    private boolean isFieldName(String txt, FeatureType ft) {

        if (ft == null || txt == null) {

            return false;

        }

        FeatureAttributeDescriptor[] atts = ft.getAttributeDescriptors();

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

            if (atts[i].getName().equals(txt)) {

                return true;

            }

        }

        return false;

    }

}

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package org.gvsig.postgresql.exportto.panel;

import java.util.HashMap;

import java.util.Iterator;

import java.util.Map;

import javax.swing.JComponent;

import javax.swing.JPanel;

import org.gvsig.andami.PluginsLocator;

import org.gvsig.andami.PluginsManager;

import org.gvsig.fmap.dal.serverexplorer.db.DBServerExplorerParameters;

import org.gvsig.tools.swing.api.Component;

import org.gvsig.geodb.ExtDB_Spatial;

/**

 *

 * @author jjdelcerro

 */

public class DefaultConnectionPanel extends JPanel implements Component {

    private String name = null;

    private DBServerExplorerParameters explorerParameters = null;

    private String explorerNameFilter = null;

    public DefaultConnectionPanel() {

    }

    public void setFilterByExplorerName(String explorerNameFilter) {

        this.explorerNameFilter = explorerNameFilter;

    }

    public JComponent asJComponent() {

        return this;

    }

    protected Map<String,DBServerExplorerParameters> getUserConections() {

        PluginsManager pluginsManager = PluginsLocator.getManager();

        ExtDB_Spatial geodbExtension = pluginsManager.getExtension(ExtDB_Spatial.class);

        Map<String, DBServerExplorerParameters> connections = geodbExtension.getUserConnections();

        if( this.explorerNameFilter == null ) {

            return connections;

        }

        Map<String,DBServerExplorerParameters> filteredConnections = new HashMap<String,DBServerExplorerParameters>();

        Iterator<Map.Entry<String,DBServerExplorerParameters>> it = connections.entrySet().iterator();

        while( it.hasNext() ) {

            Map.Entry<String,DBServerExplorerParameters> entry = it.next();

            if( this.explorerNameFilter.equalsIgnoreCase(entry.getValue().getExplorerName()) ) {

                filteredConnections.put(entry.getKey(), entry.getValue());

            }

        }

        return filteredConnections;

    }

    protected void initComponents() {

    }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

 * 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 3 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., 51

 * Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us at info AT

 * gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.postgresql.exportto;

import org.cresques.cts.IProjection;

import org.gvsig.exportto.ExporttoService;

import org.gvsig.exportto.swing.prov.jdbc.ExporrtoJDBCService;

import org.gvsig.exportto.swing.prov.jdbc.panel.JDBCConnectionPanel;

import org.gvsig.exportto.swing.spi.ExporttoSwingProvider;

import org.gvsig.exportto.swing.spi.ExporttoSwingProviderPanel;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.fmap.dal.feature.FeatureType;

import org.gvsig.tools.service.spi.AbstractProvider;

import org.gvsig.tools.service.spi.ProviderServices;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.postgresql.exportto.panel.SelectPkPanel;

import org.gvsig.postgresql.exportto.panel.SelectTableNamePanel;

/**

 * Exporto provider which gets Exporto from a file.

 *

 * @author gvSIG Team

 * @version $Id$

 */

public class ExporttoPostgreSQLProvider extends AbstractProvider

        implements ExporttoSwingProvider {

    private static Logger logger = LoggerFactory.getLogger(

            ExporttoPostgreSQLProvider.class);

    protected SelectTableNamePanel selectTableNamePanel = null;

    protected SelectPkPanel selectPkPanel = null;

    protected JDBCConnectionPanel jdbcConnectionPanel = null;

    protected FeatureStore featureStore;

    protected IProjection projection;

    /**

     * Constructor.

     *

     * @param providerServices the services for the provider

     * @param file to get the Exporto from

     */

    public ExporttoPostgreSQLProvider(ProviderServices providerServices,

            FeatureStore featureStore, IProjection projection) {

        super(providerServices);

        this.featureStore = featureStore;

        this.projection = projection;

        selectTableNamePanel = new SelectTableNamePanel();

        FeatureType ftype = null;

        try {

            ftype = featureStore.getDefaultFeatureType();

        } catch (Exception exc) {

            logger.error("While getting feature type.", exc);

        }

        selectPkPanel = new SelectPkPanel(ftype);

        jdbcConnectionPanel = new JDBCConnectionPanel();

    }

    public String getStoreName() {

        return "PostgreSQL";

    }

    public String getExplorerName() {

        return "PostgreSQLExplorer";

    }

    public int getPanelCount() {

        return 3;

    }

    public ExporttoSwingProviderPanel getPanelAt(int index) {

        switch (index) {

            case 0:

                return selectTableNamePanel;

            case 1:

                return selectPkPanel;

            case 2:

                return jdbcConnectionPanel;

        }

        return null;

    }

    public ExporttoService createExporttoService() {

        ConnectionSettings connectionSettings

                = jdbcConnectionPanel.getConnectionSettings();

        int port = -1;

        if (connectionSettings.getPort() != null

                && connectionSettings.getPort().length() > 0) {

            port = Integer.valueOf(connectionSettings.getPort());

        }

        String schema = null;

        if (connectionSettings.getSchema() != null

                && connectionSettings.getSchema().length() > 0) {

            schema = connectionSettings.getSchema();

        }

        return new ExporrtoJDBCService(featureStore,

                connectionSettings.getDb(), schema, selectTableNamePanel.getText(),

                selectPkPanel.getText(), connectionSettings.getUser(),

                connectionSettings.getPassw(), connectionSettings.getHost(), port,

                getExplorerName(), getStoreName(), this.projection);

    }

}

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

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <artifactId>org.gvsig.postgresql.app.export</artifactId>

  <packaging>jar</packaging>

  <name>Export: PostgreSQL support</name>

  <description>Export support for PostgreSQL</description>

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.postgresql.app</artifactId>

      <version>2.0.21-SNAPSHOT</version>

  </parent>

  <dependencies>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.tools.lib</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.andami</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.exportto.lib.api</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.exportto.swing.api</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.exportto.swing.spi</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.exportto.swing.prov.jdbc</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.geodb.app.mainplugin</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>postgresql</groupId>

      <artifactId>postgresql</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-dbcp</groupId>

      <artifactId>commons-dbcp</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-collections</groupId>

      <artifactId>commons-collections</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-pool</groupId>

      <artifactId>commons-pool</artifactId>

      <scope>runtime</scope>

    </dependency>

  </dependencies>

    <properties>

        <!-- Package info property values -->

        <!-- Default values in org.gvsig.desktop -->

        <gvsig.package.info.state>testing</gvsig.package.info.state>

        <gvsig.package.info.official>true</gvsig.package.info.official>

        <gvsig.package.info.dependencies>required: org.gvsig.app.mainplugin -ge 2.0.1</gvsig.package.info.dependencies>

        <gvsig.package.info.categories>Formats,Vector,Database</gvsig.package.info.categories>

        <gvsig.package.info.poolURL>http://devel.gvsig.org/download/projects/gvsig-postgresql/pool/</gvsig.package.info.poolURL>

    </properties>

</project>

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

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <artifactId>org.gvsig.postgresql.app.mainplugin</artifactId>

  <packaging>jar</packaging>

  <name>Formats: PostgreSQL support</name>

  <description>PostgreSQL file format support</description>

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.postgresql.app</artifactId>

      <version>2.0.21</version>

  </parent>

  <dependencies>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.tools.lib</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.andami</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.postgresql.provider</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>postgresql</groupId>

      <artifactId>postgresql</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-dbcp</groupId>

      <artifactId>commons-dbcp</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-collections</groupId>

      <artifactId>commons-collections</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-pool</groupId>

      <artifactId>commons-pool</artifactId>

      <scope>runtime</scope>

    </dependency>

  </dependencies>

    <properties>

        <!-- Package info property values -->

        <!-- Default values in org.gvsig.desktop -->

        <gvsig.package.info.state>testing</gvsig.package.info.state>

        <gvsig.package.info.official>true</gvsig.package.info.official>

        <gvsig.package.info.dependencies>required: org.gvsig.app.mainplugin -ge 2.0.1</gvsig.package.info.dependencies>

        <gvsig.package.info.categories>Formats,Vector,Database</gvsig.package.info.categories>

        <gvsig.package.info.poolURL>https://devel.gvsig.org/download/projects/gvsig-postgresql/pool/</gvsig.package.info.poolURL>

    </properties>

</project>

#Tue Oct 08 20:52:46 CEST 2013

buildNumber=2078

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugin-config>

  <libraries library-dir="lib/"/>

  <depends plugin-name="org.gvsig.app.mainplugin"/>

  <resourceBundle name="text"/>

  <extensions>

     <extension class-name="org.gvsig.andami.LibraryExtension" active="false"/>

  </extensions>    

</plugin-config>

<assembly>

  <id>gvsig-plugin-package</id>

  <formats>

    <format>zip</format>

  </formats>

  <baseDirectory>${project.artifactId}</baseDirectory>

  <includeBaseDirectory>true</includeBaseDirectory>

  <files>

    <file>

      <source>target/${project.artifactId}-${project.version}.jar</source>

      <outputDirectory>lib</outputDirectory>

    </file>

    <file>

      <source>target/package.info</source>

    </file>

    <file>

      <source>src/main/resources-plugin/config.xml</source>

    </file>

  </files>

  <dependencySets>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

        <include>org.gvsig:org.gvsig.postgresql.provider</include>

      </includes>

    </dependencySet>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

		<include>postgresql:postgresql</include>

		<include>commons-dbcp:commons-dbcp</include>

		<include>commons-collections:commons-collections</include>

		<include>commons-pool:commons-pool</include>

      </includes>

    </dependencySet>

  </dependencySets>

</assembly>

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

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <artifactId>org.gvsig.postgresql.app</artifactId>

  <packaging>pom</packaging>

  <name>${project.artifactId}</name>

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.postgresql</artifactId>

      <version>2.0.21</version>

  </parent>

  <modules>

    <module>org.gvsig.postgresql.app.mainplugin</module>

    <!--

    <module>org.gvsig.postgresql.app.export</module>

    -->

  </modules>

</project>

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

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <artifactId>org.gvsig.postgresql</artifactId>

  <version>2.0.21</version>

  <packaging>pom</packaging>

  <name>${project.artifactId}</name>

  <description>PostgreSQL support fort DAL and gvSIG</description>

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.desktop</artifactId>

      <version>2.0.42</version>

  </parent>

  <url>https://devel.gvsig.org/redmine/projects/gvsig-postgresql</url>

  <scm>

      <connection>scm:svn:https://devel.gvsig.org/svn/gvsig-postgresql/tags/org.gvsig.postgresql-2.0.21</connection>

      <developerConnection>scm:svn:https://devel.gvsig.org/svn/gvsig-postgresql/tags/org.gvsig.postgresql-2.0.21</developerConnection>

      <url>https://devel.gvsig.org/redmine/projects/gvsig-postgresql/repository/show/tags/org.gvsig.postgresql-2.0.21</url>

  </scm>

    <repositories>

        <repository>

            <id>gvsig-public-http-repository</id>

            <name>gvSIG maven public HTTP repository</name>

            <url>http://devel.gvsig.org/m2repo/j2se</url>

            <releases>

                <enabled>true</enabled>

                <updatePolicy>daily</updatePolicy>

                <checksumPolicy>warn</checksumPolicy>

            </releases>

            <snapshots>

                <enabled>true</enabled>

                <updatePolicy>daily</updatePolicy>

                <checksumPolicy>warn</checksumPolicy>

            </snapshots>

        </repository>

    </repositories>

	<build>

		<plugins>

			<plugin>

				<groupId>org.apache.maven.plugins</groupId>

				<artifactId>maven-release-plugin</artifactId>

				<configuration>

					<tagBase>https://devel.gvsig.org/svn/gvsig-postgresql/tags/</tagBase>

					<goals>deploy</goals>

				</configuration>

			</plugin>

		</plugins>

	</build>

  <dependencyManagement>

      <dependencies>

          <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.postgresql.provider</artifactId>

            <version>2.0.21</version>

          </dependency>

          <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.postgresql.app.mainplugin</artifactId>

            <version>2.0.21</version>

          </dependency>

      </dependencies>

  </dependencyManagement>

  <dependencies>

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-api</artifactId>

            <scope>compile</scope>

        </dependency>

  </dependencies>

  <modules>

    <module>org.gvsig.postgresql.app</module>

    <module>org.gvsig.postgresql.provider</module>

  </modules>

</project>

/* gvSIG. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

* 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., 51 Franklin Street, Fifth Floor, Boston,

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

/**

 *

 */

package org.gvsig.fmap.dal.store.postgresql;

import java.util.Iterator;

import org.gvsig.fmap.dal.DataStoreParameters;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.feature.BaseTestEditableFeatureStore;

import org.gvsig.fmap.dal.feature.EditableFeatureAttributeDescriptor;

import org.gvsig.fmap.dal.feature.EditableFeatureType;

import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor;

import org.gvsig.fmap.dal.feature.FeatureQuery;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.fmap.dal.feature.FeatureStoreTransform;

import org.gvsig.fmap.dal.feature.FeatureType;

import org.gvsig.fmap.dal.feature.NewFeatureStoreParameters;

import org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorer;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.operation.towkt.ToWKT;

import org.gvsig.tools.evaluator.Evaluator;

import org.gvsig.tools.evaluator.EvaluatorData;

import org.gvsig.tools.evaluator.EvaluatorException;

import org.gvsig.tools.evaluator.EvaluatorFieldsInfo;

/**

 * @author jmvivo

 *

 */

// public class TestPostgreSQL extends BaseTestEditableFeatureStore {

public class TestPostgreSQLWrite extends BaseTestEditableFeatureStore {

	private JDBCServerExplorer myExplorer;

	private PostgreSQLNewStoreParameters newParams;

	@Override

	protected void doSetUp() throws Exception {

		// Initialize wkt geom operation

		int wktCode = ToWKT.CODE;

	}

	public DataStoreParameters getDefaultDataStoreParameters()

			throws DataException {

		PostgreSQLStoreParameters pgParameters = null;

		pgParameters = (PostgreSQLStoreParameters) dataManager

				.createStoreParameters(PostgreSQLStoreProvider.NAME);

		pgParameters.setHost("localhost");

		pgParameters.setUser("postgres");

		pgParameters.setPassword("postgres");

		pgParameters.setDBName("gis");

		pgParameters.setTable("muni10000_peq");

		return pgParameters;

	}

	public boolean hasExplorer() {

		return true;

	}

	public void testLoadMetadata() throws Exception {

		DataStoreParameters params = this.getDefaultDataStoreParameters();

		FeatureStore store = null;

		store = (FeatureStore) dataManager.createStore(params);

		FeatureType fType = store.getDefaultFeatureType();

		FeatureAttributeDescriptor geomAttr;

		if (fType.getDefaultGeometryAttributeIndex() >= 0) {

			assertNotNull(store.getEnvelope());

			geomAttr = fType.getAttributeDescriptor(fType

					.getDefaultGeometryAttributeIndex());

			assertTrue(geomAttr.getGeometryType() == Geometry.TYPES.MULTISURFACE);

			assertTrue(geomAttr.getGeometrySubType() == Geometry.SUBTYPES.GEOM2D);

			assertNotNull(store.getDynValue("CRS"));

		}

	}

	public void testCloserConnection() throws Exception {

		DataStoreParameters params = this.getDefaultDataStoreParameters();

		FeatureStore store = null;

		store = (FeatureStore) dataManager.createStore(params);

		FeatureQuery query = store.createFeatureQuery();

		query.getOrder().add("gid", true);

		query.setFilter(new Evaluator() {

			public Object evaluate(EvaluatorData data)

					throws EvaluatorException {

				// TODO Auto-generated method stub

				return Boolean.TRUE;

			}

			public String getSQL() {

				return "true = true";

			}

			public String getDescription() {

				// TODO Auto-generated method stub

				return null;

			}

			public String getName() {

				return "AlwaysTrue";

			}

			public EvaluatorFieldsInfo getFieldsInfo() {

				// TODO Auto-generated method stub

				return null;

			}

		});

		FeatureStoreTransform transform = new StringsToLowerTransform();

		transform.setFeatureStore(store);

		store.getTransforms().add(transform);

		transform = new StringsToLowerTransform();

		transform.setFeatureStore(store);

		store.getTransforms().add(transform);

		transform = new StringsToLowerTransform();

		transform.setFeatureStore(store);

		store.getTransforms().add(transform);

		for (int i = 0; i < 30; i++) {

			// this.fullStoreIteratorTest(store);

			this.testIterationFastAndStandart(store, query);

		}

		store.dispose();

	}

	public boolean usesResources() {

		return true;

	}

	public NewFeatureStoreParameters getDefaultNewDataStoreParameters()

			throws Exception {

		PostgreSQLStoreParameters parameters = (PostgreSQLStoreParameters) this

				.getDefaultDataStoreParameters();

		FeatureStore store = null;

		if (this.myExplorer == null) {

			store = (FeatureStore) dataManager.createStore(parameters);

			myExplorer = (JDBCServerExplorer) store.getExplorer();

		}

		if (this.newParams == null) {

			if (store == null){

				store = (FeatureStore) dataManager.createStore(parameters);

			}

			newParams = (PostgreSQLNewStoreParameters) myExplorer

					.getAddParameters();

			newParams.setTable(parameters.getTable() + "_test");

			FeatureType ftOrg = store.getDefaultFeatureType();

			EditableFeatureType ftTrg = (EditableFeatureType) newParams

					.getDefaultFeatureType();

			FeatureAttributeDescriptor org;

			EditableFeatureAttributeDescriptor trg;

			Iterator iter = ftOrg.iterator();

			while (iter.hasNext()) {

				org = (FeatureAttributeDescriptor) iter.next();

				trg = ftTrg.add(org.getName(), org.getType());

				trg.setAllowNull(org.allowNull());

				trg.setDefaultValue(org.getDefaultValue());

				trg.setGeometrySubType(org.getGeometrySubType());

				trg.setGeometryType(org.getGeometryType());

				trg.setIsAutomatic(org.isAutomatic());

				trg.setIsPrimaryKey(org.isPrimaryKey());

				trg.setIsReadOnly(org.isReadOnly());

				trg.setMaximumOccurrences(org.getMaximumOccurrences());

				trg.setMinimumOccurrences(org.getMinimumOccurrences());

				trg.setPrecision(org.getPrecision());

				trg.setSize(org.getSize());

				trg.setSRS(org.getSRS());

			}

			ftTrg.setDefaultGeometryAttributeName(ftOrg

					.getDefaultGeometryAttributeName());

			ftTrg.setHasOID(ftOrg.hasOID());

		}

		if (store != null){

			store.dispose();

		}

		return this.newParams;

	}

	public boolean resourcesNotifyChanges() {

		return false;

	}

}

/* gvSIG. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

* 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., 51 Franklin Street, Fifth Floor, Boston,

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

package org.gvsig.fmap.dal.store.postgresql;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.MessageFormat;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.GeometryLocator;

import org.gvsig.fmap.geom.GeometryManager;

import org.gvsig.fmap.geom.operation.fromwkb.FromWKB;

import org.gvsig.fmap.geom.operation.fromwkb.FromWKBGeometryOperationContext;

import org.gvsig.fmap.geom.operation.towkb.ToWKB;

import org.gvsig.fmap.geom.operation.towkt.ToWKT;

import org.gvsig.fmap.geom.primitive.impl.Point2D;

import org.gvsig.tools.junit.AbstractLibraryAutoInitTestCase;

public class TestReadAndWriteGeom extends AbstractLibraryAutoInitTestCase {

	private static final int FEATURES_TO_INSERT = 12000;

	private static final String TABLE_NAME_INSERT = "testReadadnwritegeom_testcase";

	private static final String FIELD_NAME_INSERT = "geom";

	private Connection conn;

	private GeometryManager geoManager;

	private static String SQL_FOR_READ_TEST = "Select {0} from medio_ejes";

	@Override

	protected void doSetUp() throws Exception {

		geoManager = GeometryLocator.getGeometryManager();

		Class klass = Class.forName(PostgreSQLLibrary.DEFAULT_JDCB_DRIVER_NAME);

		if (klass == null) {

			throw new Exception("Driver not found: "

					+ PostgreSQLLibrary.DEFAULT_JDCB_DRIVER_NAME);

		}

		// inicializamos operaciones de geometrias de las que dependemos

		int code = FromWKB.CODE;

		code = ToWKB.CODE;

		code = ToWKT.CODE;

		conn = DriverManager.getConnection(PostgreSQLLibrary.getJdbcUrl(

				"localhost", 5432, "gis"), "postgres", "postgres");

	}

	public void testInsertWKB() throws Exception {

		PreparedStatement pst = null;

		try {

			crearTablaTest();

			Point2D geom = (Point2D) geoManager.createPoint(0, 0,

					Geometry.SUBTYPES.GEOM2D);

			pst = conn.prepareStatement(

					"Insert into "

					+ TABLE_NAME_INSERT.toLowerCase() +

					"  ("

					+ FIELD_NAME_INSERT + ") Values (GeomFromWKB(?))");

			int i;

			for (i = 1; i <= FEATURES_TO_INSERT; i++) {

				pst.clearParameters();

				geom.setX(i);

				geom.setY(i);

				pst.setBytes(1,

					(byte[]) geom.invokeOperation(

							ToWKB.CODE,

							null)

					);

				pst.executeUpdate();

			}

			System.out

					.println("TestReadAndWriteGeom.testInsertPostgis() Inserteds= i");

		} finally {

			if (pst != null) {

				try {pst.close();} catch (SQLException e) {e.printStackTrace();}

			}

		}

	}

	private void crearTablaTest() throws SQLException {

		execute("DROP TABLE IF EXISTS " + TABLE_NAME_INSERT.toLowerCase());

		execute("Delete from geometry_columns  where  f_table_name = '"

				+ TABLE_NAME_INSERT.toLowerCase() + "'");

		execute("CREATE TABLE " + TABLE_NAME_INSERT.toLowerCase()

				+ " (id serial PRIMARY KEY)");

		execute("Select AddGeometryColumn('" + TABLE_NAME_INSERT.toLowerCase()

				+ "','"

				+ FIELD_NAME_INSERT + "',-1,'GEOMETRY',2)");

	}

	private void execute(String sql) throws SQLException {

		Statement st = null;

		try {

			st = conn.createStatement();

			st.execute(sql);

		} finally {

			if (st != null) {

				try {st.close();} catch (SQLException e) {e.printStackTrace();}

			}

		}

	}

	public String getSQLForRead(String geoColumn) {

		return MessageFormat.format(SQL_FOR_READ_TEST, geoColumn);

	}

	public void testReadBinary() throws Exception {

		// st.execute("declare " + getTableName() + myCursorId +

		// "_wkb_cursor binary scroll cursor with hold for " + sqlAux);

		// rs = st.executeQuery("fetch forward " + FETCH_SIZE+ " in " +

		// getTableName() + myCursorId + "_wkb_cursor");

		Statement st = null;

		ResultSet rs = null;

		long count = 0;

		Geometry geom;

		Geometry nullGeom = geoManager.createNullGeometry(Geometry.SUBTYPES.GEOM2D);

		try {

			st = conn.createStatement();

			String cursorName = "myCursor___xxx";

			st.execute("declare " + cursorName

					+ "_wkb_cursor binary scroll cursor with hold for "

					+ getSQLForRead("the_geom"));

			rs = st.executeQuery("fetch forward all in " + cursorName

					+ "_wkb_cursor");

			byte[] buff;

			FromWKBGeometryOperationContext opContext = new FromWKBGeometryOperationContext();

			while (rs.next()) {

				count++;

				buff = rs.getBytes(1);

//				if (buff != null) {

//					opContext.setData(buff);

//					geom = (Geometry) nullGeom.invokeOperation(FromWKB.CODE,

//							opContext);

//					assertNotNull(geom);

//				}

			}

			System.out

					.println("TestReadAndWriteGeom.testReadPostgis() Count = "

							+ count);

		} finally {

			if (st != null) {

				try {

					st.close();

				} catch (SQLException e) {

					e.printStackTrace();

				}

			}

			if (rs != null) {

				try {

					rs.close();

				} catch (SQLException e) {

					e.printStackTrace();

				}

			}

		}

	}

	public void testReadWKB() throws Exception {

		Statement st = null;

		ResultSet rs = null;

		long count = 0;

		Geometry geom;

		Geometry nullGeom = geoManager

				.createNullGeometry(Geometry.SUBTYPES.GEOM2D);

		byte[] buff;

		FromWKBGeometryOperationContext opContext = new FromWKBGeometryOperationContext();

		try {

			st = conn.createStatement();

			rs = st.executeQuery(getSQLForRead("asBinary(the_geom)"));

			while (rs.next()) {

				count++;

				buff = rs.getBytes(1);

//				if (buff != null) {

//					opContext.setData(buff);