gvSIG data provider for Oracle

#Tue Jul 27 00:54:56 CEST 2021

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>

  </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.oracle.provider</include>

            <include>com.oracle:ojdbc</include>

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

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

      </includes>

    </dependencySet>

  </dependencySets>

</assembly>

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

<object classname="com.jeta.forms.store.memento.FormPackage">

 <at name="fileversion">

  <object classname="com.jeta.forms.store.memento.FormsVersion2">

   <at name="major">2</at>

   <at name="minor">0</at>

   <at name="sub">0</at>

  </object>

 </at>

 <at name="form">

  <object classname="com.jeta.forms.store.memento.FormMemento">

   <super classname="com.jeta.forms.store.memento.ComponentMemento">

    <at name="cellconstraints">

     <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

      <at name="column">1</at>

      <at name="row">1</at>

      <at name="colspan">1</at>

      <at name="rowspan">1</at>

      <at name="halign">default</at>

      <at name="valign">default</at>

      <at name="insets" object="insets">0,0,0,0</at>

     </object>

    </at>

    <at name="componentclass">com.jeta.forms.gui.form.FormComponent</at>

   </super>

   <at name="id">/home/jjdelcerro/datos/devel/org.gvsig.oracle/org.gvsig.oracle.app/org.gvsig.oracle.app.mainplugin/src/main/java/org/gvsig/oracle/HostPortPanelView.xml</at>

   <at name="rowspecs">CENTER:4DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:4DLU:NONE</at>

   <at name="colspecs">FILL:4DLU:NONE,FILL:DEFAULT:NONE,FILL:DEFAULT:NONE,FILL:DEFAULT:GROW(1.0),FILL:4DLU:NONE</at>

   <at name="components">

    <object classname="java.util.LinkedList">

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">2</at>

           <at name="row">2</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">com.jeta.forms.components.label.JETALabel</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">com.jeta.forms.components.label.JETALabel</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name"></at>

            <at name="width">38</at>

            <at name="text">Server</at>

            <at name="fill">

             <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

              <at name="name">fill</at>

             </object>

            </at>

            <at name="height">14</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">2</at>

           <at name="row">4</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">com.jeta.forms.components.label.JETALabel</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">com.jeta.forms.components.label.JETALabel</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name"></at>

            <at name="width">38</at>

            <at name="text">Port</at>

            <at name="fill">

             <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

              <at name="name">fill</at>

             </object>

            </at>

            <at name="height">14</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">4</at>

           <at name="row">2</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">javax.swing.JTextField</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">javax.swing.JTextField</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name">txtServer</at>

            <at name="width">475</at>

            <at name="height">20</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">4</at>

           <at name="row">4</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">javax.swing.JTextField</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">javax.swing.JTextField</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="selectionStart">4</at>

            <at name="name">txtPort</at>

            <at name="width">475</at>

            <at name="selectionEnd">4</at>

            <at name="text">5500</at>

            <at name="height">20</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

    </object>

   </at>

   <at name="properties">

    <object classname="com.jeta.forms.store.memento.PropertiesMemento">

     <at name="classname">com.jeta.forms.gui.form.GridView</at>

     <at name="properties">

      <object classname="com.jeta.forms.store.support.PropertyMap">

       <at name="border">

        <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

         <super classname="com.jeta.forms.store.properties.BorderProperty">

          <at name="name">border</at>

         </super>

         <at name="borders">

          <object classname="java.util.LinkedList"/>

         </at>

        </object>

       </at>

       <at name="name"></at>

       <at name="fill">

        <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

         <at name="name">fill</at>

        </object>

       </at>

       <at name="scollBars">

        <object classname="com.jeta.forms.store.properties.ScrollBarsProperty">

         <at name="name">scollBars</at>

         <at name="verticalpolicy">21</at>

         <at name="horizontalpolicy">31</at>

         <at name="border">

          <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

           <super classname="com.jeta.forms.store.properties.BorderProperty">

            <at name="name">border</at>

           </super>

           <at name="borders">

            <object classname="java.util.LinkedList">

             <item >

              <at name="value">

               <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                <super classname="com.jeta.forms.store.properties.BorderProperty">

                 <at name="name">border</at>

                </super>

               </object>

              </at>

             </item>

            </object>

           </at>

          </object>

         </at>

        </object>

       </at>

      </object>

     </at>

    </object>

   </at>

   <at name="cellpainters">

    <object classname="com.jeta.forms.store.support.Matrix">

     <at name="rows">

      <object classname="[Ljava.lang.Object;" size="5">

       <at name="item" index="0">

        <object classname="[Ljava.lang.Object;" size="5"/>

       </at>

       <at name="item" index="1">

        <object classname="[Ljava.lang.Object;" size="5"/>

       </at>

       <at name="item" index="2">

        <object classname="[Ljava.lang.Object;" size="5"/>

       </at>

       <at name="item" index="3">

        <object classname="[Ljava.lang.Object;" size="5"/>

       </at>

       <at name="item" index="4">

        <object classname="[Ljava.lang.Object;" size="5"/>

       </at>

      </object>

     </at>

    </object>

   </at>

   <at name="rowgroups">

    <object classname="com.jeta.forms.store.memento.FormGroupSet">

     <at name="groups">

      <object classname="java.util.HashMap"/>

     </at>

    </object>

   </at>

   <at name="colgroups">

    <object classname="com.jeta.forms.store.memento.FormGroupSet">

     <at name="groups">

      <object classname="java.util.HashMap"/>

     </at>

    </object>

   </at>

  </object>

 </at>

