Application: gvSIG desktop » gvSIG data provider for MS SQLServer

<?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.mssqlserver.app</artifactId>

  <packaging>pom</packaging>

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

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.mssqlserver</artifactId>

      <version>1.0.12</version>

  </parent>

  <modules>

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

  </modules>

</project>

#Mon Aug 07 14:31:04 CEST 2017

buildNumber=14

Notas acerca de la implementacion del proveedor de MS SQLServer.

====================================================================

Software

----------

Las pruebas realizadas durante el desarrollo se han hecho sobre:

- Microsoft SQL Server Express 2014 (64-bit), versi?n 12.0.2000.8

- Microsoft Windows NT 6.3 (9600), plataforma NT x64

El acceso al servidor se realiza a traves de JDBC usando el driver:

- Microsoft JDBC Driver 6.0 for SQL Server, may 2016 (sqljdbc42.jar).

Configuraci?n

--------------

Las pruebas se han realizado usando la instancia por defecto "SQLEXPRESS".

Para poder acceder al servidor es necesario:

- Habilitar la conexion al servidor a traves de TCP/IP. Esto se activara

  desde:

  - Sql Server Configuration Manager

  - Configuracion de red de SQL Server

  - Protocolos de SQLEXPRESS

  - TCP/IP

   - General

     - Habilitado: Si

   - Direcciones IP

     - IP4

       - Activo: Si

       - Habilitado: Si

- Deberan estar "En ejecucion" los servicios de:

  - SQL Server (SQLEXPRESS)

  - SQL Server Browser.

    Este servicio es necesario para poder aceptar conexiones TCP/IP contra el

    servidor y por defecto, tras la instalacion de MS SQL Sever, no se iniciaba

    automaticamente en mi equipo.

- Durante todas las pruebas se ha utilizado "Autenticaci?n de SQL Server".

  Es posible que para otros tipos de autenticaci?n sea necesario incluir alguna

  otra libreria (como sqljdbc_auth.dll x64/x86).

Soporte espacial

-------------------

Siempre que se exporta a BBDD se utilizara el tipo "geometry" para crear los

campos de tipo geometria, y en general se usara siempre este tipo de datos.

Se ha implementado un soporte limitado para el tipo de datos "geography". Si una

tabla contiene un campo de este tipo se leera y gvSIG podra trabajar con el. Si

una tabla contiene mas de un campo de tipo geometria siendo estos de tipos distintos,

unos "geometry" y otros "geography", gvSIG puede dar problemas para acceder a estos,

especialmente al de tipo "geography".

Ahora mismo el tipo de geometria asociado a una columna de la BBDD es GEOMETRY,

es decir, no se sabe si es punto, linea o poligono.

Sistemas de referencia

------------------------

La lista de sistemas de referencia disponibles esta almacenada en la tabla

sys.spatial_reference_systems, y solo tiene definidas unos 390 sistemas

de referencia. Habria que averiguar cargar otros sistemas de referencia.

Valores por defecto

---------------------

Los datos de conexion por defecto son:

- Host: 127.0.0.1

- Instance: SQLEXPRESS

- Database: master

- Schema: dbo

- user: sa

- password: 123

Los valores instance, database, schema y user se corresponden con valores

validos para una instalacion por defecto de SQL Server.

Problemas conocidos

--------------------

- No se guardan los datos de la conexion entre sesiones de gvSIG.

- La herramienta "Selection by layer" no funciona.

- Si una capa de gvSIG declara un campo "double" con precision y size,

  al expportarlo a BBDD lo exporta como "DOUBLE PRECISION" en lugar de como

  "NUMERIC(size,precision)".

- No se estan creando indices sobre los campos al exportar a BBDD.

- En la exportacion a BBDD, en el paso que pide el nombre de la tabla,

  primero muestra como esquema "public" y cuando termina de leer las tablas

  de la BBDD para mostrarlas (tarda unos segundos) cambia de public a "dbo".

  Esto puede causar problemas si el usuario pulsa en siguiente antes de que se

  haya actualizado el esquema con el que se corresponde con la BBDD ya que

  intentaria crear la tabla en el esquema "public" y este no existe en SQLServer.

- Solo se ha implememtado soporte para geometrias 2D (no 3D, 2DM o 3DM).

MICROSOFT SOFTWARE LICENSE TERMS

MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER

These license terms are an agreement between Microsoft Corporation (or based on where you 

live, one of its affiliates) and you. Please read them. They apply to the software 

named above, which includes the media on which you received it, if any. The terms also apply to 

any Microsoft

? updates,

? supplements,

? Internet-based services, and

? support services

for this software, unless other terms accompany those items. If so, those terms apply.

BY USING THE SOFTWARE, YOU ACCEPT THESE TERMS. IF YOU DO NOT 

ACCEPT THEM, DO NOT USE THE SOFTWARE.

If you comply with these license terms, you have the rights below.

1. INSTALLATION AND USE RIGHTS. 

a. Installation and Use.

