gvSIG data provider for Oracle

#Sun Mar 06 21:12:20 CET 2022

buildNumber=81

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

    }

}

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

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

<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"?>

<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.81</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.81</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.81</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.365</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.81</connection>

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

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

          </dependency>

          <dependency>

            <groupId>org.gvsig</groupId>

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

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

package org.gvsig.oracle.dal;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.net.URL;

import java.util.ArrayList;

import java.util.List;

import java.util.Properties;

import org.apache.commons.io.FileUtils;

import org.apache.commons.io.FilenameUtils;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataStore;

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

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

import org.gvsig.fmap.dal.feature.impl.DefaultFeature;

import org.gvsig.fmap.dal.feature.spi.FeatureProvider;

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

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

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

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

import org.gvsig.tools.resourcesstorage.ResourcesStorage;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

public class TestUtils  {

    public static final Logger LOGGER = LoggerFactory.getLogger(TestUtils.class);

    public static final String PROVIDER_NAME = OracleLibrary.NAME;

    public static final String TEST_USER = "dba";

    public static final String TEST_SCHEMA = "public";

    public static final String TEST_DB_NAME = "dbtest";

    public static OracleConnectionParameters buildDBConnection() throws Exception {

        DataManager dataManager = DALLocator.getDataManager();

        OracleConnectionParameters conn = (OracleConnectionParameters) 

                dataManager.createServerExplorerParameters(OracleLibrary.NAME);

        Properties p = new Properties();

        File userDirectory = FileUtils.getUserDirectory();

        String properties = FilenameUtils.concat(

                        userDirectory.getCanonicalPath(), 

                        ".gvSIG_Oracle_testDBConnection.properties");

        File fileProperties = new File(properties);

        if(!fileProperties.exists()) {

            p.setProperty("host", "127.0.0.1");

            p.setProperty("port", "1521");

            p.setProperty("dbuser", TEST_USER);

            p.setProperty("schema", TEST_SCHEMA);

            p.setProperty("password", "PASSWD");

            p.setProperty("dbname", TEST_DB_NAME);

            p.setProperty("mode", "service");

            p.store(new FileOutputStream(properties), "Oracle test DB connection");

        } else {

            FileInputStream fis = new FileInputStream(properties);

            p.load(fis);

        }

        conn.setDynValue("host", p.getProperty("host", null));

        conn.setDynValue("port", p.getProperty("port", null));

        conn.setDynValue("dbuser", p.getProperty("dbuser", null));

        conn.setDynValue("schema", p.getProperty("schema", null));

        conn.setDynValue("password", p.getProperty("password", null));

        conn.setDynValue("dbname", p.getProperty("dbname", null));

        conn.setDynValue("mode", p.getProperty("mode", null));

        return conn;

    }

    public static JDBCServerExplorer openServerExplorer() throws Exception {

        DataManager dataManager = DALLocator.getDataManager();

        OracleConnectionParameters conn = buildDBConnection();

        JDBCServerExplorer explorer = (JDBCServerExplorer) dataManager.openServerExplorer(

                PROVIDER_NAME, conn

        );

        return explorer;

    }

    public static File getTargetFolder() throws Exception {

        URL url = TestUtils.class.getResource("/");

        File x = new File(url.toURI());

        File target = x.getParentFile();

        return target;

    }

    public static File getResource(String name) throws Exception {

        File x = new File(getTargetFolder(), name);

        return x;

    }

    public static File getResourceAsFile(String pathname) throws Exception {

        URL url = TestUtils.class.getResource(pathname);

        File x = new File(url.toURI());

        return x;

    }

    public static void removeDALResource(String tableName) throws Exception {

//        OracleConnectionParameters connection = buildDBConnection(dbname);

//        DatabaseWorkspaceManager workspace = DALLocator.getDataManager().createDatabaseWorkspaceManager(

//                (DataServerExplorerParameters) connection

//        );

        JDBCServerExplorer explorer = openServerExplorer();

        JDBCStoreParameters params = explorer.get(tableName);

        ResourcesStorage resources = explorer.getResourcesStorage(params);

        resources.remove("dal");

    }

    public static FeatureStore openSourceStore1() throws Exception {

        DataManager dataManager = DALLocator.getDataManager();

        File f = getResourceAsFile("/org/gvsig/oracle/dal/testCreateSource1.csv");

        FeatureStore store = (FeatureStore) dataManager.openStore(

                DataStore.CSV_PROVIDER_NAME, 

                "file=",f,

                "automaticTypesDetection=", false,

                "locale=","en"

        );

        return store;

    }