</object>

package org.gvsig.oracle;

import com.jeta.open.i18n.I18NUtils;

import com.jgoodies.forms.layout.CellConstraints;

import com.jgoodies.forms.layout.FormLayout;

import java.awt.BorderLayout;

import java.awt.ComponentOrientation;

import java.awt.Container;

import java.awt.Dimension;

import javax.swing.Box;

import javax.swing.ImageIcon;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

public class HostPortPanelView extends JPanel

{

   JTextField txtServer = new JTextField();

   JTextField txtPort = new JTextField();

   /**

    * Default constructor

    */

   public HostPortPanelView()

   {

      initializePanel();

   }

   /**

    * Adds fill components to empty cells in the first row and first column of the grid.

    * This ensures that the grid spacing will be the same as shown in the designer.

    * @param cols an array of column indices in the first row where fill components should be added.

    * @param rows an array of row indices in the first column where fill components should be added.

    */

   void addFillComponents( Container panel, int[] cols, int[] rows )

   {

      Dimension filler = new Dimension(10,10);

      boolean filled_cell_11 = false;

      CellConstraints cc = new CellConstraints();

      if ( cols.length > 0 && rows.length > 0 )

      {

         if ( cols[0] == 1 && rows[0] == 1 )

         {

            /** add a rigid area  */

            panel.add( Box.createRigidArea( filler ), cc.xy(1,1) );

            filled_cell_11 = true;

         }

      }

      for( int index = 0; index < cols.length; index++ )

      {

         if ( cols[index] == 1 && filled_cell_11 )

         {

            continue;

         }

         panel.add( Box.createRigidArea( filler ), cc.xy(cols[index],1) );

      }

      for( int index = 0; index < rows.length; index++ )

      {

         if ( rows[index] == 1 && filled_cell_11 )

         {

            continue;

         }

         panel.add( Box.createRigidArea( filler ), cc.xy(1,rows[index]) );

      }

   }

   /**

    * Helper method to load an image file from the CLASSPATH

    * @param imageName the package and name of the file to load relative to the CLASSPATH

    * @return an ImageIcon instance with the specified image file

    * @throws IllegalArgumentException if the image resource cannot be loaded.

    */

   public ImageIcon loadImage( String imageName )

   {

      try

      {

         ClassLoader classloader = getClass().getClassLoader();

         java.net.URL url = classloader.getResource( imageName );

         if ( url != null )

         {

            ImageIcon icon = new ImageIcon( url );

            return icon;

         }

      }

      catch( Exception e )

      {

         e.printStackTrace();

      }

      throw new IllegalArgumentException( "Unable to load image: " + imageName );

   }

   /**

    * Method for recalculating the component orientation for 

    * right-to-left Locales.

    * @param orientation the component orientation to be applied

    */

   public void applyComponentOrientation( ComponentOrientation orientation )

   {

      // Not yet implemented...

      // I18NUtils.applyComponentOrientation(this, orientation);

      super.applyComponentOrientation(orientation);

   }

   public JPanel createPanel()