i. You may install and use any number of copies of the software on your devices.

b. Third Party Programs. The software may include third party programs that Microsoft, 

not the third party, licenses to you under this agreement. Notices, if any, for the third 

party program are included for your information only.

2. ADDITIONAL LICENSING REQUIREMENTS AND/OR USE RIGHTS.

a. Distributable Code.

i.	Right to Use and Distribute. You are permitted to distribute the software in programs you 

develop if you comply with the terms below:

* You may copy and distribute the object code form of the software (?Distributable Code?) in 

programs you develop. You may not modify the software.

* You may permit distributors of your programs to copy and distribute the Distributable Code 

as part of those programs.

ii.	Distribution Requirements. For any Distributable Code you distribute, you must

* add significant primary functionality to it in your programs;

* require distributors and external end users to agree to terms that protect it at least as 

much as this agreement;

* display your valid copyright notice on your programs; and

* indemnify, defend, and hold harmless Microsoft from any claims, including attorneys? fees, 

related to the distribution or use of your programs.

iii.	Distribution Restrictions. You may not

* alter any copyright, trademark or patent notice in the Distributable Code;

* use Microsoft?s trademarks in your programs? names or in a way that suggests your programs 

come from or are endorsed by Microsoft;

* include Distributable Code in malicious, deceptive or unlawful programs; or

* modify or distribute the source code of any Distributable Code so that any part of it 

becomes subject to an Excluded License. An Excluded License is one that requires, as a 

condition of use, modification or distribution, that

* the code be disclosed or distributed in source code form; or

* others have the right to modify it.

3. SCOPE OF LICENSE. The software is licensed, not sold. This agreement only gives you 

some rights to use the software. Microsoft reserves all other rights. Unless applicable law 

gives you more rights despite this limitation, you may use the software only as expressly 

permitted in this agreement. In doing so, you must comply with any technical limitations in 

the software that only allow you to use it in certain ways. You may not

? work around any technical limitations in the software;

? reverse engineer, decompile or disassemble the software, except and only to the extent 

that applicable law expressly permits, despite this limitation;

? make more copies of the software than specified in this agreement or allowed by 

applicable law, despite this limitation;

? publish the software for others to copy;

? rent, lease or lend the software;

? transfer the software or this agreement to any third party; or

? use the software for commercial software hosting services.

4. EXPORT RESTRICTIONS. The software is subject to United States export laws and 

regulations. You must comply with all domestic and international export laws and 

regulations that apply to the software. These laws include restrictions on destinations, end 

users and end use. For additional information, see www.microsoft.com/exporting.

5. SUPPORT SERVICES. Because this software is ?as is,? we may not provide support 

services for it.

6. ENTIRE AGREEMENT. This agreement, and the terms for supplements, updates, Internet-

based services and support services that you use, are the entire agreement for the software 

and support services.

7. APPLICABLE LAW.

a. United States. If you acquired the software in the United States, Washington state law 

governs the interpretation of this agreement and applies to claims for breach of it, 

regardless of conflict of laws principles. The laws of the state where you live govern all 

other claims, including claims under state consumer protection laws, unfair competition 

laws, and in tort.

b. Outside the United States. If you acquired the software in any other country, the laws of 

that country apply.

8. LEGAL EFFECT. This agreement describes certain legal rights. You may have other rights 

under the laws of your country. You may also have rights with respect to the party from 

whom you acquired the software. This agreement does not change your rights under the laws 

of your country if the laws of your country do not permit it to do so.

9. DISCLAIMER OF WARRANTY. THE SOFTWARE IS LICENSED ?AS-IS.? YOU 

BEAR THE RISK OF USING IT. MICROSOFT GIVES NO EXPRESS 

WARRANTIES, GUARANTEES OR CONDITIONS. YOU MAY HAVE 

ADDITIONAL CONSUMER RIGHTS UNDER YOUR LOCAL LAWS WHICH THIS 

AGREEMENT CANNOT CHANGE. TO THE EXTENT PERMITTED UNDER 

YOUR LOCAL LAWS, MICROSOFT EXCLUDES THE IMPLIED WARRANTIES 

OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NON-

INFRINGEMENT.

10. LIMITATION ON AND EXCLUSION OF REMEDIES AND DAMAGES. YOU CAN 

RECOVER FROM MICROSOFT AND ITS SUPPLIERS ONLY DIRECT DAMAGES UP 

TO U.S. $5.00. YOU CANNOT RECOVER ANY OTHER DAMAGES, INCLUDING 

CONSEQUENTIAL, LOST PROFITS, SPECIAL, INDIRECT OR INCIDENTAL 

DAMAGES.

This limitation applies to

? anything related to the software, services, content (including code) on third party Internet 

sites, or third party programs, and

? claims for breach of contract, breach of warranty, guarantee or condition, strict liability, 

negligence, or other tort to the extent permitted by applicable law.

It also applies even if Microsoft knew or should have known about the possibility of the 

damages. The above limitation or exclusion may not apply to you because your country may 

