gvSIG data provider for Oracle

#Sun Jun 26 19:22:35 CEST 2022

buildNumber=94

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

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="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);

   }

}

#Translations for language [es]

_Show_Oracle_administration_tool=Mostrar herramienta de administraci\u00f3n de Oracle

#Translations for language [en]

_Show_Oracle_administration_tool=Show Oracle administration tool

## 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="902004100"

        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/Database/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.94</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.94</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.94</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.378</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.94</connection>

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

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

          </dependency>

          <dependency>

            <groupId>org.gvsig</groupId>

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

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

org.gvsig.oracle.dal.OracleLibrary

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

<definitions>

  <version>1.0.0</version>

  <classes>

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

      <extends>

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

      </extends>

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

      <fields>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="OracleResourceParameters">

      <extends>

        <class>JDBC2ResourceParameters</class>

      </extends>

      <fields>

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

          defaultValue="oracle.jdbc.driver.OracleDriver" group="Advanced">

          <description>JDBC Driver class</description>

        </field>

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

            defaultValue="127.0.0.1" group="Connection">

          <description></description>

        </field>

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

          defaultValue="1521" group="Connection">

          <description></description>

        </field>

        <field name="mode" type="string" mandatory="false" defaultValue="SID" group="Connection">

          <description></description>

  	  <availableValues>

            <value label="Service">SERVICE</value>

            <value label="SID">SID</value>

          </availableValues>

        </field>

	<field name="LobPrefetchSize" type="String" mandatory="false"

          defaultValue="" group="Advanced">

          <description></description>

        </field>

	<field name="updateSpatialIndexAndMetadata" label="Update spatial index and metadata" type="boolean" mandatory="false"

          defaultValue="true" group="Advanced">

          <description></description>

        </field>

      </fields>

    </class>

    <class name="OracleStoreParameters">

      <extends>

        <class>JDBC2StoreParameters</class>

        <class>OracleResourceParameters</class>

      </extends>

      <fields/>

    </class>

    <class name="OracleNewStoreParameters">

      <extends>

        <class>JDBC2NewStoreParameters</class>

        <class>OracleResourceParameters</class>

      </extends>

      <fields/>

    </class>

    <class name="OracleServerExplorerParameters">

      <extends>

        <class>OracleResourceParameters</class>

        <class>JDBC2ServerExplorerParameters</class>

      </extends>

      <fields/>

    </class>

  </classes>

</definitions>  

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package org.gvsig.oracle.dal;

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

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

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

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

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

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

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

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

import static org.gvsig.oracle.dal.operations.OracleFetchFeatureTypeOperation.ORACLE_SRID_ATTR_TAG;

import org.gvsig.tools.dynobject.DynObject;

/**

 *

 * @author fdiaz

 */

public class OracleStoreProvider extends JDBCStoreProviderBase {

    private FeatureType originalFeatureType;

    public OracleStoreProvider(

            JDBCStoreParameters params,

            DataStoreProviderServices storeServices,

            DynObject metadata,

            JDBCHelper helper

    ) throws InitializeException {

        super(params, storeServices, metadata, helper);

    }

    @Override

    public void fixFeatureTypeFromParameters() {

        try {

            super.fixFeatureTypeFromParameters();

            FeatureType dalFeatureType = this.getStoreServices().getDefaultFeatureType();

            FeatureAttributeDescriptor dalGeomAttr = dalFeatureType.getDefaultGeometryAttribute();

            FeatureAttributeDescriptor originalGeomAttr = originalFeatureType.getDefaultGeometryAttribute();

            if(dalGeomAttr == null || originalGeomAttr == null){

                return;

            }

            Object v = originalGeomAttr.getTags().get(ORACLE_SRID_ATTR_TAG);

            if(v != null){

                dalGeomAttr.getTags().set(ORACLE_SRID_ATTR_TAG, v);

            }

        } catch (DataException ex) {

            //Si se produce un error respetamos el feature type del dalFile, o sea, no hacemos nada.

            LOGGER.warn("Can't fix featureType from original database feature type.", ex);

        }

    }

    @Override

    protected void initializeFeatureType() {

        super.initializeFeatureType();

        try {

            this.originalFeatureType = this.getStoreServices().getDefaultFeatureType();

        } catch (DataException ex) {

            throw new RuntimeException("Can't get originalFeatureType.", ex);

        }

    }

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2020 gvSIG Association.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 3

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.oracle.dal.operations;

import org.apache.commons.lang3.StringUtils;

import org.cresques.cts.IProjection;

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

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

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

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

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

import org.gvsig.oracle.dal.SpatialIndexUtils;

public class OracleCalculateEnvelopeOfColumnOperation extends CalculateEnvelopeOfColumnOperation {

    public OracleCalculateEnvelopeOfColumnOperation(

            JDBCHelper helper,

            FeatureType featureType,

            TableReference table,

            String columnName,

            String baseFilter,

            Envelope limit,

            IProjection crs

    ) {

        super(helper, featureType, table, columnName, baseFilter, limit, crs);

    }

    @Override