   {

      JPanel jpanel1 = new JPanel();

      FormLayout formlayout1 = new FormLayout("FILL:4DLU:NONE,FILL:DEFAULT:NONE,FILL:DEFAULT:NONE,FILL:DEFAULT:GROW(1.0),FILL:4DLU:NONE","CENTER:4DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:4DLU:NONE");

      CellConstraints cc = new CellConstraints();

      jpanel1.setLayout(formlayout1);

      JLabel jlabel1 = new JLabel();

      jlabel1.setText("Server");

      jpanel1.add(jlabel1,cc.xy(2,2));

      JLabel jlabel2 = new JLabel();

      jlabel2.setText("Port");

      jpanel1.add(jlabel2,cc.xy(2,4));

      txtServer.setName("txtServer");

      jpanel1.add(txtServer,cc.xy(4,2));

      txtPort.setName("txtPort");

      txtPort.setSelectionEnd(4);

      txtPort.setSelectionStart(4);

      txtPort.setText("5500");

      jpanel1.add(txtPort,cc.xy(4,4));

      addFillComponents(jpanel1,new int[]{ 1,2,3,4,5 },new int[]{ 1,2,3,4,5 });

      return jpanel1;

   }

   /**

    * Initializer

    */

   protected void initializePanel()

   {

      setLayout(new BorderLayout());

      add(createPanel(), BorderLayout.CENTER);

   }

}

package org.gvsig.oracle;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import org.gvsig.andami.IconThemeHelper;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.fmap.mapcontext.MapContextLocator;

import org.gvsig.fmap.mapcontext.MapContextManager;

import org.gvsig.tools.ToolsLocator;

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

import org.gvsig.tools.swing.api.windowmanager.Dialog;

import org.gvsig.tools.swing.api.windowmanager.WindowManager_v2;

import org.gvsig.webbrowser.WebBrowserPanel;

import org.gvsig.webbrowser.WebBrowserFactory;

public class OracleExtension extends Extension {

    @Override

    public void initialize() {

    }

    @Override

    public boolean canQueryByAction() {

        return true;

    }

    @Override

    public void postInitialize() {

        MapContextManager mapContextMgr = MapContextLocator.getMapContextManager();

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

        mapContextMgr.registerIconLayer("Oracle", "layer-icon-oracle");

    }

    @Override

    public void execute(String actionCommand) {

        if( "tools-oracle-show-admintool".equalsIgnoreCase(actionCommand) ) {

            startbrowser();

            return;

        }

    }

    @Override

    public boolean isEnabled() {

        return true;

    }

    @Override

    public boolean isVisible() {

        return true;

    }

    @Override

    public boolean isEnabled(String action) {

        if( "tools-oracle-show-admintool".equalsIgnoreCase(action) ) {

            return true;

        } 

        return false;

    }

    @Override

    public boolean isVisible(String action) {

        return true;

    }

    private void startbrowser() {

        final WindowManager_v2 winmanager = (WindowManager_v2) ToolsSwingLocator.getWindowManager();

        final HostPortPanelView panel = new HostPortPanelView();

        final Dialog dlg = winmanager.createDialog(

            panel,

            "Oracle Server",

            null, 

            WindowManager_v2.BUTTONS_OK_CANCEL

        );

        dlg.addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent e) {

                if( dlg.getAction()==WindowManager_v2.BUTTON_OK ) {

                    String url = "http://"+panel.txtServer.getText().trim() + ":" + panel.txtPort.getText().trim() + "/em";

                    WebBrowserPanel webbrowser = WebBrowserFactory.createWebBrowserPanel();

                    winmanager.showWindow(

                        webbrowser.asJComponent(), 

                        ToolsLocator.getI18nManager().getTranslation("_Oracle_administration_tool"), 

                        WindowManager_v2.MODE.WINDOW

                    );

                    webbrowser.setPage(url);

                }

            }

        });

        dlg.show(WindowManager_v2.MODE.WINDOW);

    }

}

## Oracle en gvSIG

### Limitaciones

- gvSIG convierte a mayúsculas los nombres de las tablas creadas con él.

- gvSIG convierte a mayúsculas los nombres de las columnas de tipo geometría de tablas creadas con él.

- Cuando el índice espacial no está en estado "VALID", no se utilizará éste para el cálculo del "envelope" de la capa

