gvSIG data provider for Oracle

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

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

 <at name="fileversion">

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

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

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

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

  </object>

 </at>

 <at name="form">

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

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

    <at name="cellconstraints">

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

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

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

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

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

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

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

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

     </object>

    </at>

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

   </super>

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

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

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

   <at name="components">

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

     <item >

      <at name="value">

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

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

         <at name="cellconstraints">

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

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

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

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

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

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

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

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

          </object>

         </at>

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

        </super>

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

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

        <at name="beanproperties">

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

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

          <at name="properties">

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

            <at name="border">

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

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

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

              </super>

              <at name="borders">

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

                <item >

                 <at name="value">

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

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

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

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

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

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

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

            <at name="fill">

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

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

             </object>

            </at>

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

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

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

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

         <at name="cellconstraints">

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

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

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

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

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

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

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

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

          </object>

         </at>

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

        </super>

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

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

        <at name="beanproperties">

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

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

          <at name="properties">

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

            <at name="border">

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

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

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

              </super>

              <at name="borders">

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

                <item >

                 <at name="value">

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

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

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

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

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

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

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

            <at name="fill">

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

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

             </object>

            </at>

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

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

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

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

         <at name="cellconstraints">

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

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

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

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

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

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

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

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

          </object>

         </at>

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

        </super>

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

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

        <at name="beanproperties">

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

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

          <at name="properties">

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

            <at name="border">

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

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

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

              </super>

              <at name="borders">

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

                <item >

                 <at name="value">

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

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

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

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

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

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

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

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

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

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

         <at name="cellconstraints">

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

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

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

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

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

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

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

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

          </object>

         </at>

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

        </super>

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

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

        <at name="beanproperties">

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

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

          <at name="properties">

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

            <at name="border">

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

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

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

              </super>

              <at name="borders">

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

                <item >

                 <at name="value">

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

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

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

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

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

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

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

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

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

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

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

    </object>

   </at>

   <at name="properties">

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

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

     <at name="properties">

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

       <at name="border">

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

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

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

         </super>

         <at name="borders">

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

         </at>

        </object>

       </at>

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

       <at name="fill">

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

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

        </object>

       </at>

       <at name="scollBars">

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

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

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

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

         <at name="border">

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

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

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

           </super>

           <at name="borders">

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

             <item >

              <at name="value">

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

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

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

                </super>

               </object>

              </at>

             </item>

            </object>

           </at>

          </object>

         </at>

        </object>

       </at>

      </object>

     </at>

    </object>

   </at>

   <at name="cellpainters">

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

     <at name="rows">

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

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

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

       </at>

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

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

       </at>

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

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

       </at>

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

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

       </at>

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

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

       </at>

      </object>

     </at>

    </object>

   </at>

   <at name="rowgroups">

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

     <at name="groups">

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

     </at>

    </object>

   </at>

   <at name="colgroups">

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

     <at name="groups">

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

     </at>

    </object>

   </at>

  </object>

 </at>

</object>

package org.gvsig.oracle;

import com.jeta.open.i18n.I18NUtils;

import com.jgoodies.forms.layout.CellConstraints;

import com.jgoodies.forms.layout.FormLayout;

import java.awt.BorderLayout;

import java.awt.ComponentOrientation;

import java.awt.Container;

import java.awt.Dimension;

import javax.swing.Box;

import javax.swing.ImageIcon;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

public class HostPortPanelView extends JPanel

{

   JTextField txtServer = new JTextField();

   JTextField txtPort = new JTextField();

   /**

    * Default constructor

    */

   public HostPortPanelView()

   {

      initializePanel();

   }

   /**

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

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

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

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

    */

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

   {

      Dimension filler = new Dimension(10,10);

      boolean filled_cell_11 = false;

      CellConstraints cc = new CellConstraints();

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

      {

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

         {

            /** add a rigid area  */

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

            filled_cell_11 = true;

         }

      }

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

      {

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

         {

            continue;

         }

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

      }

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

      {

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

         {

            continue;

         }

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

      }

   }

   /**

    * Helper method to load an image file from the CLASSPATH

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

    * @return an ImageIcon instance with the specified image file

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

    */

   public ImageIcon loadImage( String imageName )

   {

      try

      {

         ClassLoader classloader = getClass().getClassLoader();

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

         if ( url != null )

         {

            ImageIcon icon = new ImageIcon( url );

            return icon;

         }

      }

      catch( Exception e )

      {

         e.printStackTrace();

      }

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

   }

   /**

    * Method for recalculating the component orientation for 

    * right-to-left Locales.

    * @param orientation the component orientation to be applied

    */

   public void applyComponentOrientation( ComponentOrientation orientation )

   {

      // Not yet implemented...

      // I18NUtils.applyComponentOrientation(this, orientation);

      super.applyComponentOrientation(orientation);

   }