not allow the exclusion or limitation of incidental, consequential or other damages.

Please note: As this software is distributed in Quebec, Canada, some of the clauses in this 

agreement are provided below in French.

Remarque : Ce logiciel ?tant distribu? au Qu?bec, Canada, certaines des clauses dans ce 

contrat sont fournies ci-dessous en fran?ais.

EXON?RATION DE GARANTIE. Le logiciel vis? par une licence est offert ? tel quel ?. 

Toute utilisation de ce logiciel est ? votre seule risque et p?ril. Microsoft n?accorde aucune 

autre garantie expresse. Vous pouvez b?n?ficier de droits additionnels en vertu du droit local 

sur la protection des consommateurs, que ce contrat ne peut modifier. La ou elles sont 

permises par le droit locale, les garanties implicites de qualit? marchande, d?ad?quation ? un 

usage particulier et d?absence de contrefa?on sont exclues.

LIMITATION DES DOMMAGES-INT?R?TS ET EXCLUSION DE 

RESPONSABILIT? POUR LES DOMMAGES. Vous pouvez obtenir de Microsoft et de 

ses fournisseurs une indemnisation en cas de dommages directs uniquement ? hauteur de 5,00 

$ US. Vous ne pouvez pr?tendre ? aucune indemnisation pour les autres dommages, y 

compris les dommages sp?ciaux, indirects ou accessoires et pertes de b?n?fices.

Cette limitation concerne :

? tout ce qui est reli? au logiciel, aux services ou au contenu (y compris le code) figurant 

sur des sites Internet tiers ou dans des programmes tiers ; et

? les r?clamations au titre de violation de contrat ou de garantie, ou au titre de 

responsabilit? stricte, de n?gligence ou d?une autre faute dans la limite autoris?e par la loi 

en vigueur.

Elle s?applique ?galement, m?me si Microsoft connaissait ou devrait conna?tre l??ventualit? 

d?un tel dommage. Si votre pays n?autorise pas l?exclusion ou la limitation de responsabilit? 

pour les dommages indirects, accessoires ou de quelque nature que ce soit, il se peut que la 

limitation ou l?exclusion ci-dessus ne s?appliquera pas ? votre ?gard.

EFFET JURIDIQUE. Le pr?sent contrat d?crit certains droits juridiques. Vous pourriez avoir 

d?autres droits pr?vus par les lois de votre pays. Le pr?sent contrat ne modifie pas les droits 

que vous conf?rent les lois de votre pays si celles-ci ne le permettent pas.

<?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.mssqlserver.MSSQLServerExtension" active="true"/>

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

  <fileSets>

    <fileSet>

      <directory>src/main/resources-plugin</directory>

      <outputDirectory>.</outputDirectory>

    </fileSet>

  </fileSets>

  <dependencySets>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

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

      </includes>

    </dependencySet>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

		<include>com.microsoft.sqlserver:sqlserver-jdbc</include>

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

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

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

      </includes>

    </dependencySet>

  </dependencySets>

</assembly>

package org.gvsig.mssqlserver;

import org.gvsig.andami.IconThemeHelper;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.fmap.mapcontext.MapContextLocator;

import org.gvsig.fmap.mapcontext.MapContextManager;

public class MSSQLServerExtension  extends Extension {

    @Override

    public void initialize() {

    }

    @Override

    public void postInitialize() {

        MapContextManager mapContextMgr = MapContextLocator.getMapContextManager();

        IconThemeHelper.registerIcon("layer", "layer-icon-mssqlserver", this);

        mapContextMgr.registerIconLayer("MSSQLServer", "layer-icon-mssqlserver");

    }

    @Override

    public void execute(String actionCommand) {

    }

    @Override

    public boolean isEnabled() {

        return false;

    }

    @Override

    public boolean isVisible() {

        return false;

    }

}

<?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.mssqlserver.app.mainplugin</artifactId>

  <packaging>jar</packaging>

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

  <description>MS SQLServer support</description>

  <parent>

      <groupId>org.gvsig</groupId>

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

      <version>1.0.12</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.fmap.mapcontext.api</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>org.gvsig</groupId>

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

        <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>com.microsoft.sqlserver</groupId>

      <artifactId>sqlserver-jdbc</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.name>Formats: MS SQLServer support</gvsig.package.info.name>

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

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

        <gvsig.package.info.javaVM>j1_8</gvsig.package.info.javaVM>

        <gvsig.package.info.dependencies>required: org.gvsig.app.mainplugin -ge 2.3.0</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-mssqlserver/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.mssqlserver</artifactId>

    <version>1.0.12</version>

    <packaging>pom</packaging>

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

    <description>MS SQLServer support fort DAL and gvSIG</description>

    <parent>

        <groupId>org.gvsig</groupId>

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

        <version>2.0.196</version>

    </parent>

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

    <scm>

        <connection>scm:svn:https://devel.gvsig.org/svn/gvsig-mssqlserver/tags/org.gvsig.mssqlserver-1.0.12</connection>

        <developerConnection>scm:svn:https://devel.gvsig.org/svn/gvsig-mssqlserver/tags/org.gvsig.mssqlserver-1.0.12</developerConnection>

        <url>https://devel.gvsig.org/redmine/projects/gvsig-mssqlserver/repository/show/tags/org.gvsig.mssqlserver-1.0.12</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-mssqlserver/tags/</tagBase>

                    <goals>deploy</goals>

                </configuration>

            </plugin>                     

        </plugins>

    </build>

    <dependencyManagement>

        <dependencies>

            <dependency>

                <groupId>org.gvsig</groupId>

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

                <version>1.0.12</version>

            </dependency>

            <dependency>

                <groupId>org.gvsig</groupId>

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

                <version>1.0.12</version>

            </dependency>

            <dependency>

                <groupId>com.microsoft.sqlserver</groupId>

                <artifactId>sqlserver-jdbc</artifactId>

                <version>6.0.0</version>

            </dependency>

        </dependencies>

    </dependencyManagement>

    <modules>

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

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

    </modules>