<?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.oracle.OracleExtension"

      description=""

      active="true">

      <action

        name="tools-oracle-show-admintool"

        label="_Oracle_administration_tool"

        position="902000200"

        icon="tools-oracle-show-admintool"

        tooltip="_Show_Oracle_administration_tool"

        action-command="tools-oracle-show-admintool"

        accelerator=""

        />

      <menu

        name="tools-oracle-show-admintool"

        text="tools/Oracle/_Show_Oracle_administration_tool"

        />

    </extension>

  </extensions>    

</plugin-config>

83030=25830

81920=4202

81921=4203

81922=20248

81923=20348

81924=20249

81925=20349

81926=20250

81927=20350

81928=20251

81929=20351

81930=20252

81931=20352

81932=20253

81933=20353

81934=20254

81935=20354

81936=20255

81937=20355

81938=20256

81939=20356

81940=20257

81941=20357

81942=20258

81943=20358

82323=23028

82328=23029

82337=23030

82340=23031

82343=23032

82346=23033

82349=23034

82352=23035

82355=23036

82358=23037

82361=23038

524288=4326

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

  <packaging>jar</packaging>

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

  <description>

Oracle support for DAL and gvSIG.

Provides viewing, editing and export/import capabilities for spatial data stored in an Oracle database. 

Works on Oracle Spatial and Oracle Locator.

  </description>

  <parent>

      <groupId>org.gvsig</groupId>

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

      <version>2.0.48</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.app.mainplugin</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.ui</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.oracle.provider</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>com.oracle</groupId>

      <artifactId>ojdbc</artifactId>

      <scope>runtime</scope>

    </dependency>

    <dependency>

      <groupId>commons-dbcp</groupId>

      <artifactId>commons-dbcp</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: Oracle 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.dependencies>required: org.gvsig.app.mainplugin -ge 2.0.1</gvsig.package.info.dependencies>

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

        <gvsig.package.info.poolURL>https://devel.gvsig.org/download/projects/gvsig-oracle/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.oracle.app</artifactId>

  <packaging>pom</packaging>

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

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.oracle</artifactId>

      <version>2.0.48</version>

  </parent>

  <modules>

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

  </modules>

</project>

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

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

  <modelVersion>4.0.0</modelVersion>

  <artifactId>org.gvsig.oracle</artifactId>

  <version>2.0.48</version>

  <packaging>pom</packaging>

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

  <description>

Oracle support fort DAL and gvSIG.

Provides viewing and editing capabilities for spatial data stored in an Oracle database. 

Works on Oracle Spatial and Oracle Locator.    

  </description>

  <parent>

      <groupId>org.gvsig</groupId>

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

      <version>2.0.330</version>

  </parent>

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

  <scm>

      <connection>scm:svn:https://devel.gvsig.org/svn/gvsig-oracle/org.gvsig.oracle/tags/org.gvsig.oracle-2.0.48</connection>

      <developerConnection>scm:svn:https://devel.gvsig.org/svn/gvsig-oracle/org.gvsig.oracle/tags/org.gvsig.oracle-2.0.48</developerConnection>

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

          <goals>deploy</goals>

        </configuration>

      </plugin>

<!--      <plugin>

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

        <artifactId>maven-surefire-plugin</artifactId>

        <version>3.0.0-M4</version>

        <configuration>

          <excludes>

            <exclude>**/TestCreate.java</exclude>

          </excludes>

        </configuration>

      </plugin>-->

    </plugins>

  </build>

  <dependencyManagement>

      <dependencies>

          <dependency>

            <groupId>org.gvsig</groupId>

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

            <version>2.0.48</version>

          </dependency>

          <dependency>

            <groupId>org.gvsig</groupId>

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

            <version>2.0.48</version>

          </dependency>

          <dependency>

              <groupId>com.oracle</groupId>

              <artifactId>ojdbc</artifactId>

              <version>11.2.0.4.0</version>

              <!--

              <version>12.2.0.1.0</version>

              -->

          </dependency>

    </dependencies>

  </dependencyManagement>

  <modules>

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

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

  </modules>

