Application: gvSIG desktop

<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/maven-v4_0_0.xsd">

	<modelVersion>4.0.0</modelVersion>

	<groupId>org.gvsig</groupId>

	<artifactId>extJDBC</artifactId>

	<packaging>jar</packaging>

	<version>1.9-SNAPSHOT</version>

	<name>extJDBC</name>

	<url>http://maven.apache.org</url>

	<parent>

		<groupId>org.gvsig</groupId>

		<artifactId>gvsig-extension-base-pom

		</artifactId>

		<version>1.9-SNAPSHOT</version>

	</parent>

	<dependencies>

		<dependency>

			<groupId>org.gvsig</groupId>

			<artifactId>_fwAndami</artifactId>

			<version>1.9-SNAPSHOT</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

			<artifactId>appgvSIG</artifactId>

			<version>1.9-SNAPSHOT</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

			<artifactId>libFMap</artifactId>

			<version>1.9-SNAPSHOT</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

			<artifactId>libDriverManager</artifactId>

			<version>1.9-SNAPSHOT</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig.legacy</groupId>

			<artifactId>gdbms-0.8-SNAPSHOT</artifactId>

			<version>gvsig</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

			<artifactId>libIverUtiles</artifactId>

			<version>1.9-SNAPSHOT</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig.legacy</groupId>

			<artifactId>jts</artifactId>

			<version>gvsig</version>

		</dependency>

		<dependency>

			<groupId>mysql</groupId>

			<artifactId>mysql-connector-java</artifactId>

			<version>3.1.11</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

			<artifactId>libProjection</artifactId>

			<version>1.9-SNAPSHOT</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

			<artifactId>libExceptions</artifactId>

			<version>1.9-SNAPSHOT</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig.legacy</groupId>

			<artifactId>postgis</artifactId>

			<version>gvsig</version>

		</dependency>

		<dependency>

			<groupId>org.gvsig.legacy</groupId>

			<artifactId>postgresql</artifactId>

			<version>gvsig</version>

		</dependency>

	</dependencies>

	<properties>

		<extension-distribution>

			gvSIG/extensiones/com.iver.cit.gvsig.jdbc_spatial/

		</extension-distribution>

		<gvsig-extension-distribution> gvSIG/extensiones/com.iver.cit.gvsig/

		</gvsig-extension-distribution>

		<extension-appgvsig-lib-dir> ${extension-dir}/com.iver.cit.gvsig/lib/

		</extension-appgvsig-lib-dir>

		<build-dir>${basedir}/../build</build-dir>

		<library-dir>.</library-dir>

		<!--		 Path to the output directory for the distribution -->

		<extension-distribution-output-directory>target/

		</extension-distribution-output-directory>

		<distribution-output-directory>distribution/

		</distribution-output-directory>

		<!-- Path to the file descriptor to generate the extension-->

		<extension-distribution-file>distribution/distribution.xml

		</extension-distribution-file>

		<!-- Final name of the output directory for the distribution -->

		<distribution-final-name>jdbc_spatial

		</distribution-final-name>

		<application-name>jdbc_spatial</application-name>

		<output-dir_installers>target/intallers/

		</output-dir_installers>

	</properties>

	<build>

		<sourceDirectory>src</sourceDirectory>

		<!--		<testSourceDirectory>src-test</testSourceDirectory>-->

		<resources>

			<resource>

				<directory>src</directory>

				<includes>

					<include>**/*.gif</include>

					<include>**/*.png</include>

					<include>**/*.PNG</include>

					<include> **/*.bmp</include>

					<include> **/*.jpg</include>

					<include> **/*.jpeg</include>

					<include> **/*.xml</include>

				</includes>

			</resource>

		</resources>

		<plugins>

			<plugin>

				<artifactId>maven-clean-plugin</artifactId>

				<configuration>

					<filesets>

						<fileset>

							<directory> ${gvsig-path}/${extension-distribution}</directory>

							<includes>

								<include>**</include>

							</includes>

						</fileset>

					</filesets>

				</configuration>

			</plugin>

		</plugins>

	</build>

	<profiles>

		<profile>

			<id>install-drivers</id>

			<activation>

				<property>

					<name>install-extension</name>

				</property>

			</activation>

			<build>

				<plugins>

					<plugin>

						<groupId>org.apache.maven.plugins

						</groupId>

						<artifactId>maven-jar-plugin</artifactId>

						<executions>

							<execution>

								<id>extension</id>

								<phase>install</phase>

								<goals>

									<goal>jar</goal>

								</goals>

								<configuration>

									<classifier>gvsig-lib</classifier>

									<includes>

										<include>**/drivers/jdbc/**</include>

										<include>**/drivers/jdbc/postgis/**

										</include>

										<include>**/drivers/jdbc/mysql/**

										</include>

									</includes>

									<outputDirectory>

										${extension-appgvsig-lib-dir}

									</outputDirectory>

								</configuration>

							</execution>

							<execution>

								<id>gvsig</id>

								<phase>install</phase>

								<goals>

									<goal>jar</goal>

								</goals>

								<configuration>

									<classifier>gvsig-driver</classifier>

									<includes>

										<include>**/drivers/jdbc/**</include>

										<include>**/drivers/jdbc/postgis/**

										</include>

										<include>**/drivers/jdbc/mysql/**

										</include>

									</includes>

									<!--

										excludes> <exclude>**/org/gvsig/raster/gui/wizards/**

										</exclude> </excludes

									-->

									<outputDirectory>${extension-appgvsig-lib-dir}/../drivers/

									</outputDirectory>

								</configuration>

							</execution>

							<execution>

								<id> fmap</id>

								<phase>install</phase>

								<goals>

									<goal>jar</goal>

								</goals>

								<configuration>

									<classifier>extension</classifier>

									<includes>

										<include>**/com/iver/cit/gvsig/**

										</include>

									</includes>

									<excludes>

										<exclude>**/com/iver/cit/gvsig/fmap/drivers/**

										</exclude>

									</excludes>

									<outputDirectory>

										${gvsig-path}/${extension-distribution}/${library-dir}

									</outputDirectory>

								</configuration>

							</execution>

						</executions>

					</plugin>

				</plugins>

			</build>

		</profile>

	</profiles>

</project>

bin

bin-test

<project name="extJDBC" default="generate-without-source" basedir=".">

    <description>

        Instala el plugin en Andami

    </description>

  <!-- set global properties for this build -->

  <property name="src" location="src"/>

  <property name="build" location="bin"/>

  <property name="src-test" location="src-test"/>

  <property name="build-test" location="bin-test"/>

  <property name="dist"  location="dist"/>

  <property name="lib"  location="lib"/>

  <property name="mainplugin" value="com.iver.cit.gvsig"/>

  <property name="plugin" value="com.iver.cit.gvsig.jdbc_spatial"/>

  <property name="driverjar" value="jdbc_spatial"/>

	<property name="andami" location="../_fwAndami"/>

	<property name="extensionsDir" location="${andami}/gvSIG/extensiones"/>

  	<property name="drivers-dir" location="${extensionsDir}/${mainplugin}/drivers/jdbc_spatial" />

	<property name="lib-dir" location="${extensionsDir}/${mainplugin}/lib"/>

	<import file="../binaries/ant/utilities.xml"/>

  <target name="init">

    <!-- Create the time stamp -->

    <tstamp/>

	<echo>

		Compiling ${ant.project.name}...</echo>

    <!-- Create the build directory structure used by compile -->

    <mkdir dir="${build}"/>

    <mkdir dir="${dist}"/>

	<mkdir dir="${drivers-dir}" />

  </target>

  <target name="generate-without-source"

  		description="generate the distribution without the source file"

  	depends="init,create-jar,copy-data-files,copy-to-andami,clean-dist">

  </target>

	<target name="batch-build"

			description="compile the sources, create the jar file"

			depends="init,compile,create-jar,copy-data-files,copy-to-andami">

	</target>

	<target name="compile" description="compile the source" >

		<antcall target="gvSIG-import-build-number"/>

		<!-- Compile the Java code from ${src} to ${build} -->

		<mkdir dir="${build}" />

		<loadEclipseClasspath project="${basedir}"/>

		<gvSIG-javac

			classpath="${eclipseClasspath}"

		/>

	</target>

	<target name="create-jar"

			description="Creates the plugin jar">

	  	<jar jarfile="${dist}/${driverjar}.jar" basedir="${build}"

	  		includes="com/iver/cit/gvsig/fmap/drivers/jdbc/*.class com/iver/cit/gvsig/fmap/drivers/jdbc/postgis/** com/iver/cit/gvsig/fmap/drivers/jdbc/mysql/**"

	  	/>

	  	<jar jarfile="${dist}/${driverjar}-driver.jar" basedir="${build}"

	  		includes="com/iver/cit/gvsig/fmap/drivers/jdbc/*.class com/iver/cit/gvsig/fmap/drivers/jdbc/postgis/** com/iver/cit/gvsig/fmap/drivers/jdbc/mysql/**"

	  	/>

	    <jar jarfile="${dist}/${plugin}.jar" basedir="${build}"

	    	includes="com/iver/cit/gvsig/** "

	    	excludes="com/iver/cit/gvsig/fmap/drivers/**" />

	</target>

	<target name="copy-data-files">

	    <copy file="config/config.xml" todir="${dist}"/>

		<copy file="build.number" todir="${dist}"/>

		<copy todir="${dist}">

			<fileset dir="config" includes="text*.properties"/>

		</copy>

		<copy todir="${dist}/images">

			<fileset dir="images/" includes="*"/>

		</copy>

	</target>

	<target name="copy-to-andami">

		<copy file="build.number" todir="${extensionsDir}/${plugin}"/>

	  	<copy todir="${drivers-dir}">

	  		<fileset dir="${dist}" includes="${driverjar}.jar"/>

	 	</copy>

	    <copy todir="${extensionsDir}/${plugin}/">

	    	<fileset dir="${dist}" excludes="${driverjar}.jar,${driverjar}-driver.jar"/>

	    </copy>

	    <copy todir="${lib-dir}">

	    	<fileset dir="${dist}" includes="${driverjar}-driver.jar"/>

	    </copy>

	</target>

	<target name="clean-dist">

	    <delete dir="${dist}"/>

	</target>

  <target name="clean"

        description="clean up" >

    <!-- Delete the ${build} and ${dist} directory trees -->

    <delete dir="${dist}"/>

    <delete dir="${build}"/>

  </target>

	<target name="run-tests" depends="batch-build,compile-tests">

		<antcall target="generic-run-tests">

			<param name="TestSuite.Name" value="org.gvsig.remoteClient.AllTests"/>

		</antcall>

	</target>

</project>

<assembly>

	<id>distribution</id>

	<formats>

		<format>dir</format>

	</formats>

	<fileSets>

	<!-- Extructure for the extension -->

		<fileSet>

			<directory>config</directory>

			<outputDirectory>${extension-distribution}

			</outputDirectory>

		</fileSet>

		<fileSet>

			<directory>data</directory>

			<outputDirectory>${extension-distribution}/data

			</outputDirectory>

		</fileSet>

		<fileSet>

			<directory>images</directory>

			<outputDirectory>/${extension-distribution}/images

			</outputDirectory>

		</fileSet>

	<!-- Extructure for the native libraries -->

<!--	<fileSet>-->

<!--      <directory>${basedir}/../binaries/linux/3D/</directory>-->

<!--	  <outputDirectory>/linux/lib</outputDirectory>-->

<!--    </fileSet>-->

	</fileSets>

	<files>

		<file>

			<source>build.number</source>

			<outputDirectory>${extension-distribution}

			</outputDirectory>

		</file>

	</files>

	<!--

		***********************************************************************

	-->

  <!-- *													   *-->

	<!--

		***********************************************************************

	-->

</assembly>

<?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 kind="lib" path="/libFMap/lib/gdbms-0.8-SNAPSHOT.jar"/>

	<classpathentry kind="lib" path="/libFMap/lib/mysql-connector-java-3.1.7-bin.jar"/>

	<classpathentry kind="lib" path="/libFMap/lib/postgis-jdbc-driver.jar"/>

	<classpathentry kind="lib" path="/libFMap/lib/postgresql-74.213.jar"/>

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

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

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

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

	<classpathentry kind="lib" path="/_fwAndami/lib/log4j-1.2.8.jar"/>

	<classpathentry kind="lib" path="/libFMap/lib/driver-manager-1.1.jar"/>

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

	<classpathentry kind="var" path="JUNIT_HOME/junit.jar"/>

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

	<classpathentry kind="lib" path="/libFMap/lib/jts-1.9.jar"/>

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

</classpath>

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

<projectDescription>

	<name>extJDBC</name>

	<comment></comment>

	<projects>

	</projects>

	<buildSpec>

		<buildCommand>

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

			<arguments>

			</arguments>

		</buildCommand>

		<buildCommand>

			<name>de.loskutov.FileSync.FSBuilder</name>

			<arguments>

			</arguments>

		</buildCommand>

	</buildSpec>

	<natures>

		<nature>org.eclipse.jem.workbench.JavaEMFNature</nature>

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

		<nature>org.eclipse.jem.beaninfo.BeanInfoNature</nature>

	</natures>

</projectDescription>

package com.iver.cit.gvsig.jdbc_spatial;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import junit.framework.TestCase;

import com.hardcode.gdbms.driver.exceptions.ReadDriverException;

import com.hardcode.gdbms.engine.values.NumericValue;

import com.iver.cit.gvsig.fmap.drivers.ConnectionFactory;

import com.iver.cit.gvsig.fmap.drivers.ConnectionJDBC;

import com.iver.cit.gvsig.fmap.drivers.DBLayerDefinition;

import com.iver.cit.gvsig.fmap.drivers.IConnection;

import com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver;

public class testPostGIS extends TestCase {

	PostGisDriver driver = new PostGisDriver();

	ResultSet rsGood = null;

	protected void setUp() throws Exception {

		super.setUp();

		try {

			String dburl = "jdbc:postgresql://localhost/latin1";

			String dbuser = "postgres";

			String dbpass = "aquilina";

			// String dburl = "jdbc:postgresql://192.168.0.217/postgis";

			// String dbuser = "gvsig";

			// String dbpass = "";

			// String dbtable = "carreteras_lin_5k_t10";

			String dbtable = "provin"; // OJO CON LAS MAYUSCULAS!!!!!!!

			IConnection conn = null;

			System.out.println("Creating JDBC connection...");

			Class.forName("org.postgresql.Driver");

			conn = ConnectionFactory.createConnection(dburl, dbuser, dbpass);

			((ConnectionJDBC)conn).getConnection().setAutoCommit(false);

			DBLayerDefinition lyrDef = new DBLayerDefinition();

			lyrDef.setName(dbtable);

			lyrDef.setTableName(dbtable);

			lyrDef.setWhereClause("");

			String[] fields = {"nom_provin", "gid"};

			lyrDef.setFieldNames(fields);

			lyrDef.setFieldGeometry("the_geom");

			lyrDef.setFieldID("gid");

			Statement st = ((ConnectionJDBC)conn).getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

			rsGood = st.executeQuery("SELECT NOM_PROVIN, GID FROM " + dbtable + " ORDER BY GID");

			driver.setData(conn, lyrDef);

		}

		catch (Exception e){

			e.printStackTrace();

		}

	}

	protected void tearDown() throws Exception {

		super.tearDown();

		driver.close();

	}

	/*

	 * Test method for

	 * 'com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver.getFieldValue(long,

	 * int)'

	 */

	public void testGetFieldValue() {

		int pos1 = 1;

		int pos2 = 30;

		int pos3 = 15;

		try {

			for (int i=0; i < 40; i++)

			{

				rsGood.absolute(i+1);

				System.out.println("GOOD:" + rsGood.getInt(2) + " " + rsGood.getString(1));

				String aux = driver.getFieldValue(i, 0).toString();

				int id = ((NumericValue) driver.getFieldValue(i, 1)).intValue();

				System.out.println(id + " " + aux);

			}

			rsGood.absolute(pos1);

			String str2 = driver.getFieldValue(pos1-1, 0).toString();

			String str1 = rsGood.getString(1);

			System.out.println(str1 + " - " + str2);

			assertEquals(str1, str2);

			rsGood.absolute(pos2);

			str2 = driver.getFieldValue(pos2-1, 0).toString();

			str1 = rsGood.getString(1);

			int id1 = rsGood.getInt(2);

			int id2 = ((NumericValue) driver.getFieldValue(pos2-1, 1)).intValue();

			System.out.println(id1 + " " + str1 + " - " + id2 + " " + str2);

			assertEquals(id1, id2);

			rsGood.absolute(pos3);

			str2 = driver.getFieldValue(pos3-1, 0).toString();

			str1 = rsGood.getString(1);

			System.out.println(str1 + " - " + str2);

			assertEquals(str1, str2);

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (ReadDriverException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}

package com.iver.cit.gvsig.jdbc_spatial;

import junit.framework.Test;

import junit.framework.TestSuite;

public class AllTests {

	public static Test suite() {

		TestSuite suite = new TestSuite(

				"Test for com.iver.cit.gvsig.jdbc_spatial");

		//$JUnit-BEGIN$

		suite.addTestSuite(testPostGIS.class);

		//$JUnit-END$

		return suite;

	}

}

#Translations for language [pt_BR]

#Mon Sep 21 10:02:07 CEST 2009

DBManager=Gestor de Banco de Dados

#Translations for language [fr]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=Espace de travail

aviso_sin_extent_de_referencia=Pour utiliser cette option, vous devez disposer d'une couche de r\u00e9f\u00e9rence.

back=Pr\u00e9c\u00e9dent

bd=bd

capa_importada=Couche g\u00e9ographique import\u00e9e. Voulez-vous cr\u00e9er un index spatial?

connection_name=Nom de la connexion

database_connection=Connexion \u00e0 une BD

DBManager=Gestionnaire de base de donn\u00e9es

driver=Pilote

error_conexion=Erreur de connexion \u00e0 la base de donn\u00e9es.

host=Machine

importar_extent=Importer l'extension de la vue

intro_tablename=D\u00e9finir le nom de la couche \u00e0 importer. ATTENTION\: Si la table existe d\u00e9j\u00e0, elle sera supprim\u00e9e.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Suivant

nombre_capa=Nom de la couche

password=Mot de passe

puerto=Port

seleccion_de_campos=S\u00e9lection des champs

seleccione_tabla=S\u00e9lectionnez la table

select_all=Tout s\u00e9lectionner

select_geom_field=S\u00e9lection la colonne g\u00e9ometrie

select_none=Tout supprimmer

select_unique_field=S\u00e9lectionner le champs unique

usuario=Utilisateur

where_clause=clause Where

#Translations for language [en_US]

#Mon Sep 21 10:02:07 CEST 2009

DBManager=Database manager

#Translations for language [eu]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=Lan eremua

aviso_sin_extent_de_referencia=Aukera hau erabiltzeko aurretik erreferentzia gisa erabiliko den beste geruza bat erantsita izan behar duzu.

back=Aurrekoa

bd=bd

capa_importada=Inportatutako geruza. Espazio-indizea sortu nahi duzu?

connection_name=Konexioaren izena

database_connection=Datu-base konexioa

DBManager=Datu-baseen kudeatzailea

driver=Driver

error_conexion=Errorea datu-basera konektatzean.

host=Ostalaria

importar_extent=Inportatu oraingo bistaren extent-a

intro_tablename=Sortuko duzun taularen izena sartu. OHARRA\: Taula aurretik badago, ezabatu egingo da.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Hurrengoa

nombre_capa=Geruzaren izena

password=Gakoa

puerto=Ataka

seleccion_de_campos=Eremuak hautatzea

seleccione_tabla=Hautatu taula

select_all=Hautatu dena

select_geom_field=Hautatu geometria duen eremua

select_none=Kendu denak

select_unique_field=Hautatu eremu bakarra

usuario=Erabiltzailea

where_clause=Where klausula

#Translations for language [nl]

#Tue Aug 11 10:49:14 CEST 2009

DBManager=

#Translations for language [pl]

#Thu Oct 29 12:16:22 CET 2009

DBManager=Manager bazy danych

#Translations for language [it]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=Area di lavoro

aviso_sin_extent_de_referencia=Per usare questa opzione \u00e9 necessario avere come minimo un layer gi\u00e0 aperto che serva da riferimento

back=Precedente

bd=Database

capa_importada=Layer importato, vuoi creare l'indice spaziale?

connection_name=Nome della connessione

database_connection=Connessione Database

DBManager=Gestore dei Database

driver=Driver

error_conexion=Errore nel connettersi al database

host=HOST

importar_extent=Importare l'estensione attuale della vista

intro_tablename=Inserisci il nome della tabella da creare. AVVISO\: Se la tabella esiste, si canceller\u00e0.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Successivo

nombre_capa=Nome del layer

password=Password

puerto=Porta

seleccion_de_campos=Selezione dei campi

seleccione_tabla=Seleziona la tabella

select_all=Seleziona tutto

select_geom_field=Seleziona il campo geometrico

select_none=Togli tutto

select_unique_field=Seleziona campo unico

usuario=Utente

where_clause=clausola dove

#Translations for language [ro]

#Mon Sep 21 10:02:07 CEST 2009

DBManager=Gestionar Baz\u0103 de Date

#Translations for language [es]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=\u00c1rea de trabajo

aviso_sin_extent_de_referencia=Para usar esta opci\u00f3n necesita tener como m\u00ednimo una capa ya a\u00f1adida que sirva de referencia.

back=Anterior

bd=bd

capa_importada=Capa importada. \u00bfDesea crear el \u00edndice espacial?

connection_name=Nombre de la conexi\u00f3n

database_connection=Conexi\u00f3n a Base de Datos

DBManager=Gestor de Base de datos

driver=Driver

error_conexion=Error al conectar a la base de datos.

host=M\u00e1quina

importar_extent=Importar el extent actual de la vista

intro_tablename=Introduzca el nombre de la tabla a crear. AVISO\: Si existe la tabla, se borrar\u00e1.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Siguiente

nombre_capa=Nombre de la capa

password=Clave

puerto=Puerto

seleccion_de_campos=Selecci\u00f3n de campos

seleccione_tabla=Selecciona la tabla

select_all=Seleccionar todo

select_geom_field=Selecciona el campo que lleva la geometr\u00eda

select_none=Quitar todos

select_unique_field=Seleccione el campo \u00fanico

usuario=Usuario

where_clause=Cl\u00e1usula where

#Translations for language [zh]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=\u5de5\u4f5c\u8303\u56f4

aviso_sin_extent_de_referencia=\u5fc5\u987b\u5df2\u6709\u56fe\u5c42\u4f5c\u4e3a\u53c2\u8003\uff0c\u624d\u53ef\u4ee5\u4f7f\u7528\u8fd9\u4e2a\u9009\u9879\u3002

back=\u540e\u9000

bd=\u6570\u636e\u5e93

capa_importada=\u56fe\u5c42\u5df2\u8f93\u5165\u3002\u60a8\u8981\u521b\u5efa\u7a7a\u95f4\u7d22\u5f15\u5417\uff1f

connection_name=\u8fde\u63a5

database_connection=\u6570\u636e\u5e93\u8fde\u63a5

DBManager=\u6570\u636e\u5e93\u7ba1\u7406\u5668

driver=\u9a71\u52a8\u7a0b\u5e8f

error_conexion=\u4e0e\u6570\u636e\u5e93\u8fde\u63a5\u65f6\u51fa\u9519

host=\u4e3b\u673a

importar_extent=\u8f93\u5165\u5f53\u524d\u89c6\u56fe\u6269\u5c55

intro_tablename=\u8f93\u5165\u65b0\u5efa\u8868\u683c\u540d\u79f0\u3002 \u6ce8\u610f\: \u5982\u679c\u8868\u683c\u5df2\u5b58\u5728, \u5b83\u5c06\u4f1a\u88ab\u5220\u9664\u3002

maxx=X\u8f74\u6700\u5927\u503c

maxy=Y\u8f74\u6700\u5927\u503c

minx=X\u8f74\u6700\u5c0f\u503c

miny=Y\u8f74\u6700\u5c0f\u503c

next=\u7ee7\u7eed

nombre_capa=\u56fe\u5c42\u540d\u79f0

password=\u5bc6\u7801

puerto=\u94fe\u63a5\u53e3

seleccion_de_campos=\u9009\u62e9\u5b57\u6bb5

seleccione_tabla=\u9009\u62e9\u8868\u683c

select_all=\u9009\u62e9\u5168\u90e8

select_geom_field=\u9009\u62e9\u5305\u542b\u51e0\u4f55\u7684\u5b57\u6bb5

select_none=\u5168\u90e8\u6e05\u9664

select_unique_field=\u9009\u62e9\u552f\u4e00\u5b57\u6bb5

usuario=\u7528\u6237

where_clause=Where \u5b50\u53e5

#Translations for language [pt]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=\u00c1rea de trabalho

aviso_sin_extent_de_referencia=Para usar esta op\u00e7\u00e3o necessita ter como m\u00ednimo uma capa j\u00e1 adicionada que sirva de referencia.

back=Anterior

bd=bd

capa_importada=Capa importada. Deseja criar o \u00edndice espacial?

connection_name=Nome da conex\u00e3o

database_connection=Liga\u00e7\u00e3o \u00e0 base de dados

DBManager=Gestor de base de dados

driver=Driver

error_conexion=Erro ao conectar \u00e0 base de dados.

host=M\u00e1quina

importar_extent=Importar a extens\u00e3o actual da vista

intro_tablename=Introduza o nome da tabela a criar. AVISO\: Se existe a tabela, vai ser apagada.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Seguinte

nombre_capa=Nome da capa

password=Senha

puerto=Porta

seleccion_de_campos=Selec\u00e7\u00e3o de campos

seleccione_tabla=Selecciona a tabela

select_all=Seleccionar todos

select_geom_field=Selecciona o campo que leva a geometria

select_none=Remover todos

select_unique_field=Seleccione o campo \u00fanico

usuario=Usu\u00e1rio

where_clause=Cl\u00e1usula "WHERE"

#Translations for language [ca]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=\u00c0rea de treball

aviso_sin_extent_de_referencia=Per a usar esta opci\u00f3 necessiteu tindre com a  m\u00ednim una capa ja afegida que servisca de refer\u00e8ncia.

back=Anterior

bd=bd

capa_importada=Capa importada. Voleu crear l'\u00edndex espacial?

connection_name=Nom de la connexi\u00f3

database_connection=Connexi\u00f3 a base de dades

DBManager=Gestor de base de dades

driver=Driver

error_conexion=Fallada en connectar a la base de dades.

host=M\u00e0quina

importar_extent=Importar l'extensi\u00f3 actual de la vista

intro_tablename=Introdu\u00efu el nom de la taula que s'ha de crear. AV\u00cdS\: Si existix la taula, s'esborrar\u00e0.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Seg\u00fcent

nombre_capa=Nom de la capa

password=Clau

puerto=Port

seleccion_de_campos=Selecci\u00f3 de camps

seleccione_tabla=Seleccioneu la taula

select_all=Seleccionar tot

select_geom_field=Selecciona el camp que porta la geometria

select_none=Llevar tots

select_unique_field=Seleccioneu el camp \u00fanic

usuario=Usuari

where_clause=Cl\u00e0usula WHERE

#Translations for language [sr]

#Mon Nov 02 08:36:02 CET 2009

DBManager=Manager Baze podataka

#Translations for language [tr]

#Mon Sep 21 10:02:07 CEST 2009

DBManager=Veritaban\u0131 Y\u00f6neticisi

#Translations for language [ru]

#Mon Sep 21 10:02:07 CEST 2009

DBManager=\u041c\u0435\u043d\u0435\u0434\u0436\u0435\u0440 \u0411\u0414

#Translations for language [de]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=Arbeitsbereich

aviso_sin_extent_de_referencia=F\u00fcr diese Option wird mindestens ein bereits hinzugef\u00fcgter Layer als Referenz ben\u00f6tigt.

back=Zur\u00fcck

bd=db

capa_importada=Layer wurde importiert. Wollen sie den r\u00e4umlichen Index einrichten?

connection_name=Name der Verbindung

database_connection=Datenbank-Verbindung

DBManager=Datenbank-Verwalter

driver=Treiber

error_conexion=Fehler bei der Verbindung zur Datenbank

host=Host

importar_extent=Aktuellen Ansichtsbereich importieren.

intro_tablename=Name der Tabelle eingeben.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=weiter

nombre_capa=Name des Layers

password=Passwort

puerto=Port

seleccion_de_campos=Auswahl der Felder

seleccione_tabla=W\u00e4hlen Sie die Tabelle aus.

select_all=Alle ausw\u00e4hlen

select_geom_field=W\u00e4hlen Sie das Geometriefeld aus.

select_none=Alle aus der Auswahl entfernen

select_unique_field=Feld mit eindeutigem Wert ausw\u00e4hlen

usuario=Benutzer

where_clause="Where"-Klausel

#Translations for language [sw]

#Mon Sep 21 10:02:07 CEST 2009

DBManager=Meneja wa Hazina ya Habari

#Translations for language [el]

#Mon Sep 21 10:02:07 CEST 2009

DBManager=\u0394\u03b9\u03b1\u03c7\u03b5\u03b9\u03c1\u03b9\u03c3\u03c4\u1f20\u03c2 \u0392\u03ac\u03c3\u03b7\u03c2 \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd

#Translations for language [en]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=Working area

aviso_sin_extent_de_referencia=To use this option you need to have one already added layer to use as reference

back=Previous

bd=db

capa_importada=Imported layer. Do you want to create the spatial index?

connection_name=Connection name

database_connection=Database Connection

DBManager=DataBase Manager

driver=Driver

error_conexion=Error connecting to data base

host=Computer

importar_extent=Import actual view extent

intro_tablename=Type in the name of the table to create. WARNING\: If table exists, it will be deleted.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Next

nombre_capa=Name of the layer

password=Password

puerto=Port

seleccion_de_campos=Field selection

seleccione_tabla=Table select

select_all=Select all

select_geom_field=Select field with geometry

select_none=Remove all

select_unique_field=Select unique field

usuario=User

where_clause=Where clause

#Translations for language [gl]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=\u00c1rea de traballo

aviso_sin_extent_de_referencia=Para usar esta opci\u00f3n precisa ter como m\u00ednimo unha capa xa engadida que serva de referencia

back=Anterior

bd=bd

capa_importada=Capa mportada. Desexa crear o \u00edndice espacial?

connection_name=Nome da conexi\u00f3n

database_connection=Conexi\u00f3n a Base de Dados

DBManager=Xestor de Base de dados

driver=Driver

error_conexion=Erro ao conectar \u00e1 base de datos

host=M\u00e1quina

importar_extent=Importar o extent actual da vista

intro_tablename=Introduza o nome da t\u00e1boa a crear. AVISO\: Se a t\u00e1boa xa existe, ser\u00e1 borrada

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Seguinte

nombre_capa=Nome da capa

password=Chave

puerto=Porto

seleccion_de_campos=Selecci\u00f3n de campos

seleccione_tabla=Seleccione a t\u00e1boa

select_all=Seleccionar todo

select_geom_field=Selecciona o campo que leva a xeometr\u00eda

select_none=Quitar todos

select_unique_field=Seleccione o campo \u00fanico

usuario=Usuario

where_clause=Cl\u00e1usula where

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

<plugin-config>

	<libraries library-dir="."/>

	<depends plugin-name="com.iver.cit.gvsig" />

	<resourceBundle name="text"/>

	<extensions>

		<extension class-name="com.iver.cit.gvsig.jdbc_spatial.ExtJDBC_Spatial"

			description="Support to access JDBC spatial databases PostgreSQL and mySQL"

			active="true"

			priority="1">

		</extension>	

		<!--	

		<extension class-name="com.iver.cit.gvsig.jdbc_spatial.ImportLayer"

			description="Writes active layer to PostGIS"

			active="true"

			priority="2">

			<menu text="Capa/import_layer" action-command="IMPORT_LAYER" icon="images/editpaste.png"/>			

		</extension>		

		-->

	</extensions>

</plugin-config>

#Translations for language [cs]

#Mon Sep 21 10:02:07 CEST 2009

area_trabajo=Pracovn\u00ed oblast

aviso_sin_extent_de_referencia=Aby jste mohli pou\u017e\u00edt tuto volbu, pot\u0159ebujete m\u00edt alespo\u0148 jednu vrstvu jako referen\u010dn\u00ed

back=P\u0159edchoz\u00ed

bd=db

capa_importada=Vrstva importov\u00e1na. Chcete vytvo\u0159it prostorov\u00fd index?

connection_name=N\u00e1zev spojen\u00ed

database_connection=Datab\u00e1zov\u00e9 spojen\u00ed

DBManager=Datab\u00e1zov\u00fd mana\u017eer

driver=Ovlada\u010d

error_conexion=Chyba p\u0159i spojen\u00ed s datab\u00e1z\u00ed

host=Po\u010d\u00edta\u010d

importar_extent=Import aktu\u00e1ln\u00ed viditeln\u00e9 oblasti

intro_tablename=Zadejte n\u00e1zev tabulky k vytvo\u0159en\u00ed. VAROV\u00c1N\u00cd\: Pokud tabulka existuje bude vymaz\u00e1na.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Dal\u0161\u00ed

nombre_capa=N\u00e1zev vrstvy

password=K\u00f3d

puerto=Port

seleccion_de_campos=V\u00fdb\u011br pole

seleccione_tabla=V\u00fdb\u011br tabulky

select_all=Vyber v\u0161e

select_geom_field=Vyber polo\u017eku s geometri\u00ed

select_none=Odstra\u0148 v\u0161e

select_unique_field=Vyber jedine\u010dnou polo\u017eku

usuario=U\u017eivatel

where_clause=odd\u00edl Where

#Build Number for ANT. Do not edit!

#Mon Sep 06 12:55:07 CEST 2010

build.number=1260

<project name="extJDBC.compile-classpath" basedir=".">

	<!-- defines the classpath to be used for compilation -->

	<property name="andami"   location="../_fwAndami"/>

	<property name="fmap" location="../libFMap"/>

	<property name="andamiLibs"   location="${andami}/lib"/>

	<property name="andamiJar"   location="${andami}/andami.jar"/>

	<property name="mainPlugin" location="${andami}/gvSIG/extensiones/com.iver.cit.gvsig" />

	<property name="gvsigJar" location="${mainPlugin}/lib/com.iver.cit.gvsig.jar"/>

	<property name="fmapJar" location="${fmap}/dist/lib/fmap.jar" />

	<path id="extJDBC.compile-classpath">

	    <pathelement location="${andamiJar}"/>

		<pathelement location="${gvsigJar}"/>

		<pathelement location="${fmapJar}"/>

	    <pathelement location="${andamiLibs}/beans.jar"/>

	    <pathelement location="${andamiLibs}/iver-utiles.jar"/>

	    <pathelement location="${andamiLibs}/log4j-1.2.8.jar"/>

	</path>

</project>

/*

 * Created on 22-jun-2005

 *

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

 *

 * Copyright (C) 2004 IVER T.I. 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

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

package com.iver.cit.gvsig.jdbc_spatial;

import java.security.KeyException;

import com.iver.andami.plugins.Extension;

import com.iver.cit.gvsig.fmap.layers.FLayerVectorialDB;

import com.iver.cit.gvsig.project.documents.view.legend.gui.General;

import com.iver.cit.gvsig.project.documents.view.legend.gui.LabelingManager;

import com.iver.cit.gvsig.project.documents.view.legend.gui.LegendManager;

import com.iver.cit.gvsig.project.documents.view.legend.gui.ThemeManagerWindow;

import com.iver.utiles.extensionPoints.ExtensionPoint;

import com.iver.utiles.extensionPoints.ExtensionPoints;

import com.iver.utiles.extensionPoints.ExtensionPointsSingleton;

public class ExtJDBC_Spatial extends Extension {

    public void initialize() {

        System.out.println("A?ado WizardJDBC.");

//        AddLayer.addWizard(WizardJDBC.class);

        ExtensionPoints extensionPoints = ExtensionPointsSingleton.getInstance();

    	extensionPoints.add("CatalogLayers","POSTGIS",new JDBCLayerBuilder());

//    	extensionPoints.add("Layers",FLayerVectorialDB.class.getName(), FLayerVectorialDB.class);

		try {

			((ExtensionPoint)extensionPoints.get("Layers")).addAlias(FLayerVectorialDB.class.getName(), "VectorialDB");

		} catch (KeyException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		ThemeManagerWindow.setTabEnabledForLayer(General.class, FLayerVectorialDB.class, true);

		ThemeManagerWindow.setTabEnabledForLayer(LegendManager.class, FLayerVectorialDB.class, true);

		ThemeManagerWindow.setTabEnabledForLayer(LabelingManager.class, FLayerVectorialDB.class, true);

    }

    public void execute(String actionCommand) {

        // TODO Auto-generated method stub

    }

    public boolean isEnabled() {

        // TODO Auto-generated method stub

        return false;

    }

    public boolean isVisible() {

        // TODO Auto-generated method stub

        return false;

    }

}

package com.iver.cit.gvsig.jdbc_spatial;

import java.util.Map;

import com.iver.cit.gvsig.fmap.drivers.ConnectionFactory;

import com.iver.cit.gvsig.fmap.drivers.DBException;

import com.iver.cit.gvsig.fmap.drivers.DBLayerDefinition;

import com.iver.cit.gvsig.fmap.drivers.IConnection;

import com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver;

import com.iver.cit.gvsig.fmap.layers.LayerFactory;

import com.iver.utiles.extensionPoints.IExtensionBuilder;