</project>

package org.gvsig.mssqlserver.dal.operations;

import org.gvsig.fmap.dal.store.jdbc2.spi.operations.*;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.apache.commons.lang3.StringUtils;

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

import org.gvsig.fmap.dal.store.jdbc.exception.JDBCSQLException;

import org.gvsig.fmap.dal.store.jdbc2.JDBCHelper;

import org.gvsig.fmap.dal.store.jdbc2.JDBCUtils;

public class MSSQLServerCanModifyTableOperation extends CanModifyTableOperation {

    public MSSQLServerCanModifyTableOperation(

            JDBCHelper helper

        ) {

        this(helper, null, null, null);

    }

    public MSSQLServerCanModifyTableOperation(

            JDBCHelper helper,

            String dbName,

            String schemaName,

            String tableName

        ) {

        super(helper,dbName,schemaName,tableName);

    }

    private String getFullTableName( 

            String dbName,

            String schemaName,

            String tableName

    ) {

        StringBuilder builder = new StringBuilder();

        if( !StringUtils.isEmpty(dbName) ) {

            builder.append(dbName);

        }

        if( !StringUtils.isEmpty(schemaName) ) {

            if( builder.length()>0 ) {

                builder.append(".");

            }

            builder.append(schemaName);

        }

        if( !StringUtils.isEmpty(tableName) ) {

            if( builder.length()>0 ) {

                builder.append(".");

            }

            builder.append(tableName);

        }

        return builder.toString();

    }

    @Override

    public boolean canModifyTable(Connection conn,

            String dbName,

            String schemaName,

            String tableName

        ) throws DataException {

        String sql = "SELECT count(*) " + 

                     "FROM fn_my_permissions('"+getFullTableName(dbName, schemaName, tableName)+"', 'OBJECT') " +

                     "WHERE permission_name in ('UPDATE', 'INSERT', 'DELETE') AND subentity_name = ''";

        Statement st = null;

        ResultSet rs = null;

        try {

            st = conn.createStatement();

            rs = JDBCUtils.executeQuery(st, sql);

            if (!rs.next()) {

                return false;

            }

            return rs.getInt(1)==3;

        } catch (SQLException ex) {

            throw new JDBCSQLException(ex);

        } finally {

            JDBCUtils.closeQuietly(st);

            JDBCUtils.closeQuietly(rs);

        }

    }

}

package org.gvsig.mssqlserver.dal.operations;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.Statement;

import java.util.List;

import org.cresques.cts.IProjection;

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

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

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

import org.gvsig.fmap.dal.store.jdbc2.JDBCHelper;

import org.gvsig.fmap.dal.store.jdbc2.JDBCUtils;

import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase;

import org.gvsig.fmap.dal.store.jdbc2.spi.operations.FetchFeatureTypeOperation;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.GeometryLocator;

import org.gvsig.fmap.geom.type.GeometryType;

import org.gvsig.mssqlserver.dal.MSSQLServerHelper;

public class MSSQLServerFetchFeatureTypeOperation extends FetchFeatureTypeOperation {

    public MSSQLServerFetchFeatureTypeOperation(

            JDBCHelper helper

    ) {

        super(helper);

    }

    public MSSQLServerFetchFeatureTypeOperation(

            JDBCHelper helper,

            EditableFeatureType featureType,

            String dbname,

            String schema,

            String table,

            List<String> primaryKeys,

            String defaultGeometryColumn,

            IProjection crs

    ) {

        super(helper, featureType, dbname, schema, table, primaryKeys, defaultGeometryColumn, crs);

    }

    @Override

    public void fetch(EditableFeatureType featureType, Connection conn, String dbname, String schema, String table, List<String> pks, String defaultGeometryColumn, IProjection crs) throws DataException {

        super.fetch(featureType, conn, dbname, schema, table, pks, defaultGeometryColumn, crs);

        ((MSSQLServerHelper) this.helper).setLastUsedFeatureType(featureType);

    }