</project>

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

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

    <modelVersion>4.0.0</modelVersion>

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

    <packaging>jar</packaging>

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

    <description>DAL provider for PostgeSQL files</description>

    <parent>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.oracle</artifactId>

        <version>2.0.48</version>

    </parent>

    <dependencies>

        <dependency>

            <groupId>com.googlecode.log4jdbc</groupId>

            <artifactId>log4jdbc</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.projection.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.db.jdbc</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.db.lib</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.spi</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.metadata.lib.basic.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.geometry.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.expressionevaluator.geometry.lib.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>  

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.utils</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>com.oracle</groupId>

            <artifactId>ojdbc</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>commons-dbcp</groupId>

            <artifactId>commons-dbcp</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>commons-collections</groupId>

            <artifactId>commons-collections</artifactId>

            <scope>compile</scope>

        </dependency>

        <!-- TESTS -->

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.impl</artifactId>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>${org.gvsig.fmap.geometry.impl}</artifactId>

            <scope>test</scope>

        </dependency>    

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <type>test-jar</type>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.compat.se</artifactId>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.expressionevaluator.lib.impl</artifactId>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.expressionevaluator.geometry.lib.impl</artifactId>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>${org.gvsig.proj.lib.impl}</artifactId>

            <scope>test</scope>

        </dependency>

        <!--    <dependency>

          <groupId>org.gvsig</groupId>

          <artifactId>org.gvsig.projection.cresques.impl</artifactId>

          <scope>test</scope>

        </dependency>-->

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.compat.se</artifactId>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.metadata.lib.basic.impl</artifactId>

            <scope>test</scope>

        </dependency>      

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.timesupport.lib.impl</artifactId>

            <scope>test</scope>

        </dependency>   

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.file.csv</artifactId>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.file.lib</artifactId>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.tools.util.impl</artifactId>

            <scope>test</scope>

        </dependency>

    </dependencies>

    <build>

        <plugins>

            <plugin>

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

                <artifactId>maven-surefire-plugin</artifactId>

                <configuration>

                    <!-- Skip test execution ? -->

                    <skipTests>false</skipTests>

                    <!-- Ignore test execution failure ? -->

                    <testFailureIgnore>false</testFailureIgnore>

                    <excludes>

                        <exclude>**/TestCreate.java</exclude>

                    </excludes>

                </configuration>

            </plugin>

            <!-- Skip test compilation ? -->

            <plugin>

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

                <artifactId>maven-compiler-plugin</artifactId>

                <executions>

                    <execution>

                        <id>default-testCompile</id>

                        <phase>process-test-sources</phase>

                        <goals>

                            <goal>testCompile</goal>

                        </goals>

                        <configuration>

                            <skip>false</skip>

                        </configuration>

                    </execution>

                </executions>

            </plugin>

        </plugins>

    </build>

</project>

INSERT INTO "public"."test" ( 

    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", 

    "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", 

    "Decimal", "Geometry" 

) VALUES ( 

    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NVL2((?),SDO_GEOMETRY((?), (?)),NULL) );

-- FetchFeatureType first row SQL

SELECT * FROM "public"."test" WHERE  ROWNUM <= 1;

SELECT "USER_TAB_COLS"."COLUMN_NAME", "ALL_CONSTRAINTS"."CONSTRAINT_TYPE" 

FROM USER_TAB_COLS 

JOIN ALL_CONS_COLUMNS on (ALL_CONS_COLUMNS.TABLE_NAME = USER_TAB_COLS.TABLE_NAME and ALL_CONS_COLUMNS.COLUMN_NAME = USER_TAB_COLS.COLUMN_NAME) 

LEFT JOIN ALL_CONSTRAINTS on ALL_CONSTRAINTS.CONSTRAINT_NAME = ALL_CONS_COLUMNS.CONSTRAINT_NAME 

WHERE ( 

    (( ("USER_TAB_COLS"."TABLE_NAME") LIKE ('test') )) 

    AND 

    (( ("ALL_CONSTRAINTS"."CONSTRAINT_TYPE") = ('P') )) 

);

-- Se usa en TestCreateTable.

-- Se corresponde con el fichero CSV "testCreateSource1.csv".

CREATE TABLE "public"."TEST" (

    "ID" NUMBER(9,0), 

    "Byte" NUMBER(3,0) DEFAULT NULL, 

    "Bool1" CHAR(1) DEFAULT NULL, 

    "Long" NUMBER(18,0) DEFAULT NULL, 

    "Timestamp" TIMESTAMP DEFAULT NULL, 

    "Date" DATE DEFAULT NULL, 

    "Time" TIMESTAMP DEFAULT NULL, 

    "Bool2" CHAR(1) DEFAULT NULL, 

    "String" VARCHAR(30) DEFAULT NULL, 

    "Bool3" CHAR(1) DEFAULT NULL, 

    "Double" BINARY_DOUBLE DEFAULT NULL, 

    "Bool4" CHAR(1) DEFAULT NULL, 

    "Float" BINARY_FLOAT DEFAULT NULL, 

    "Bool5" CHAR(1) DEFAULT NULL, 

    "Decimal" NUMBER(6,3) DEFAULT NULL, 

    "GEOMETRY"  SDO_GEOMETRY DEFAULT NULL 

);