    public static FeatureStore openSourceStoreShort() throws Exception {

        DataManager dataManager = DALLocator.getDataManager();

        File f = getResourceAsFile("/org/gvsig/oracle/dal/testCreateSource_short.csv");

        FeatureStore store = (FeatureStore) dataManager.openStore(

                DataStore.CSV_PROVIDER_NAME, 

                "file=",f,

                "automaticTypesDetection=", false,

                "locale=","en"

        );

        return store;

    }

    public static List<String> getSQLs(String name) throws Exception {

      File f = getResourceAsFile("/org/gvsig/oracle/dal/"+name);

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

      List<String> lines = FileUtils.readLines(f);

      StringBuilder sb = new StringBuilder();

      for (String line : lines) {

        line = StringUtils.stripStart(line, null);

        if( line.startsWith("--") ) {

          continue;

        }

        if( line.endsWith(";") ) {

          sb.append(line.substring(0, line.length()-1));

          SQLs.add(sb.toString());

          sb.setLength(0);

        } else {

          sb.append(line);

        }

      }

      return SQLs;

    }

    public static FeatureProvider getFeatureProvider(Feature feature) {

      return ((DefaultFeature)feature).getData();

    }

    public static JDBCHelper getJDBCHelper() {

      return getJDBCHelper(TEST_SCHEMA, TEST_USER);

    }

    public static JDBCHelper getJDBCHelper(String schema, String user) {

      OracleExplorerParameters params = new OracleExplorerParameters();

      params.setSchema(schema);

      params.setUser(user);

      params.setDBName(TEST_DB_NAME);

      OracleHelper helper = new OracleHelper(params, new FakeConnectionProvider(params));

      return helper;

    }

}

package org.gvsig.oracle.dal;

import java.util.Date;

import java.util.List;

import junit.framework.TestCase;

import static junit.framework.TestCase.assertEquals;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataTypes;

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

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

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

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

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

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

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

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

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

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

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.tools.library.impl.DefaultLibrariesInitializer;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

public class TestCreate extends TestCase {

    private static final Logger LOGGER = LoggerFactory.getLogger(TestCreate.class);

    public static final String DBNAME = "testCreate";

    public static final int ZERO_DEFAULT_DISPLAY_SIZE = 0;

    public static final int BYTE_DEFAULT_DISPLAY_SIZE = 4;

    public static final int FLOAT_DEFAULT_DISPLAY_SIZE = 4;

    public static final int DOUBLE_DEFAULT_DISPLAY_SIZE = 8;

    public TestCreate(String testName) {

        super(testName);

    }

    @Override

    protected void setUp() throws Exception {

        super.setUp();

        new DefaultLibrariesInitializer().fullInitialize();

    }

    @Override

    protected void tearDown() throws Exception {

        super.tearDown();

    }

    // TODO add test methods here. The name must begin with 'test'. For example:

    // public void testHello() {}

    protected String getProviderName() {

        return OracleLibrary.NAME;

    }

    protected String getTargetName() {

        return "testCreateTarget6".toUpperCase();

    }

    protected FeatureStore openTargetStore1(JDBCServerExplorer explorer) throws Exception {

        JDBCStoreParameters params = explorer.get(getTargetName());

        DataManager dataManager = DALLocator.getDataManager();

        FeatureStore store;

        try {

            store = (FeatureStore) dataManager.openStore(

                    getProviderName(),

                    params

            );

        } catch (ValidateDataParametersException ex) {

            LOGGER.warn(ex.getLocalizedMessageStack());

            throw ex;

        }

        return store;

    }

    protected void createFrom(JDBCServerExplorer explorer, FeatureStore sourceStore) throws Exception {

        NewFeatureStoreParameters params = (NewFeatureStoreParameters) explorer.getAddParameters(

                getTargetName()

        );

        EditableFeatureType ft = params.getDefaultFeatureType();

        ft.addAll(sourceStore.getDefaultFeatureType());

        explorer.add(getProviderName(), params, true);

    }