    @Override

    protected void fetchGeometryTypeAndSRS(

            EditableFeatureAttributeDescriptor attr,

            ResultSetMetaData rsMetadata,

            int colIndex

    ) {

        try {

            GeometryType geomType = GeometryLocator.getGeometryManager().getGeometryType(

                    Geometry.TYPES.GEOMETRY,

                    Geometry.SUBTYPES.GEOM2D

            );

            attr.setGeometryType(geomType);

            String typeName = rsMetadata.getColumnTypeName(colIndex);

            attr.setAdditionalInfo("SQLServer_type_name", typeName);

            attr.setSRS(getProjectionOfColumn(attr.getName()));

        } catch (Exception ex) {

            logger.warn("Can't get default geometry type.", ex);

        }

    }

    private IProjection getProjectionOfColumn(String columnName) {

        JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder();

        sqlbuilder.select().limit(1);

        sqlbuilder.select().column().value(

                sqlbuilder.ST_SRID(sqlbuilder.column(columnName))

        );

        sqlbuilder.select().where().set(

                sqlbuilder.and(

                        sqlbuilder.notIsNull(sqlbuilder.column(columnName)),

                        sqlbuilder.notIsNull(sqlbuilder.ST_SRID(sqlbuilder.column(columnName)))

                )

        );

        sqlbuilder.select().from().table().schema(this.getSchema()).name(this.getTablename());

        Statement st = null;

        ResultSet rs = null;

        try {

            st = this.getConnection().createStatement();

            rs = JDBCUtils.executeQuery(st, sqlbuilder.toString());

            if (rs.next()) {

                int code = rs.getInt(1);

                try {

                    IProjection proj = this.helper.getProjectionFromDatabaseCode(String.valueOf(code));

                    return proj;

                } catch (Exception ex) {

                    logger.warn("Can't create projection from code '" + code + "'.", ex);

                }

            }

        } catch (Exception ex) {

            // Do nothing, return null

        } finally {

            JDBCUtils.closeQuietly(rs);

            JDBCUtils.closeQuietly(st);

        }

        return null;

    }

}

package org.gvsig.mssqlserver.dal.operations;

import java.util.List;

import org.cresques.cts.IProjection;

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

import org.gvsig.fmap.dal.store.jdbc2.JDBCHelper;

import org.gvsig.fmap.dal.store.jdbc2.spi.operations.CanModifyTableOperation;

import org.gvsig.fmap.dal.store.jdbc2.spi.operations.FetchFeatureTypeOperation;

import org.gvsig.fmap.dal.store.jdbc2.spi.operations.OperationsFactoryBase;

import org.gvsig.mssqlserver.dal.operations.MSSQLServerFetchFeatureTypeOperation;

public class MSSQLServerOperationsFactory extends OperationsFactoryBase {

    public MSSQLServerOperationsFactory(JDBCHelper helper) {

        super(helper);

    }

    @Override

    public FetchFeatureTypeOperation createFetchFeatureType(EditableFeatureType type, String database, String schema, String table, List<String> primaryKeys, String defaultGeometryField, IProjection crs) {

        return new MSSQLServerFetchFeatureTypeOperation(

                helper, type, database, schema, table, primaryKeys, 

                defaultGeometryField, crs

        );

    }

    @Override

    public CanModifyTableOperation createCanModifyTableOperation(String dbName, String schemaName, String tableName) {

        return new MSSQLServerCanModifyTableOperation(

                helper, dbName, schemaName, tableName

        );

    }

}

/* gvSIG. Geographic Information System of the Valencian Government

 *

 * Copyright (C) 2007-2016 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 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.

 *

 */

package org.gvsig.mssqlserver.dal;

import org.gvsig.mssqlserver.dal.operations.MSSQLServerOperationsFactory;

import java.sql.Connection;

import java.sql.SQLException;

import java.text.MessageFormat;

import org.apache.commons.dbcp.BasicDataSource;

import org.apache.commons.lang3.StringUtils;

import org.cresques.cts.IProjection;

import org.gvsig.fmap.dal.DataParameters;

import org.gvsig.fmap.dal.DataTypes;

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

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

import org.gvsig.fmap.dal.SQLBuilder;

import org.gvsig.fmap.dal.resource.exception.AccessResourceException;

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

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

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

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

import org.gvsig.fmap.dal.store.jdbc.exception.JDBCDriverClassNotFoundException;

import org.gvsig.fmap.dal.store.jdbc2.OperationsFactory;

import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCHelperBase;

import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

public class MSSQLServerHelper extends JDBCHelperBase {

    private static final Logger logger = LoggerFactory.getLogger(MSSQLServerHelper.class);

    public static final String NAME = "MSSQLServer";

    public static final String INSTANCE_NAME = "SQLEXPRESS";

    public static final int PORT = 1433;

    public static final String MSSQLServerJDBCDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

//    private static final boolean ALLOW_AUTOMATIC_VALUES = true;

//    private static final String QUOTE_FOR_USE_IN_IDENTIFIERS = "\"";

//    private static final String QUOTE_FOR_USE_IN_STRINGS = "'";