ALTER TABLE "public"."TEST" ADD PRIMARY KEY ("ID");

DELETE FROM MDSYS.OGIS_GEOMETRY_COLUMNS 

WHERE F_TABLE_SCHEMA = 'public' 

    AND F_TABLE_NAME = 'TEST' 

    AND F_GEOMETRY_COLUMN = 'GEOMETRY';

INSERT INTO MDSYS.OGIS_GEOMETRY_COLUMNS (

    F_TABLE_SCHEMA, F_TABLE_NAME, F_GEOMETRY_COLUMN, GEOMETRY_TYPE) 

    VALUES ('public', 'TEST', 'GEOMETRY', 1);

-- Create table with CLOB

CREATE TABLE "public"."TEST" (

    "ID" NUMBER(9,0), 

    "Byte" NUMBER(3,0) DEFAULT NULL, 

    "Bool1" CHAR(1) DEFAULT NULL, 

    "Long" NUMBER(18,0) DEFAULT NULL, 

    "Timestamp" TIMESTAMP DEFAULT NULL, 

    "Date" DATE DEFAULT NULL, 

    "Time" TIMESTAMP DEFAULT NULL, 

    "Bool2" CHAR(1) DEFAULT NULL, 

    "String" CLOB DEFAULT NULL, 

    "Bool3" CHAR(1) DEFAULT NULL, 

    "Double" BINARY_DOUBLE DEFAULT NULL, 

    "Bool4" CHAR(1) DEFAULT NULL, 

    "Float" BINARY_FLOAT DEFAULT NULL, 

    "Bool5" CHAR(1) DEFAULT NULL, 

    "Decimal" NUMBER(6,3) DEFAULT NULL, 

    "GEOMETRY"  SDO_GEOMETRY DEFAULT NULL 

);

ALTER TABLE "public"."TEST" ADD PRIMARY KEY ("ID");

DELETE FROM MDSYS.OGIS_GEOMETRY_COLUMNS 

WHERE F_TABLE_SCHEMA = 'public' 

    AND F_TABLE_NAME = 'TEST' 

    AND F_GEOMETRY_COLUMN = 'GEOMETRY';

INSERT INTO MDSYS.OGIS_GEOMETRY_COLUMNS (

    F_TABLE_SCHEMA, F_TABLE_NAME, F_GEOMETRY_COLUMN, GEOMETRY_TYPE) 

    VALUES ('public', 'TEST', 'GEOMETRY', 1);

-- Drop table SQL

DROP TABLE "public"."test";

DELETE FROM MDSYS.OGIS_GEOMETRY_COLUMNS WHERE F_TABLE_SCHEMA = 'public' AND F_TABLE_NAME = 'test';

-- Date SQL

SELECT 

    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", 

    "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 

    NVL2(("Geometry"),("Geometry").Get_WKB(),NULL) 

FROM "public"."test" 

WHERE ( 

    (( 

        (( ("Time") > (TIMESTAMP '1970-01-01 01:02:03') )) 

        AND 

        (( ("Time") < (TIMESTAMP '1970-01-01 20:52:55') )) 

    )) 

    OR 

    (( 

        (( ("Date") > (DATE '2019-02-17') )) 

        AND 

        (( ("Date") < (DATE '2020-02-23') )) 

    )) 

);

-- Count SQL

SELECT COUNT(*) FROM "public"."test";

-- Count SQL 1

SELECT COUNT(*) FROM "public"."test";

-- Count SQL 2

SELECT COUNT(*) FROM "dba"."test";

-- Count with group SQL

SELECT COUNT(*) 

  FROM ( 

    SELECT COUNT(*) 

    FROM "public"."test" 

    GROUP BY "Long" 

    ORDER BY "Long" ASC) 

    "_subquery_alias_" ;

-- ResultSetForSetProvider SQL

-- Simple

SELECT 

    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", 

    "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 

    NVL2(("Geometry"),("Geometry").Get_WKB(),NULL) 