    public String getSQLWithAggregate() {

        if (StringUtils.isEmpty(baseFilter) && limit == null) {

            boolean validIndex = false;

            String indexName = SpatialIndexUtils.getSpatialIndex(conn, table.getSchema(), table.getTable(), columnName);

            if(!StringUtils.isBlank(indexName)){

                validIndex = SpatialIndexUtils.isValidSpatialIndex(conn, table.getTable());

            }

            if (validIndex) {

                StringBuilder builder = new StringBuilder();

                builder.append("SELECT SDO_TUNE.EXTENT_OF('");

                builder.append(table.getTable());

                builder.append("', '");

                builder.append(columnName);

                builder.append("').GET_WKB() FROM DUAL");

                return builder.toString();

            }

        }

        return super.getSQLWithAggregate();

    }

}

package org.gvsig.oracle.dal.operations;

import java.sql.DatabaseMetaData;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.apache.commons.lang3.StringUtils;

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

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

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

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

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

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

public class OracleCanModifyTableOperation extends CanModifyTableOperation {

    public OracleCanModifyTableOperation(JDBCHelper helper) {

        super(helper);

    }

    public OracleCanModifyTableOperation(JDBCHelper helper, TableReference table) {

        super(helper, table);

    }

    @Override

    public boolean canModifyTable(JDBCConnection conn,

            TableReference table

    ) throws DataException {

        Statement st = null;

        ResultSet rs = null;

        ResultSet rs2 = null;

        try {

            DatabaseMetaData metadata = conn.getMetaData();

            String user = helper.getConnectionParameters().getUser();

//            if (!StringUtils.equalsIgnoreCase(table.getSchema(), user)) {

//                rs = metadata.getTablePrivileges(null, table.getSchema(), table.getTable());

//                boolean canUpdate = false;

//                boolean canInsert = false;

//                String privilege;

//                while (rs.next() && !(canInsert && canUpdate)) {

//                    if (user.equalsIgnoreCase(rs.getString("GRANTEE"))) {

//                        privilege = rs.getString("PRIVILEGE");

//                        if ("INSERT".equals(privilege)) {

//                            canInsert = true;

//                        } else if ("UPDATE".equals(privilege)) {

//                            canUpdate = true;

//                        }

//                    }

//                }

//                if(!(canInsert && canUpdate)){

//                    return false;

//                }

//            }

            String sql = "select * from ALL_UPDATABLE_COLUMNS where TABLE_NAME = '"+table.getTable()+"' and OWNER = '"+StringUtils.defaultIfBlank(table.getSchema(), user)+"' and UPDATABLE='YES' and INSERTABLE='YES' and DELETABLE='YES'";

            st = conn.createStatement();

            rs2 = JDBCUtils.executeQuery(st, sql);

            if(rs2.next()){

                return true;

            }

            return false;

        } catch (SQLException ex) {

            LOGGER.error("Can't fetch table privileges", ex);

        } finally {

            JDBCUtils.closeQuietly(rs);

            JDBCUtils.closeQuietly(rs2);

            JDBCUtils.closeQuietly(st);

        }

        return false;

    }

}

package org.gvsig.oracle.dal.operations;

import java.sql.SQLException;

import java.util.Iterator;

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

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

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

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

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

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

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

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

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

import static org.gvsig.oracle.dal.SpatialIndexUtils.updateSpatialIndexAndMetadata;

@SuppressWarnings("UseSpecificCatch")

public class OraclePerformChangesOperation extends PerformChangesOperation {

    public OraclePerformChangesOperation(JDBCHelper helper) {

        super(helper);

    }

    public OraclePerformChangesOperation(JDBCHelper helper, TableReference table,

            FeatureType featureType, Iterator<FeatureReferenceProviderServices> deleteds,

            Iterator<FeatureProvider> inserteds, Iterator<FeatureProvider> updateds,

            Iterator<FeatureTypeChanged> featureTypesChanged) {

        super(helper, table, featureType, deleteds, inserteds, updateds, featureTypesChanged);

    }

    @Override

    public Object perform(JDBCConnection conn) throws DataException {

        Object result = super.perform(conn);

        try {

            // we need to commit before rebuilding the index

            conn.commit();

        } catch (SQLException e) {

            LOGGER.warn("Error commiting perform changes operation", e);

        }

        updateSpatialIndexAndMetadata(this.helper, this.table, this.featureType);

        return result;

    }

}

package org.gvsig.oracle.dal.operations;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

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

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

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

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

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

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 * Updates the layer extent on table USER_SDO_GEOM_METADATA and rebuild the

 * SpatialIndex.

 *

 * The metadata record is inserted if not existing. The SpatialIndex is also

 * created if not existing.

 *

 * @author Cesar Martinez Izquierdo

 *

 */

@SuppressWarnings("UseSpecificCatch")

public class OracleGetSRS {

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

    protected final JDBCHelper helper;

    protected final String database;

    protected final String schema;

    protected final String table;

    private JDBCConnection connection = null;

    public OracleGetSRS(

            JDBCHelper helper,

            String database,

            String schema,

            String table) {

        this.helper = helper;

        this.database = database;

        this.schema = schema;

        this.table = table;

    }

    public void begin() throws AccessResourceException {

        this.connection = this.helper.getConnection(); //.getConnectionWritable();

    }

    protected void clean() {

        JDBCConnection.closeQuietly(this.connection);

        this.connection = null;

    }

    /**

     * Executes the operation

     *

     * @return 

     * @throws DataException

     */

    public String execute() throws DataException {

        begin();

        StringBuilder srsQuery = new StringBuilder();

        srsQuery.append("select SRID from MDSYS.ALL_SDO_GEOM_METADATA where TABLE_NAME = UPPER('?');");

        PreparedStatement st = null;

        String srs = null;

        try {

            String sql = srsQuery.toString();

            st = connection.prepareStatement(sql);

            st.setString(1, table);