   public JPanel createPanel()

   {

      JPanel jpanel1 = new JPanel();

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

      CellConstraints cc = new CellConstraints();

      jpanel1.setLayout(formlayout1);

      JLabel jlabel1 = new JLabel();

      jlabel1.setText("Server");

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

      JLabel jlabel2 = new JLabel();

      jlabel2.setText("Port");

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

      txtServer.setName("txtServer");

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

      txtPort.setName("txtPort");

      txtPort.setSelectionEnd(4);

      txtPort.setSelectionStart(4);

      txtPort.setText("5500");

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

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

      return jpanel1;

   }

   /**

    * Initializer

    */

   protected void initializePanel()

   {

      setLayout(new BorderLayout());

      add(createPanel(), BorderLayout.CENTER);

   }

}

package org.gvsig.oracle;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import org.gvsig.andami.IconThemeHelper;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.fmap.mapcontext.MapContextLocator;

import org.gvsig.fmap.mapcontext.MapContextManager;

import org.gvsig.tools.ToolsLocator;

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

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

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

import org.gvsig.webbrowser.WebBrowserPanel;

import org.gvsig.webbrowser.WebBrowserFactory;

public class OracleExtension extends Extension {

    @Override

    public void initialize() {

    }

    @Override

    public boolean canQueryByAction() {

        return true;

    }

    @Override

    public void postInitialize() {

        MapContextManager mapContextMgr = MapContextLocator.getMapContextManager();

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

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

    }

    @Override

    public void execute(String actionCommand) {

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

            startbrowser();

            return;

        }

    }

    @Override

    public boolean isEnabled() {

        return true;

    }

    @Override

    public boolean isVisible() {

        return true;

    }

    @Override

    public boolean isEnabled(String action) {

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

            return true;

        } 

        return false;

    }

    @Override

    public boolean isVisible(String action) {

        return true;

    }

    private void startbrowser() {

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

        final HostPortPanelView panel = new HostPortPanelView();

        final Dialog dlg = winmanager.createDialog(

            panel,

            "Oracle Server",

            null, 

            WindowManager_v2.BUTTONS_OK_CANCEL

        );

        dlg.addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent e) {

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

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

                    WebBrowserPanel webbrowser = WebBrowserFactory.createWebBrowserPanel();

                    winmanager.showWindow(

                        webbrowser.asJComponent(), 

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

                        WindowManager_v2.MODE.WINDOW

                    );

                    webbrowser.setPage(url);

                }

            }

        });

        dlg.show(WindowManager_v2.MODE.WINDOW);

    }

}

## Oracle en gvSIG

### Limitaciones

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

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

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

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugin-config>

  <libraries library-dir="lib/"/>

  <depends plugin-name="org.gvsig.app.mainplugin"/>

  <resourceBundle name="text"/>

  <extensions>

    <extension class-name="org.gvsig.oracle.OracleExtension"

      description=""

      active="true">

      <action

        name="tools-oracle-show-admintool"

        label="_Oracle_administration_tool"

        position="902000200"

        icon="tools-oracle-show-admintool"

        tooltip="_Show_Oracle_administration_tool"

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

        accelerator=""

        />

      <menu

        name="tools-oracle-show-admintool"

        text="tools/Oracle/_Show_Oracle_administration_tool"

        />

    </extension>

  </extensions>    

</plugin-config>

83030=25830

81920=4202

81921=4203

81922=20248

81923=20348

81924=20249

81925=20349

81926=20250

81927=20350

81928=20251

81929=20351

81930=20252

81931=20352

81932=20253

81933=20353

81934=20254

81935=20354

81936=20255

81937=20355

81938=20256

81939=20356

81940=20257

81941=20357

81942=20258

81943=20358

82323=23028

82328=23029

82337=23030

82340=23031

82343=23032

82346=23033

82349=23034

82352=23035

82355=23036

82358=23037

82361=23038

524288=4326

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

#Tue Jul 20 01:38:05 CEST 2021

buildNumber=45

<?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.46</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.46</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.328</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.46</connection>

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

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

          </dependency>

          <dependency>

            <groupId>org.gvsig</groupId>

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

            <version>2.0.46</version>

          </dependency>

          <dependency>

              <groupId>com.oracle</groupId>

              <artifactId>ojdbc</artifactId>

              <version>11.2.0.4.0</version>

              <!--

              <version>12.2.0.1.0</version>

              -->

          </dependency>

    </dependencies>

  </dependencyManagement>

  <modules>

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

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

  </modules>