    public static String getConnectionURL(JDBCConnectionParameters params) {

        String connectionURL = MessageFormat.format(

                //"jdbc:sqlserver://{0}:{1,number,#};databaseName={2};instanceName={3};",

                "jdbc:sqlserver://{0};databaseName={2};instanceName={3};",

                params.getHost(),

                params.getPort(),

                params.getDBName(),

                ((DataParameters) params).getDynValue("instanceName")

        );

        logger.debug("connectionURL: {}", connectionURL);

        return connectionURL;

    }

    private static class ConnectionProvider {

        private static boolean needRegisterDriver = true;

        private BasicDataSource dataSource = null;

        private final JDBCConnectionParameters connectionParameters;

        public ConnectionProvider(JDBCConnectionParameters connectionParameters) {

            this.connectionParameters = connectionParameters;

        }

        public Connection getConnection() throws SQLException {

            if (this.dataSource == null) {

                this.dataSource = this.createDataSource();

            }

            Connection conn = this.dataSource.getConnection();

            return conn;

        }

        private BasicDataSource createDataSource() throws SQLException {

            if (!this.isRegistered()) {

                this.registerDriver();

            }

            JDBCConnectionParameters params = connectionParameters;

            BasicDataSource dataSource = new BasicDataSource();

            dataSource.setDriverClassName(params.getJDBCDriverClassName());

            dataSource.setUsername(params.getUser());

            dataSource.setPassword(params.getPassword());

            dataSource.setUrl(params.getUrl());

            dataSource.setMaxWait(60L * 1000);

            return dataSource;

        }

        private boolean isRegistered() {

            return needRegisterDriver;

        }

        public void registerDriver() throws SQLException {

            String className = this.connectionParameters.getJDBCDriverClassName();

            if (className == null) {

                return;

            }

            try {

                Class theClass = Class.forName(className);

                if (theClass == null) {

                    throw new JDBCDriverClassNotFoundException(MSSQLServerLibrary.NAME, className);

                }

            } catch (Exception e) {

                throw new SQLException("Can't register JDBC driver '" + className + "'.", e);

            }

            needRegisterDriver = false;

        }

    }

    private ConnectionProvider connectionProvider = null;

    private FeatureType lastUsedFeatureType = null;

    private String lastUsedSpatialType = null;

    public MSSQLServerHelper(JDBCConnectionParameters connectionParameters) {

        super(connectionParameters);

    }

    @Override

    public Connection getConnection() throws AccessResourceException {

        try {

            if (this.connectionProvider == null) {

                this.connectionProvider = new ConnectionProvider(this.getConnectionParameters());

            }

            return this.connectionProvider.getConnection();

        } catch (SQLException ex) {

            throw new AccessResourceException(MSSQLServerLibrary.NAME, ex);

        }

    }

    @Override

    public String getConnectionURL() {

        return getConnectionURL(this.getConnectionParameters());

    }

    @Override

    protected String getResourceType() {

        return MSSQLServerLibrary.NAME;

    }

    @Override

    public String getProviderName() {

        return MSSQLServerLibrary.NAME;

    }

    @Override

    public JDBCSQLBuilderBase createSQLBuilder() {

        return new MSSQLServerSQLBuilder(this);

    }

    /**

     * Devuelbe el nombre del tipo de datos espacial de SQLServer asociado 

     * al ultimo FeatureType cargado.

     * 

     * Esta funcion es usada para dar un soporte limitado al tipo de datos

     * spaciales "geography".

     * 

     * Si no disponemos de un FeatureType asumimos "geometry".

     * Si hay un solo campo espacial asume el tipo de ese campo, y si 

     * hay mas de uno asume "geometry".

     * En caso de que no haya ningun campo espacial asumimos "geometry".

     * 

     * @return "geometry" or "geography" for the last used table.

     */

    public String getSpatialType() {

        if( this.lastUsedSpatialType != null ) {

            return this.lastUsedSpatialType;

        }

        if( this.lastUsedFeatureType == null ) {

            this.lastUsedSpatialType = "geometry";

            return this.lastUsedSpatialType;

        }

        String spatialType = null;

        for (FeatureAttributeDescriptor attr : lastUsedFeatureType) {

            if( attr.getType() == DataTypes.GEOMETRY ) {

                if( spatialType != null ) {

                    this.lastUsedSpatialType = "geometry";

                    return this.lastUsedSpatialType;

                }

                spatialType = (String) attr.getAdditionalInfo("SQLServer_type_name");

            }

        }

        if( StringUtils.isEmpty(spatialType) ) {

            this.lastUsedSpatialType = "geometry";

            return this.lastUsedSpatialType;

        }

        this.lastUsedSpatialType = spatialType;

        return this.lastUsedSpatialType;

    }

