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.45</version>

  </parent>

  <modules>

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

  </modules>

</project>

#Thu Oct 24 23:59:06 CEST 2019

buildNumber=47

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

    }

}

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>

<?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.45</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.45</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.253</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.45</connection>

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

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

            </dependency>

            <dependency>

                <groupId>org.gvsig</groupId>

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

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

<?xml version="1.0"?>

<!--

    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.

-->

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="JDBC2" namespace="Metadata">

      <extends>

      	<class name="SpatialProvider" namespace="Metadata"/>

      </extends>

      <description>Metadata of a JDBC store</description>

      <fields>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<!--

    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.

-->

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="JDBC2ResourceParameters">

      <description></description>

      <extends>

        <class>DBResourceParameters</class>

      </extends>

      <fields>

        <field name="JDBCDriverClass" type="string" mandatory="true" group="Advanced">

          <description>JDBC Driver class</description>

        </field>

        <field name="URL" type="string" mandatory="true" group="Connection">

          <description>JDBC url connection</description>

        </field>

        <field name="Catalog" type="string" mandatory="false" group="Basic">

          <description>Database catalog</description>

        </field>

        <field name="Schema" type="string" mandatory="false" group="Basic">

          <description>Database schema</description>

        </field>

      </fields>

    </class>

    <class name="JDBC2StoreParameters">

      <extends>

        <class>JDBC2ResourceParameters</class>

        <class>DBStoreParameters</class>

      </extends>

      <tags>

          <value name="defaultGroup" value="Basic"/>

      </tags>

      <fields>

      </fields>

    </class>

    <class name="JDBC2NewStoreParameters">

      <description></description>

      <extends>

        <class>JDBC2ResourceParameters</class>

        <class>DBNewStoreParameters</class>

      </extends>

      <tags>

          <value name="defaultGroup" value="Basic"/>

      </tags>

      <fields>

        <field name="selectRole" label="Roles for select" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have select privilegies</description>

        </field>

        <field name="insertRole" label="Roles for insert" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have insert privilegies</description>

        </field>

        <field name="updateRole" label="Roles for update" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have update privilegies</description>

        </field>

        <field name="deleteRole" label="Roles for delete" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have delete privilegies</description>

        </field>

        <field name="truncateRole" label="Roles for truncate" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have truncate privilegies</description>

        </field>

        <field name="referenceRole" label="Roles for reference" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have reference privilegies</description>

        </field>

        <field name="triggerRole" label="Roles for trigger" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have trigger privilegies</description>

        </field>

        <field name="allRole" label="Roles for all" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have all privilegies</description>

        </field>

        <field name="postCreatingStatement" label="Post-creating statement" type="String" mandatory="false" defaultValue="" group="Advanced">

          <description>Roles asigned to have all privilegies</description>

        </field>

      </fields>

    </class>

    <class name="JDBC2ServerExplorerParameters">

      <extends>

        <class>JDBC2ResourceParameters</class>

        <class>DBServerExplorerParameters</class>

      </extends>

      <tags>

          <value name="defaultGroup" value="Basic"/>

      </tags>

      <fields>

        <field name="ShowInformationDBTables" type="boolean" 

            mandatory="false" defaultValue="false" group="Basic">

          <description>Show information tables</description>

        </field>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="MSSQLServer" namespace="Metadata">

      <extends>

      	<class name="JDBC2" namespace="Metadata"/>

      </extends>

      <description>Metadata for MSSQLServer</description>

      <fields>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="MSSQLServerResourceParameters">

      <extends>

        <class>JDBC2ResourceParameters</class>

      </extends>

      <fields>

        <field name="JDBCDriverClass" type="string" mandatory="true"

          defaultValue="com.microsoft.sqlserver.jdbc.SQLServerDriver" group="Advanced">

          <description>JDBC driver class for MS-SQlServer</description>

        </field>

        <field name="port" type="integer" mandatory="false"

          defaultValue="1433" group="Connection">

          <description></description>

        </field>

        <field name="host" type="string" mandatory="false" 

            defaultValue="127.0.0.1" group="Connection">

          <description></description>

        </field>

        <field name="instanceName" type="string" mandatory="false" 

            defaultValue="SQLEXPRESS" group="Connection">

          <description></description>

        </field>     

        <field name="dbname" type="string" mandatory="false" defaultValue="master" group="Basic">

          <description></description>

        </field>

        <field name="dbuser" type="string" mandatory="false" defaultValue="sa" group="Basic">

          <description></description>

        </field>

        <field name="password" type="string" mandatory="false" defaultValue="123" group="Basic">

          <description></description>

        </field>           

      </fields>

    </class>

    <class name="MSSQLServerStoreParameters">

      <extends>

        <class>JDBC2StoreParameters</class>

        <class>MSSQLServerResourceParameters</class>

      </extends>

      <fields/>

    </class>

    <class name="MSSQLServerNewStoreParameters">

      <extends>

        <class>JDBC2NewStoreParameters</class>

        <class>MSSQLServerResourceParameters</class>

      </extends>

      <fields/>

    </class>

    <class name="MSSQLServerServerExplorerParameters">

      <extends>

        <class>MSSQLServerResourceParameters</class>

        <class>JDBC2ServerExplorerParameters</class>

      </extends>

      <fields/>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="JDBC2">

      <extends>

      </extends>

      <fields>

        <field name="function_ST_AsWKB" type="string" group="functions" 

          defaultValue="ST_AsWKB({0})" >

          <description></description>

        </field>

        <field name="function_ST_envelope" type="string" group="functions" 

          defaultValue="ST_envelope({0})" >

          <description></description>

        </field>

        <field name="function_ST_Extent" type="string" group="functions" 

          defaultValue="ST_Extent({0})" >

          <description></description>

        </field>

        <field name="function_ST_intersects" type="string" group="functions" 

          defaultValue="ST_intersects({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromText" type="string" group="functions" 

          defaultValue="ST_GeomFromText({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromWKB" type="string" group="functions" 

          defaultValue="ST_GeomFromWKB({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromEWKB" type="string" group="functions" 

          defaultValue="ST_GeomFromEWKB({0}, {1})" >

          <description></description>

        </field>

        <field name="function_current_schema" type="string" group="functions" 

          defaultValue="current_schema()" >

          <description></description>

        </field>

        <field name="function_lcase" type="string" group="functions" 

          defaultValue="LCASE({0})" >

          <description></description>

        </field>

        <field name="function_count" type="string" group="functions" 

          defaultValue="count({0})" >

          <description></description>

        </field>

        <field name="function_crs" type="string" group="functions" 

          defaultValue="{0}" >

          <description>Use {0} for the abbreviature, {1} for the autority name and {2} for the autority code</description>

        </field>

        <!-- operators -->

        <field name="operator_isnull" type="string" group="operators" 

          defaultValue="{0} is null" >

          <description></description>

        </field>

        <field name="operator_eq" type="string" group="operators" 

          defaultValue="{0} = {1}" >

          <description></description>

        </field>

        <field name="operator_neq" type="string" group="operators" 

          defaultValue="{0} <> {1}" >

          <description></description>

        </field>

        <field name="operator_lt" type="string" group="operators" 

          defaultValue="{0} < {1}" >

          <description></description>

        </field>

        <field name="operator_le" type="string" group="operators" 

          defaultValue="{0} <= {1}" >

          <description></description>

        </field>

        <field name="operator_gt" type="string" group="operators" 

          defaultValue="{0} > {1}" >

          <description></description>

        </field>

        <field name="operator_ge" type="string" group="operators" 

          defaultValue="{0} >= {1}" >

          <description></description>

        </field>

        <field name="operator_and" type="string" group="operators" 

          defaultValue="{0} AND {1}" >

          <description></description>

        </field>

        <field name="operator_or" type="string" group="operators" 

          defaultValue="{0} OR {1}" >

          <description></description>

        </field>

        <field name="operator_like" type="string" group="operators" 

          defaultValue="{0} LIKE {1}" >

          <description></description>

        </field>

        <field name="operator_ilike" type="string" group="operators" 

          defaultValue="{0} ILIKE {1}" >

          <description></description>

        </field>

        <!-- properties -->

        <field name="AllowAutomaticValues" type="boolean" group="properties" 

          defaultValue="true" >

          <description></description>

        </field>

        <field name="QuoteForStrings" type="string" group="properties" 

          defaultValue="'" >

          <description></description>

        </field>

        <field name="QuoteForIdentifiers" type="string" group="properties" 

          defaultValue="" >

          <description></description>

        </field>

        <field name="GeometrySupportType" type="string" group="properties" 

            defaultValue="WKB" >

            <description></description>

            <availableValues>

                <value label="WKT">WKT</value>

                <value label="WKB">WKB</value>

                <value label="EWKB">EWKB</value>

            </availableValues>          

        </field>

      </fields>

    </class>

    <class name="MSSQLServer">

      <extends>

          <class>JDBC2</class>

      </extends>

      <fields>

        <field name="function_ST_AsWKB" type="string" group="functions" 

          defaultValue="({0}).STAsWKB" >

          <description></description>

        </field>

        <field name="function_ST_envelope" type="string" group="functions" 

          defaultValue="({0}).STEnvelope" >

          <description></description>

        </field>

        <field name="function_ST_Extent" type="string" group="functions" 

          defaultValue="({0}).STEnvelope" >

          <description></description>

        </field>

        <field name="function_ST_intersects" type="string" group="functions" 

          defaultValue="({0}).STIntersects({1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromText" type="string" group="functions" 

          defaultValue="geometry::STGeomFromText({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromWKB" type="string" group="functions" 

          defaultValue="geometry::STGeomFromWKB({0}, {1})" >

          <description></description>

        </field>

        <field name="function_ST_GeomFromEWKB" type="string" group="functions" 

          defaultValue="geometry::STGeomFromWKB({0}, {1})" >

          <description></description>

        </field>

        <field name="function_current_schema" type="string" group="functions" 

          defaultValue="current_schema()" >

          <description></description>

        </field>

        <field name="function_crs" type="string" group="functions" 

          defaultValue="{2}" >

          <description>Use {0} for the abbreviature, {1} for the autority name and {2} for the autority code</description>

        </field>

        <field name="function_lcase" type="string" group="functions" 

          defaultValue="LOWER({0})" >

          <description></description>

        </field>

        <!-- operators -->

        <field name="operator_ilike" type="string" group="operators" 

          defaultValue="{0} ILIKE {1}" >

          <description></description>

        </field>

  </classes>