FROM "public"."test";

-- Simple Group by

SELECT MIN("test"."ID") "ID", MAX("test"."Byte") "Byte", NULL "Bool1", "Long", 

    NULL "Timestamp", NULL "Date", NULL "Time", NULL "Bool2", 

    NULL "String", NULL "Bool3", SUM("test"."Double") "Double", 

    NULL "Bool4", NULL "Float", NULL "Bool5", NULL "Decimal", 

    NULL "Geometry" 

FROM "public"."test" 

GROUP BY "test"."Long";

-- Subselect

SELECT 

    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", 

    "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 

    NVL2(("Geometry"),("Geometry").Get_WKB(),NULL), 

    CASE WHEN (

        EXISTS((

            SELECT * 

            FROM ( 

                SELECT "ISO_A2" 

                FROM "countries" 

                WHERE ( (( ("test"."String") = ("countries"."CONTINENT") )) AND (( ("countries"."LASTCENSUS") < (0) )) )

            ) a WHERE ROWNUM <= 1

        ))

    ) 

    THEN (1) 

    ELSE (0) 

    END "EXISTS62a964cd7bc24f409b97c03b9170408d" 

FROM "public"."test" 

WHERE 

    EXISTS((

        SELECT * 

        FROM ( 

            SELECT "ISO_A2" 

            FROM "countries" 

            WHERE ( (( ("test"."String") = ("countries"."CONTINENT") )) AND (( ("countries"."LASTCENSUS") < (0) )) )

        ) a 

        WHERE ROWNUM <= 1

    ));

-- Group and Subselect

SELECT 

    MIN("test"."ID") "ID", MAX("test"."Byte") "Byte", NULL "Bool1", "Long", 

    NULL "Timestamp", NULL "Date", NULL "Time", NULL "Bool2", 

    NULL "String", NULL "Bool3", SUM("test"."Double") "Double", 

    NULL "Bool4", NULL "Float", NULL "Bool5", NULL "Decimal", 

    NULL "Geometry" 

FROM "public"."test" 

WHERE 

    EXISTS((

        SELECT * 

        FROM ( 

            SELECT "ISO_A2" 

            FROM "countries" 

            WHERE ( 

                (( ("test"."String") = ("countries"."CONTINENT") )) 

                AND 

                (( ("countries"."LASTCENSUS") < (0) )) 

            )

        ) a 

        WHERE ROWNUM <= 1

    )) 

GROUP BY "test"."Long";

-- Constant Column Primary Key

SELECT 

    "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", 

    "String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 

    NVL2(("Geometry"),("Geometry").Get_WKB(),NULL), "ID" 

FROM "public"."test";

-- CLOB

SELECT 

"ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", "Bool2", 

"String", "Bool3", "Double", "Bool4", "Float", "Bool5", "Decimal", 

NVL2(("Geometry"),("Geometry").Get_WKB(),NULL) 

FROM "public"."test" 

WHERE dbms_lob.compare(("String"),('hola')) = 0;

ID__Integer__set__size=0__set__precision=10__set__scale=0__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=true__set__automatic=false__set__isTime=false__set__locale=es__set__order=0__set__roundMode=4;Byte__Byte__set__size=0__set__precision=3__set__scale=0__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=10__set__roundMode=4;Bool1__Boolean__set__size=0__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=20__set__roundMode=4;Long__Long__set__size=0__set__precision=19__set__scale=0__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=30__set__roundMode=4;Timestamp__Timestamp__set__size=0__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=40__set__roundMode=4;Date__Date__set__size=0__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=50__set__roundMode=4;Time__Time__set__size=0__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=60__set__roundMode=4;Bool2__Boolean__set__size=0__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=70__set__roundMode=4;String__String__set__size=30__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=80__set__roundMode=4;Bool3__Boolean__set__size=0__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=90__set__roundMode=4;Double__Double__set__size=0__set__precision=16__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=100__set__roundMode=4;Bool4__Boolean__set__size=0__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=110__set__roundMode=4;Float__Float__set__size=0__set__precision=8__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=120__set__roundMode=4;Bool5__Boolean__set__size=0__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=130__set__roundMode=4;Decimal__Decimal__set__size=0__set__precision=6__set__scale=3__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=140__set__roundMode=4;Geometry__Geometry__set__size=0__set__precision=-1__set__scale=-1__set__hidden=false__set__readOnly=false__set__allowNull=true__set__pk=false__set__automatic=false__set__isTime=false__set__locale=es__set__order=150__set__roundMode=4__set__srs=EPSG:25830__set__geomtype=Point@2D