</project>

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

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

    <modelVersion>4.0.0</modelVersion>

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

    <packaging>jar</packaging>

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

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

    <parent>

        <groupId>org.gvsig</groupId>

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

        <version>2.0.46</version>

    </parent>

    <dependencies>

        <dependency>

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

            <artifactId>log4jdbc</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>  

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>com.oracle</groupId>

            <artifactId>ojdbc</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>commons-dbcp</groupId>

            <artifactId>commons-dbcp</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>commons-collections</groupId>

            <artifactId>commons-collections</artifactId>

            <scope>compile</scope>

        </dependency>

        <!-- TESTS -->

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>    

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <type>test-jar</type>

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>

        <!--    <dependency>

          <groupId>org.gvsig</groupId>

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

          <scope>test</scope>

        </dependency>-->

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>      

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>   

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>test</scope>

        </dependency>

    </dependencies>

    <build>

        <plugins>

            <plugin>

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

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

                <configuration>

                    <!-- Skip test execution ? -->

                    <skipTests>false</skipTests>

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

                    <testFailureIgnore>false</testFailureIgnore>

                    <excludes>

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

                    </excludes>

                </configuration>

            </plugin>

            <!-- Skip test compilation ? -->

            <plugin>

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

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

                <executions>

                    <execution>

                        <id>default-testCompile</id>

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

                        <goals>

                            <goal>testCompile</goal>

                        </goals>

                        <configuration>

                            <skip>false</skip>

                        </configuration>

                    </execution>

                </executions>

            </plugin>

        </plugins>

    </build>

</project>

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

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

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

/*

 * 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 java.io.IOException;

import java.io.InputStream;

import java.sql.Connection;

import java.util.Objects;

import java.util.Properties;

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

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

/**

 *

 * @author fdiaz

 */

public class OracleSRSSolver extends SRSSolverBase{

    private static Properties translations;

    public OracleSRSSolver(JDBCHelper helper) {

        super(helper);

    }

    @Override

    protected Object searchDatabaseCode(Connection connection, String applicationAbbrev) {

        try {

            String[] s = applicationAbbrev.split(":");

            String code_s = s[1].trim();

            try {

                int code_i = Integer.parseInt(code_s);

                return code_i;

            } catch(NumberFormatException e) {

            }

            return 0;

        } catch (Throwable ex) {

            throw new RuntimeException("Problems searching database code from '"+applicationAbbrev+"'.",ex);

        }

    }

    @Override

    protected String searchApplicationAbbrev(Connection connection, Integer databaseCode) {

        try {

            String s = Objects.toString(databaseCode,"0");

            String trans = getTranslations().getProperty(s, null);

            if(trans == null){

                return null;

            }

            return "EPSG:" + trans;

        } catch (Throwable ex) {

            throw new RuntimeException("Problems searching application abbrev from '"+databaseCode+"'.",ex);

        }

    }    

    private Properties getTranslations() {

        if (translations == null) {

            InputStream inStream = this.getClass().getClassLoader().getResourceAsStream("/srids/oracle2epsg.properties");

            if (inStream != null) {

                translations = new Properties();

                try {

                    translations.load(inStream);

                } catch (IOException ex) {

                    logger.warn("Can't load srid translations", ex);

                }

            }

        }

        return translations;

    }

}

package org.gvsig.oracle.dal;

import org.gvsig.fmap.dal.DALLibrary;

import org.gvsig.fmap.dal.DALLocator;

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

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

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

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

import org.gvsig.json.Json;

import org.gvsig.metadata.exceptions.MetadataException;

import org.gvsig.tools.library.AbstractLibrary;

import org.gvsig.tools.library.LibraryException;

public class OracleLibrary extends AbstractLibrary {

    public static final String NAME = "Oracle";

    @Override

    public void doRegistration() {

        registerAsServiceOf(DALLibrary.class);

        require(JDBCLibrary.class);

    }

    @Override

    protected void doInitialize() throws LibraryException {

    }

    @Override

    protected void doPostInitialize() throws LibraryException {

        LibraryException ex = null;

        DataManagerProviderServices dataman = 

                (DataManagerProviderServices) DALLocator.getDataManager();

        try {

            Class.forName(OracleHelper.ORACLE_JDBC_DRIVER);

        } catch(Throwable th) {

            OracleHelper.LOGGER.warn("Can't load Oracle JDBC Driver.",th);

        }

        DBHelper.registerParametersDefinition(

                NAME + "StoreParameters",

                OracleStoreParameters.class,

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

        );

        DBHelper.registerParametersDefinition(

                NAME + "NewStoreParameters",

                OracleNewStoreParameters.class,

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

        );

        DBHelper.registerParametersDefinition(

                NAME + "ServerExplorerParameters",

                OracleExplorerParameters.class,

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

        );

        try {

            DBHelper.registerMetadataDefinition(

                NAME,

                JDBCStoreProviderBase.class,

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

            );

        } catch (MetadataException e) {

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

        }