</definitions>  

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

org.gvsig.mssqlserver.dal.MSSQLServerLibrary

/* 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.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.DataTypes;

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

import org.gvsig.fmap.geom.primitive.Envelope;

import org.gvsig.mssqlserver.dal.expressionbuilderformatter.MSSQLServerFormatter;

public class MSSQLServerSQLBuilder extends JDBCSQLBuilderBase {

    protected Formatter formatter = null;

    public static final String FORMAT_ST_GEOMFROMEWKB= "geometry::STGeomFromWKB({0}, {1})";

    public static final String FORMAT_ST_GEOMFROMWKB= "geometry::STGeomFromWKB({0}, {1})";

    public static final String FORMAT_ST_GEOMFROMTEXT= "geometry::STGeomFromText({0}, {1})";

    public static final String FORMAT_OPERATOR_ILIKE = "LOWER({0}) LIKE LOWER({1})";

    public static final String FORMAT_OPERATOR_NOTISNULL = "( ({0}) IS NOT NULL )";

//    public interface MSSQLServerSQLConfig extends SQLConfig {

//        public static final String ST_GeomFromTextEx = "ST_GeomFromTextEx";

//        public static final String ST_GeomFromWKBEx = "ST_GeomFromWKBEx";

//        public static final String ST_GeomFromEWKBEx = "ST_GeomFromEWKBEx";

//        public static final String ST_ExtentAggregateEx = "ST_ExtentAggregateEx";

//        public static final String ST_UnionAggregateEx = "ST_UnionAggregateEx";

//    }

    public MSSQLServerSQLBuilder(MSSQLServerHelper helper) {

        super(helper);

        this.defaultSchema = "dbo";

        this.allowAutomaticValues = true;

        this.geometrySupportType = this.helper.getGeometrySupportType();

        this.hasSpatialFunctions = this.helper.hasSpatialFunctions();

        STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table = null;

        STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table = null;

        this.STMT_UPDATE_TABLE_STATISTICS_table ="UPDATE STATISTICS {0}";

        this.type_geometry = "GEOMETRY";

        this.constant_true = "1=1"; // TODO ?

        this.constant_false = "1<>1"; // TODO ?

        this.type_boolean = "BIT";

        this.type_double = "FLOAT"; //float con 53 bits de mantisa = float(54)

        this.type_numeric_p = "NUMERIC({0})";

        this.type_numeric_ps = "NUMERIC({0},{1})";

        this.type_bigdecimal = "NUMERIC({0},{1})";

        this.type_float = "REAL"; //float con 24 bits de mantisa = float(24)

        this.type_int = "INT";

        this.type_long = "BIGINT";        

        this.type_byte = "TINYINT";

        this.type_date = "DATE";

        this.type_time = "TIME";

        this.type_char = "CHAR(1)";

        this.type_string = "TEXT";

        this.type_string_p = "VARCHAR({0})";

        this.type_version = "VARCHAR(30)";

        this.type_URI = "TEXT";

        this.type_URL = "TEXT";

        this.type_FILE = "TEXT";

        this.type_FOLDER = "TEXT";

        this.type_bytearray = "VARBINARY";

        this.type_timestamp = "TIMESTAMP";

//       DID this.ST_SRID, "(({0}).STSrid)");

//       DID this.ST_AsText, "({0}).STAsText()");

//       DID this.ST_AsBinary, "({0}).STAsBinary()");

//       DID this.ST_AsEWKB, "({0}).STAsBinary()");

//       DID this.ST_ExtentAggregate, "geometry::EnvelopeAggregate({0})");

//       DID this.ST_UnionAggregate, "geometry::UnionAggregate({0})");

//       DID this.ST_Contains, "(({0}).STContains({1})=1)");

//       DID this.ST_Crosses, "(({0}).STCrosses({1})=1)");

//       DID this.ST_Disjoint, "(({0}).STDisjoint({1})=1)");

//       DID this.ST_Equals, "(({0}).STEquals({1})=1)");

//       DID this.ST_IsClosed, "(({0}).STIsClosed()=1)");

//       DID this.ST_Overlaps, "(({0}).STOverlaps({1})=1)");

//       DID this.ST_Touches, "(({0}).STTouches({1})=1)");

//       DID this.ST_Within, "(({0}).STWithin ({1})=1)");

//       DID this.ST_Envelope, "({0}).STEnvelope()");

//       DID this.ST_Intersects, "(({0}).STIntersects({1})=1)");

//       DID this.ST_GeomFromText, "geometry::STGeomFromText({0}, {1})");

//       DID this.ST_GeomFromWKB, "geometry::STGeomFromWKB({0}, {1})");

//       DID this.ST_GeomFromEWKB, "geometry::STGeomFromWKB({0}, {1})");

//       DID this.ST_Simplify, "({0}).Reduce({1})");

//        this.lcase, "LOWER({0})");

//        this.ucase, "UPPER({0})");

//

//        config.set(MSSQLServerSQLConfig.ST_ExtentAggregateEx, "{1}::EnvelopeAggregate({0})");

//        config.set(MSSQLServerSQLConfig.ST_UnionAggregateEx, "{1}::UnionAggregate({0})");

//        config.set(MSSQLServerSQLConfig.ST_GeomFromTextEx, "{2}::STGeomFromText({0}, {1})");

//        config.set(MSSQLServerSQLConfig.ST_GeomFromWKBEx, "{2}::STGeomFromWKB({0}, {1})");

//        config.set(MSSQLServerSQLConfig.ST_GeomFromEWKBEx, "{2}::STGeomFromWKB({0}, {1})");

    }

    @Override

    public MSSQLServerHelper getHelper() {

        return (MSSQLServerHelper) helper;

    }

    @Override

    protected Formatter formatter() {

        if( this.formatter==null ) {

            this.formatter = new MSSQLServerFormatter(this);

        }

        return this.formatter;

    }

    protected class MSSQLServerDropTableBuilder extends DropTableBuilderBase {

        @Override

           public List<String> toStrings(Formatter formatter) {

            List<String> sqls = new ArrayList<>();

            sqls.add(

                    MessageFormat.format(

                            STMT_DROP_TABLE_table,

                            this.table.toString(formatter)

                    )

            );

            return sqls;

        }

    }

    public class MSSQLServerCreateIndexBuilder extends CreateIndexBuilderBase {

        private Envelope boundingBox;

        public MSSQLServerCreateIndexBuilder() {

            super();

            this.boundingBox = null;

        }

        public void setBoundingBox(Envelope boundingBox) {

            this.boundingBox = boundingBox;

        }

        private double getXMin() {

            // https://alastaira.wordpress.com/2011/07/26/determining-the-geographic-extent-of-spatial-features-in-a-sql-server-table/

            return Math.min(boundingBox.getUpperCorner().getX(), boundingBox.getLowerCorner().getX());

        }

        private double getYMin() {

            return Math.min(boundingBox.getUpperCorner().getY(), boundingBox.getLowerCorner().getY());

        }

        private double getXMax() {

            return Math.max(boundingBox.getUpperCorner().getX(), boundingBox.getLowerCorner().getX());

        }

        private double getYMax() {

            return Math.max(boundingBox.getUpperCorner().getY(), boundingBox.getLowerCorner().getY());

        }

        @Override

        public List<String> toStrings() {

            StringBuilder builder = new StringBuilder();

            if( this.isSpatial ) {

                builder.append("CREATE SPATIAL INDEX ");

                builder.append(as_identifier(this.indexName));

                builder.append(" ON ");

                builder.append(this.table.toString());

                builder.append(" ( ");

                boolean is_first_column = true;

                for( String column : this.columns) {

                    if( is_first_column ) {

                        is_first_column = false;

                    } else {

                        builder.append(", ");

                    }

                    builder.append(column);

                }

                builder.append(" ) ");

                builder.append("USING GEOMETRY_GRID ");

                builder.append("WITH( ");

                builder.append("BOUNDING_BOX  = ( ");

                builder.append("xmin  = ").append(this.getXMin()).append(", ");

                builder.append("ymin  = ").append(this.getYMin()).append(", ");

                builder.append("xmax  = ").append(this.getXMax()).append(", ");

                builder.append("ymax  = ").append(this.getYMax());

                builder.append(" )");

//                builder.append(", DROP_EXISTING = ON");

//                builder.append(", GRIDS  = ( LEVEL_1  = MEDIUM, LEVEL_2  = MEDIUM, LEVEL_3  = MEDIUM, LEVEL_4  = MEDIUM)");

//                builder.append(", CELLS_PER_OBJECT  = 16");

//                builder.append(", STATISTICS_NORECOMPUTE = OFF");

//                builder.append(", ALLOW_ROW_LOCKS = ON");

//                builder.append(", ALLOW_PAGE_LOCKS = ON");

                builder.append(" ) ");

            } else {

                builder.append("CREATE ");

                if( this.isUnique ) {

                    builder.append("UNIQUE ");

                }

                builder.append("INDEX ");

//                if( this.ifNotExist ) {

//                    builder.append("IF NOT EXISTS ");

//                }

                builder.append(as_identifier(this.indexName));

                builder.append(" ON ");

                builder.append(this.table.toString());

                builder.append(" ( ");

                boolean is_first_column = true;

                for( String column : this.columns) {

                    if( is_first_column ) {

                        is_first_column = false;

                    } else {

                        builder.append(", ");

                    }

                    builder.append(column);

                }

                builder.append(" )");

            }

            List<String> sqls = new ArrayList<>();

            sqls.add(builder.toString());

            return sqls;

        }

    }

//    public class MSSQLServerParameter extends ParameterBase {

//

//        public MSSQLServerParameter() {

//            super();

//        }

//

//        @Override

//        public String toString() {

//            if( this.type == ParameterType.Geometry ) {