    /**

     * Devuelbe el tipo de datos espacial de SQLServer asociado a la columna 

     * indicada.

     * 

     * Esta funcion es usada para dar un soporte limitado al tipo de datos

     * spaciales "geography".

     * 

     * Si no disponemos de un FeatureType asumimos "geometry".

     * Si no existe el campo solicitado o no es de tipo geoemtria, asumimos 

     * el tipo espacia asociado al FeatureType (getSpatialType()).

     * 

     * @param columnName

     * @return "geometry" or "geography" for column in the last used table.

     */

    public String getSpatialType(String columnName) {

        if( this.lastUsedFeatureType == null ) {

            return "geometry";

        }

        FeatureAttributeDescriptor attr = this.lastUsedFeatureType.getAttributeDescriptor(columnName);

        if( attr == null ) {

            return this.getSpatialType();

        }

        if( attr.getType() != DataTypes.GEOMETRY ) {

            return this.getSpatialType();

        }

        String spatialType = (String) attr.getAdditionalInfo("SQLServer_type_name");

        if( StringUtils.isEmpty(spatialType) ) {

            return "geometry";

        }

        return spatialType;

    }

    public void setLastUsedFeatureType(FeatureType featureType) {

        this.lastUsedSpatialType = null;

        this.lastUsedFeatureType = featureType;

    }

    @Override

    public OperationsFactory getOperations() {

        if (this.operationsFactory == null) {

            this.operationsFactory = new MSSQLServerOperationsFactory(this);

        }

        return operationsFactory;

    }

    @Override

    public SQLBuilder.GeometrySupportType getGeometrySupportType() {

        return SQLBuilder.GeometrySupportType.WKB;

    }

    @Override

    public boolean hasSpatialFunctions() {

        return true;

    }

    @Override

    public boolean canWriteGeometry(int geometryType, int geometrySubtype) {

        return true;

    }

    @Override

    public String getQuoteForIdentifiers() {

        return "\"";

    }

    @Override

    public boolean allowAutomaticValues() {

        return true;

    }

    @Override

    public boolean supportOffsetInSelect() {

        return true;

    }

    @Override

    public String getQuoteForStrings() {

        return "'";

    }

    @Override

    public int getSRSCode(IProjection crs) {

        // TODO: ir a buscarlo a la BBDD a ver donde puede estar

        return super.getSRSCode(crs);

    }

    @Override

    public IProjection getProjectionFromSRSId(int srsid) {

        return super.getProjectionFromSRSId(srsid); 

    }

    @Override

    public String getSourceId(JDBCStoreParameters parameters) {

        return parameters.getHost() + ":" +

               parameters.getDynValue("InstanceName")+ ":" + 

               parameters.getDBName() + "." + 

               parameters.getSchema()+ "." + 

               parameters.getTable();

    }

    @Override

    public JDBCNewStoreParameters createNewStoreParameters() {

        return new MSSQLServerNewStoreParameters();

    }

    @Override

    public JDBCStoreParameters createOpenStoreParameters() {

        return new MSSQLServerStoreParameters();

    }

    @Override

    public JDBCServerExplorerParameters createServerExplorerParameters() {

        return new MSSQLServerExplorerParameters();

    }

}

package org.gvsig.mssqlserver.dal;

import org.gvsig.fmap.dal.DataParameters;

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

import org.gvsig.fmap.dal.spi.DataStoreProviderServices;

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

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

import org.gvsig.fmap.dal.store.jdbc2.JDBCHelper;

import org.gvsig.fmap.dal.store.jdbc2.JDBCStoreProvider;

import org.gvsig.fmap.dal.store.jdbc2.impl.JDBCStoreProviderFactory;

public class MSSQLServerStoreProviderFactory extends JDBCStoreProviderFactory {

    private static final String NAME = MSSQLServerLibrary.NAME;

    public MSSQLServerStoreProviderFactory() {

        super(

                NAME, 

                "Microsoft SQL Server store"

        );

    }

    @Override

    public JDBCStoreProvider createProvider(

            DataParameters parameters,

            DataStoreProviderServices providerServices

    ) throws InitializeException {

        JDBCHelper helper = new MSSQLServerHelper((JDBCConnectionParameters) parameters);

        JDBCStoreProvider provider = helper.createProvider(

                (JDBCStoreParameters) parameters, 

                providerServices

        );

        return provider;

    }

    @Override

    public JDBCStoreParameters createParameters() {

        JDBCStoreParameters params = new MSSQLServerStoreParameters();

        return params;

    }

}

/* 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.

*

 */

package org.gvsig.mssqlserver.dal;

import org.apache.commons.lang3.StringUtils;

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

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

public class MSSQLServerStoreParameters extends JDBCStoreParameters {

    public MSSQLServerStoreParameters() {

        super(

                MSSQLServerLibrary.NAME + "StoreParameters",

                MSSQLServerLibrary.NAME

        );

    }

    @Override

    public String getUrl() {

        String url = super.getUrl();

        if( StringUtils.isEmpty(url) ) {

            url = MSSQLServerHelper.getConnectionURL(this);

            this.setUrl(url);

        }

        return url;

    }