    protected void checkTypes(JDBCServerExplorer explorer, FeatureType sourceFeatureType, boolean withDalResource) throws Exception {

        FeatureStore targetStore = openTargetStore1(explorer);

        FeatureType targetFeatureType = targetStore.getDefaultFeatureType();

        assertEquals("Feature type size", sourceFeatureType.size(), targetFeatureType.size());

        for (int i = 0; i < sourceFeatureType.size(); i++) {

            FeatureAttributeDescriptor sourceAttr = sourceFeatureType.get(i);

            FeatureAttributeDescriptor targetAttr = targetFeatureType.get(i);

            if (withDalResource) {

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

                    assertEquals(

                            String.format("Field %s name mismatch", sourceAttr.getName()),

                            sourceAttr.getName().toUpperCase(),

                            targetAttr.getName()

                    );

                } else {

                    assertEquals(

                            String.format("Field %s name mismatch", sourceAttr.getName()),

                            sourceAttr.getName(),

                            targetAttr.getName()

                    );

                }

                assertEquals(

                        String.format("Field %s type mismatch", sourceAttr.getName()),

                        sourceAttr.getDataTypeName(),

                        targetAttr.getDataTypeName()

                );

                assertEquals(

                        String.format("Field %s display size mismatch", sourceAttr.getName()),

                        sourceAttr.getDisplaySize(),

                        targetAttr.getDisplaySize()

                );

                assertEquals(

                        String.format("Field %s size mismatch", sourceAttr.getName()),

                        sourceAttr.getSize(),

                        targetAttr.getSize()

                );

                assertEquals(

                        String.format("Field %s precision mismatch", sourceAttr.getName()),

                        sourceAttr.getPrecision(),

                        targetAttr.getPrecision()

                );

                assertEquals(

                        String.format("Field %s scale mismatch", sourceAttr.getName()),

                        sourceAttr.getScale(),

                        targetAttr.getScale()

                );

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

                    assertEquals(

                            String.format("Field %s geometry type mismatch", sourceAttr.getName()),

                            sourceAttr.getGeomType().getName(),

                            targetAttr.getGeomType().getName()

                    );

                    assertEquals(

                            String.format("Field %s geometry SRS mismatch", sourceAttr.getName()),

                            sourceAttr.getSRS().getAbrev(),

                            targetAttr.getSRS().getAbrev()

                    );

                }

            } else {

                switch (sourceAttr.getType()) {

                    case DataTypes.BYTE:

                        assertEquals(

                                String.format("Field %s name mismatch", sourceAttr.getName()),

                                sourceAttr.getName(),

                                targetAttr.getName()

                        );

                        assertEquals(

                                String.format("Field %s type mismatch", sourceAttr.getName()),

                                DataTypes.DECIMAL,

                                targetAttr.getDataType().getType()

                        );

                        assertEquals(

                                String.format("Field %s display size mismatch", sourceAttr.getName()),

                                BYTE_DEFAULT_DISPLAY_SIZE,

                                targetAttr.getDisplaySize()

                        );

                        assertEquals(

                                String.format("Field %s size mismatch", sourceAttr.getName()),

                                sourceAttr.getSize(),

                                targetAttr.getSize()

                        );

                        assertEquals(

                                String.format("Field %s precision mismatch", sourceAttr.getName()),

                                sourceAttr.getPrecision(),

                                targetAttr.getPrecision()

                        );

                        assertEquals(

                                String.format("Field %s scale mismatch", sourceAttr.getName()),

                                sourceAttr.getScale(),

                                targetAttr.getScale()

                        );

                        break;

                    case DataTypes.BOOLEAN:

                        assertEquals(

                                String.format("Field %s name mismatch", sourceAttr.getName()),

                                sourceAttr.getName(),

                                targetAttr.getName()

                        );

                        assertEquals(

                                String.format("Field %s type mismatch", sourceAttr.getName()),

                                DataTypes.STRING_NAME,

                                targetAttr.getDataTypeName()

                        );

                        assertEquals(String.format("Field %s display size mismatch", sourceAttr.getName()),

                                ZERO_DEFAULT_DISPLAY_SIZE,

                                targetAttr.getDisplaySize()

                        );

                        assertEquals(String.format("Field %s size mismatch", sourceAttr.getName()),

                                OracleSQLBuilder.BOOLEAN_STRING_DEFAULT_LENGTH,

                                targetAttr.getSize()

                        );

                        assertEquals(

                                String.format("Field %s precision mismatch", sourceAttr.getName()),

                                sourceAttr.getPrecision(),

                                targetAttr.getPrecision()

                        );

                        assertEquals(

                                String.format("Field %s scale mismatch", sourceAttr.getName()),

                                sourceAttr.getScale(),

                                targetAttr.getScale()

                        );

                        break;

                    case DataTypes.STRING:

                        assertEquals(

                                String.format("Field %s name mismatch", sourceAttr.getName()),

                                sourceAttr.getName(),

                                targetAttr.getName()

                        );

                        assertEquals(

                                String.format("Field %s type mismatch", sourceAttr.getName()),

                                sourceAttr.getDataTypeName(),

                                targetAttr.getDataTypeName()

                        );

                        assertEquals(String.format("Field %s display size mismatch", sourceAttr.getName()),

                                ZERO_DEFAULT_DISPLAY_SIZE,

                                targetAttr.getDisplaySize()

                        );

                        assertEquals(

                                String.format("Field %s size mismatch", sourceAttr.getName()),

                                sourceAttr.getSize(),

                                targetAttr.getSize()

                        );

                        assertEquals(

                                String.format("Field %s precision mismatch", sourceAttr.getName()),

                                sourceAttr.getPrecision(),

                                targetAttr.getPrecision()

                        );

                        assertEquals(

                                String.format("Field %s scale mismatch", sourceAttr.getName()),

                                sourceAttr.getScale(),

                                targetAttr.getScale()

                        );

                        break;

                    case DataTypes.TIME:

                    case DataTypes.DATE:

                        assertEquals(

                                String.format("Field %s name mismatch", sourceAttr.getName()),

                                sourceAttr.getName(),

                                targetAttr.getName()

                        );

                        assertEquals(

                                String.format("Field %s type mismatch", sourceAttr.getName()),

                                DataTypes.TIMESTAMP_NAME,

                                targetAttr.getDataTypeName()

                        );

                        assertEquals(String.format("Field %s display size mismatch", sourceAttr.getName()),

                                ZERO_DEFAULT_DISPLAY_SIZE,

                                targetAttr.getDisplaySize()

                        );

                        assertEquals(

                                String.format("Field %s size mismatch", sourceAttr.getName()),

                                sourceAttr.getSize(),

                                targetAttr.getSize()

                        );

                        assertEquals(

                                String.format("Field %s precision mismatch", sourceAttr.getName()),

                                sourceAttr.getPrecision(),

                                targetAttr.getPrecision()

                        );

                        assertEquals(

                                String.format("Field %s scale mismatch", sourceAttr.getName()),

                                sourceAttr.getScale(),

                                targetAttr.getScale()

                        );

                        break;

                    case DataTypes.DOUBLE:

                        assertEquals(

                                String.format("Field %s name mismatch", sourceAttr.getName()),

                                sourceAttr.getName(),

                                targetAttr.getName()

                        );

                        assertEquals(

                                String.format("Field %s type mismatch", sourceAttr.getName()),

                                sourceAttr.getDataTypeName(),

                                targetAttr.getDataTypeName()

                        );

                        assertEquals(

                                String.format("Field %s display size mismatch", sourceAttr.getName()),

                                DOUBLE_DEFAULT_DISPLAY_SIZE,

                                targetAttr.getDisplaySize()

                        );

                        assertEquals(

                                String.format("Field %s size mismatch", sourceAttr.getName()),

                                sourceAttr.getSize(),

                                targetAttr.getSize()

                        );

                        assertEquals(

                                String.format("Field %s precision mismatch", sourceAttr.getName()),

                                sourceAttr.getPrecision(),

                                targetAttr.getPrecision()

                        );

                        assertEquals(

                                String.format("Field %s scale mismatch", sourceAttr.getName()),

                                sourceAttr.getScale(),

                                targetAttr.getScale()

                        );

                        break;

                    case DataTypes.FLOAT:

                        assertEquals(

                                String.format("Field %s name mismatch", sourceAttr.getName()),

                                sourceAttr.getName(),

                                targetAttr.getName()

                        );

                        assertEquals(

                                String.format("Field %s type mismatch", sourceAttr.getName()),

                                sourceAttr.getDataTypeName(),

                                targetAttr.getDataTypeName()

                        );

                        assertEquals(

                                String.format("Field %s display size mismatch", sourceAttr.getName()),