0;;;;;;;;      ;;;;;true;;

1;10;true;1000;29-dic-2019 12:13:14;29 de diciembre de 2019;12:13:14 CET;true;Yo yo1;false;1234554321;true;12321;true;456,123;POINT (-3.8945156972987958 42.01053743584765)

2;20;true;2000;29-nov-2019 12:13:14;29 de noviembre de 2019;13:13:14 CET;true;Yo yo2;false;1210054321;true;10021;true;456,123;POINT (-2.1079618220646115 41.983079082675474)

3;30;true;3000;29-oct-2019 12:13:14;29 de octubre de 2019;14:13:14 CET;true;Yo yo3;false;1210154321;true;10121;true;456,123;POINT (-2.57249737803327 41.35372113353277)

4;40;true;4000;29-sep-2019 12:13:14;29 de septiembre de 2019;15:13:14 CET;true;Yo yo4;false;1210254321;true;10221;true;456,123;POINT (-4.061822048036304 41.35877680235475)

5;50;true;5000;29-ago-2019 12:13:14;29 de agosto de 2019;16:13:14 CET;true;Yo yo5;false;1210354321;true;10321;true;456,123;POINT (-3.974317066986988 40.78701209315094)

6;60;true;6000;29-jul-2019 12:13:14;29 de julio de 2019;17:13:14 CET;true;Yo yo6;false;1210454321;true;10421;true;456,123;POINT (-2.510509736717547 40.69847453392384)

7;70;true;7000;29-jun-2019 12:13:14;29 de junio de 2019;18:13:14 CET;true;Yo yo7;false;1210554321;true;10521;true;456,123;POINT (-0.5317736981843011 40.66396082637622)

8;80;true;8000;29-may-2019 12:13:14;29 de mayo de 2019;19:13:14 CET;true;Yo yo8;false;1210654321;true;10621;true;456,123;POINT (-0.3626917259170671 41.13652386601604)

9;90;true;9000;29-abr-2019 12:13:14;29 de abril de 2019;20:13:14 CET;true;Yo yo9;false;1210754321;true;10721;true;456,123;POINT (-1.2461823078608523 41.84950010180092)

10;;true;1001;29-dic-2019 12:13:14;29 de diciembre de 2019;12:13:14 CET;true;Yo yo1;false;1234554321;true;12321;true;456,123;POINT (-1.2145405488596532 41.22158511004416)

11;22;;2003;29-nov-2019 12:13:14;29 de noviembre de 2019;13:13:14 CET;true;Yo yo 2;false;1210054321;true;10021;true;456,123;POINT (-0.7699089544899235 41.630581204431756)

12;33;true;;29-sep-2019 12:13:14;29 de octubre de 2019;14:13:14 CET;true;Yo yo3;false;1210154321;true;10121;true;456,123;POINT (0.4821915816701051 41.75970939133133)

13;41;true;4001;;29 de septiembre de 2019;15:13:14 CET;true;Yo yo4;false;1210254321;true;10221;true;456,123;POINT (0.7912661147227479 41.919324620992036)

14;52;true;5002;29-ago-2019 12:13:14;;16:13:14 CET;true;Yo yo5;false;1210354321;true;10321;true;456,123;POINT (1.052534629531243 41.493736996249545)

15;63;true;6003;29-jul-2019 12:13:14;29 de julio de 2019;;true;Yo yo6;false;1210454321;true;10421;true;456,123;POINT (0.8097002367335026 41.0899480235613)

16;74;true;7004;29-jun-2019 12:13:14;29 de junio de 2019;18:13:14 CET;true; ;false;1210554321;true;10521;true;456,123;POINT (-0.4883960310112362 41.17597288081971)

17;85;true;8005;29-may-2019 12:13:14;29 de mayo de 2019;19:13:14 CET;true;Yo yo8;false;;true;10621;true;456,123;POINT (-0.6439030698437881 40.89530766155764)

18;96;true;9006;29-abr-2019 12:13:14;29 de abril de 2019;20:13:14 CET;true;Yo yo9;false;1210754321;true;;true;;POINT (-1.3061826868199504 40.72372835570524)