    @Override

    public void validate() throws ValidateDataParametersException {

        if (getJDBCDriverClassName() == null) {

            setJDBCDriverClassName(MSSQLServerHelper.MSSQLServerJDBCDriver);

        }

        if (getPort() == null) {

            setPort(MSSQLServerHelper.PORT);

        }

        if (getDynValue("instanceName") == null) {

            setDynValue("InstanceName", MSSQLServerHelper.INSTANCE_NAME);

        }

        super.validate();

    }

}

/* 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.

*

 */

/**

 *

 */

package org.gvsig.mssqlserver.dal;

import org.apache.commons.lang3.StringUtils;

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

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

public class MSSQLServerExplorerParameters extends

        JDBCServerExplorerParameters {

    public MSSQLServerExplorerParameters() {

        super(

                MSSQLServerLibrary.NAME + "ServerExplorerParameters",

                MSSQLServerLibrary.NAME

        );

    }

    @Override

    public String getUrl() {

        String url = super.getUrl();

        if( StringUtils.isEmpty(url) ) {

            url = MSSQLServerHelper.getConnectionURL(this);

            this.setUrl(url);

        }

        return url;

    }

    @Override

    public void validate() throws ValidateDataParametersException {

        if (getJDBCDriverClassName() == null) {

            setJDBCDriverClassName(MSSQLServerHelper.MSSQLServerJDBCDriver);

        }

        if (getPort() == null) {

            setPort(MSSQLServerHelper.PORT);

        }

        if( getDynValue("instanceName") == null ) {

            setDynValue("InstanceName", MSSQLServerHelper.INSTANCE_NAME);

        }

        super.validate();

    }

}

/* 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.

 *

 */

package org.gvsig.mssqlserver.dal;

import org.gvsig.fmap.dal.DALLibrary;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.spi.DataManagerProviderServices;

import org.gvsig.fmap.dal.store.db.DBHelper;

import org.gvsig.fmap.dal.store.jdbc2.JDBCLibrary;

import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCStoreProviderBase;

import org.gvsig.metadata.exceptions.MetadataException;

import org.gvsig.tools.library.AbstractLibrary;

import org.gvsig.tools.library.LibraryException;

public class MSSQLServerLibrary extends AbstractLibrary {

    // com.microsoft.sqlserver.jdbc.SQLServerDriver

    public static final String NAME = "MSSQLServer";

    @Override

    public void doRegistration() {

        registerAsServiceOf(DALLibrary.class);

        require(JDBCLibrary.class);

    }

    @Override

    protected void doInitialize() throws LibraryException {

    }

    @Override

    protected void doPostInitialize() throws LibraryException {

        LibraryException ex = null;

        DataManagerProviderServices dataman = 

                (DataManagerProviderServices) DALLocator.getDataManager();

        DBHelper.registerParametersDefinition(

                NAME + "StoreParameters",

                MSSQLServerStoreParameters.class,

                dataman.getResourceAsStream(this, NAME + "Parameters.xml")

        );

        DBHelper.registerParametersDefinition(

                NAME + "NewStoreParameters",

                MSSQLServerNewStoreParameters.class,

                dataman.getResourceAsStream(this, NAME + "Parameters.xml")

        );

        DBHelper.registerParametersDefinition(

                NAME + "ServerExplorerParameters",

                MSSQLServerExplorerParameters.class,

                dataman.getResourceAsStream(this, NAME + "Parameters.xml")

        );

//        DBHelper.registerParametersDefinition(

//                NAME + "ResourceParameters",

//                MSSQLServerResourceParameters.class,

//                dataman.getResourceAsStream(this, NAME + "Parameters.xml")

//        );

        try {

            DBHelper.registerMetadataDefinition(

                NAME,

                JDBCStoreProviderBase.class,

                dataman.getResourceAsStream(this, NAME + "Metadata.xml")

            );

        } catch (MetadataException e) {

            ex = new LibraryException(this.getClass(), e);

        }

//        ResourceManagerProviderServices resman = (ResourceManagerProviderServices) DALLocator

//                .getResourceManager();

//

//        if (!resman.getResourceProviders().contains(NAME)) {

//            resman.register(NAME,

//                "Resource for " + NAME,

//                MSSQLServerResource.class,

//                MSSQLServerResourceParameters.class

//            );

//        }

        if (!dataman.getStoreProviderRegister().exits(NAME)) {

            dataman.registerStoreProviderFactory(new MSSQLServerStoreProviderFactory());

        }

        if (!dataman.getServerExplorerRegister().exits(NAME)) {

            dataman.registerServerExplorerFactory(new MSSQLServerExplorerFactory());

        }

        if (ex != null) {

            throw ex;

        }

    }

}

package org.gvsig.mssqlserver.dal;

import java.text.MessageFormat;

import java.util.ArrayList;

import java.util.List;

import org.cresques.cts.IProjection;

import org.gvsig.fmap.dal.DataTypes;