gvSIG data provider for Oracle

<?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.9</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 Jun 12 20:26:56 CEST 2018

buildNumber=8

<assembly>

  <id>gvsig-plugin-package</id>

  <formats>

    <format>zip</format>

  </formats>

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

  <includeBaseDirectory>true</includeBaseDirectory>

  <files>

    <file>

      <source>target/${project.artifactId}-${project.version}.jar</source>

      <outputDirectory>lib</outputDirectory>

    </file>

    <file>

      <source>target/package.info</source>

    </file>

  </files>

  <fileSets>

    <fileSet>

      <directory>src/main/resources-plugin</directory>

      <outputDirectory>.</outputDirectory>

    </fileSet>

  </fileSets>

  <dependencySets>

    <dependencySet>

      <useProjectArtifact>false</useProjectArtifact>

      <useTransitiveDependencies>false</useTransitiveDependencies>

      <outputDirectory>lib</outputDirectory>

      <includes>

            <include>org.gvsig:org.gvsig.oracle.provider</include>

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

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

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

      </includes>

    </dependencySet>

  </dependencySets>

</assembly>

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

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

 <at name="fileversion">

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

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

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

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

  </object>

 </at>

 <at name="form">

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

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

    <at name="cellconstraints">

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

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

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

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

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

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

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

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

     </object>

    </at>

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

   </super>

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

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

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

   <at name="components">

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

     <item >

      <at name="value">

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

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

         <at name="cellconstraints">

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

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

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

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

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

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

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

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

          </object>

         </at>

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

        </super>

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

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

        <at name="beanproperties">

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

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

          <at name="properties">

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

            <at name="border">

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

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

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

              </super>

              <at name="borders">

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

                <item >

                 <at name="value">

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

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

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

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

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

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

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

            <at name="fill">

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

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

             </object>

            </at>

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

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

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

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

         <at name="cellconstraints">

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

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

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

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

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

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

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

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

          </object>

         </at>

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

        </super>

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

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

        <at name="beanproperties">

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

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

          <at name="properties">

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

            <at name="border">

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

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

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

              </super>

              <at name="borders">

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

                <item >

                 <at name="value">

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

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

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

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

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

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

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

            <at name="fill">

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

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

             </object>

            </at>

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

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

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

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

         <at name="cellconstraints">

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

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

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

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

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

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

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

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

          </object>

         </at>

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

        </super>

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

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

        <at name="beanproperties">

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

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

          <at name="properties">

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

            <at name="border">

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

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

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

              </super>

              <at name="borders">

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

                <item >

                 <at name="value">

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

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

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

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

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

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

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

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

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

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

         <at name="cellconstraints">

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

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

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

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

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

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

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

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

          </object>

         </at>

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

        </super>

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

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

        <at name="beanproperties">

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

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

          <at name="properties">

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

            <at name="border">

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

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

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

              </super>

              <at name="borders">

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

                <item >

                 <at name="value">

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

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

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

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

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

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

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

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

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

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

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

    </object>

   </at>

   <at name="properties">

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

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

     <at name="properties">

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

       <at name="border">

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

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

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

         </super>

         <at name="borders">

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

         </at>

        </object>

       </at>

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

       <at name="fill">

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

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

        </object>

       </at>

       <at name="scollBars">

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

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

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

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

         <at name="border">

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

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

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

           </super>

           <at name="borders">

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

             <item >

              <at name="value">

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

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

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

                </super>

               </object>

              </at>

             </item>

            </object>

           </at>

          </object>

         </at>

        </object>

       </at>

      </object>

     </at>

    </object>

   </at>

   <at name="cellpainters">

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

     <at name="rows">

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

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

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

       </at>

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

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

       </at>

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

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

       </at>

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

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

       </at>

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

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

       </at>

      </object>

     </at>

    </object>

   </at>

   <at name="rowgroups">

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

     <at name="groups">

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

     </at>

    </object>

   </at>

   <at name="colgroups">

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

     <at name="groups">

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

     </at>

    </object>

   </at>

  </object>

 </at>

</object>

package org.gvsig.oracle;

import com.jeta.open.i18n.I18NUtils;

import com.jgoodies.forms.layout.CellConstraints;

import com.jgoodies.forms.layout.FormLayout;

import java.awt.BorderLayout;

import java.awt.ComponentOrientation;

import java.awt.Container;

import java.awt.Dimension;

import javax.swing.Box;

import javax.swing.ImageIcon;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

public class HostPortPanelView extends JPanel

{

   JTextField txtServer = new JTextField();

   JTextField txtPort = new JTextField();

   /**

    * Default constructor

    */

   public HostPortPanelView()

   {

      initializePanel();

   }

   /**

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

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

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

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

    */

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

   {

      Dimension filler = new Dimension(10,10);

      boolean filled_cell_11 = false;

      CellConstraints cc = new CellConstraints();

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

      {

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

         {

            /** add a rigid area  */

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

            filled_cell_11 = true;

         }

      }

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

      {

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

         {

            continue;

         }

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

      }

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

      {

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

         {

            continue;

         }

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

      }

   }

   /**

    * Helper method to load an image file from the CLASSPATH

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

    * @return an ImageIcon instance with the specified image file

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

    */

   public ImageIcon loadImage( String imageName )

   {

      try

      {

         ClassLoader classloader = getClass().getClassLoader();

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

         if ( url != null )

         {

            ImageIcon icon = new ImageIcon( url );

            return icon;

         }

      }

      catch( Exception e )

      {

         e.printStackTrace();

      }

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

   }

   /**

    * Method for recalculating the component orientation for 

    * right-to-left Locales.

    * @param orientation the component orientation to be applied

    */

   public void applyComponentOrientation( ComponentOrientation orientation )

   {

      // Not yet implemented...

      // I18NUtils.applyComponentOrientation(this, orientation);

      super.applyComponentOrientation(orientation);

   }

   public JPanel createPanel()

   {

      JPanel jpanel1 = new JPanel();

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

      CellConstraints cc = new CellConstraints();

      jpanel1.setLayout(formlayout1);

      JLabel jlabel1 = new JLabel();

      jlabel1.setText("Server");

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

      JLabel jlabel2 = new JLabel();

      jlabel2.setText("Port");

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

      txtServer.setName("txtServer");

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

      txtPort.setName("txtPort");

      txtPort.setSelectionEnd(4);

      txtPort.setSelectionStart(4);

      txtPort.setText("5500");

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

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

      return jpanel1;

   }

   /**

    * Initializer

    */

   protected void initializePanel()

   {

      setLayout(new BorderLayout());

      add(createPanel(), BorderLayout.CENTER);

   }

}

package org.gvsig.oracle;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import org.gvsig.andami.IconThemeHelper;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.fmap.mapcontext.MapContextLocator;

import org.gvsig.fmap.mapcontext.MapContextManager;

import org.gvsig.tools.ToolsLocator;

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

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

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

import org.gvsig.webbrowser.WebBrowserPanel;

import org.gvsig.webbrowser.WebBrowserFactory;

public class OracleExtension extends Extension {

    @Override

    public void initialize() {

    }

    @Override

    public boolean canQueryByAction() {

        return true;

    }

    @Override

    public void postInitialize() {

        MapContextManager mapContextMgr = MapContextLocator.getMapContextManager();

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

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

    }

    @Override

    public void execute(String actionCommand) {

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

            startbrowser();

            return;

        }

    }

    @Override

    public boolean isEnabled() {

        return true;

    }

    @Override

    public boolean isVisible() {

        return true;

    }

    @Override

    public boolean isEnabled(String action) {

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

            return true;

        } 

        return false;

    }

    @Override

    public boolean isVisible(String action) {

        return true;

    }

    private void startbrowser() {

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

        final HostPortPanelView panel = new HostPortPanelView();

        final Dialog dlg = winmanager.createDialog(

            panel,

            "Oracle Server",

            null, 

            WindowManager_v2.BUTTONS_OK_CANCEL

        );

        dlg.addActionListener(new ActionListener() {

            @Override

            public void actionPerformed(ActionEvent e) {

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

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

                    WebBrowserPanel webbrowser = WebBrowserFactory.createWebBrowserPanel();

                    winmanager.showWindow(

                        webbrowser.asJComponent(), 

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

                        WindowManager_v2.MODE.WINDOW

                    );

                    webbrowser.setPage(url);

                }

            }

        });

        dlg.show(WindowManager_v2.MODE.WINDOW);

    }

}

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

<?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.9</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.9</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.224</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.9</connection>

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

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

    </plugins>

  </build>

  <dependencyManagement>

      <dependencies>

          <dependency>

            <groupId>org.gvsig</groupId>

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

            <version>2.0.9</version>

          </dependency>

          <dependency>

            <groupId>org.gvsig</groupId>

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

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

<?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="port" type="integer" mandatory="false"

          defaultValue="1521" group="Connection">

          <description></description>

        </field>

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

            defaultValue="127.0.0.1" group="Connection">

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

package org.gvsig.oracle.dal;

import java.util.HashMap;

import java.util.Map;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.GeometryLocator;

import org.gvsig.fmap.geom.GeometryManager;

import org.gvsig.fmap.geom.type.GeometryType;

public class GeometryTypeUtils {

    private static final int ORACLE_UNKNOWN_GEOMETRY = 0;

    private static final int ORACLE_POINT = 1;

    private static final int ORACLE_LINE_OR_CURVE = 2;

    private static final int ORACLE_POLYGON = 3;

    private static final int ORACLE_COLLECTION = 4;

    private static final int ORACLE_MULTIPOINT = 5;

    private static final int ORACLE_MULTILINE_OR_MULTICURVE = 6;

    private static final int ORACLE_MULTIPOLYGON = 7;

    private static final int ORACLE_SOLID = 8;

    private static final int ORACLE_MULTISOLID = 9;

    public static final int SFS_GEOMETRY = 0;

	public static final int SFS_POINT = 1;

	public static final int SFS_LINE = 2;

	public static final int SFS_POLYGON = 3;

	public static final int SFS_MULTIPOINT = 4;

	public static final int SFS_MULTILINE = 5;

	public static final int SFS_MULTIPOLYGON = 6;

	public static final int SFS_GEOMCOLLECTION = 7;

	public static final int SFS_CURVE = 13;

	public static final int SFS_SURFACE = 14;

	public static final int SFS_POLYHEDRALSURFACE = 15;

	public static final int SFS_2D_THOUSANDS = 0;

	public static final int SFS_3D_THOUSANDS = 1;

	public static final int SFS_2DM_THOUSANDS = 2;

	public static final int SFS_3DM_THOUSANDS = 3;

    private static Map<String,GeometryType>databaseGeometryTypes = null;

    private static GeometryType getGT(

            GeometryManager manager, 

            int type, 

            int subtype

        ) {

        try {

            return manager.getGeometryType(type, subtype);

        } catch (Exception ex) {

            return null;

        }

    }

	public static GeometryType getGeometryTypeFromDatabaseTypeName(String typeName) {

        if( databaseGeometryTypes==null ) {

            GeometryManager manager = GeometryLocator.getGeometryManager();

            databaseGeometryTypes = new HashMap<>();

            databaseGeometryTypes.put("POINT", getGT(manager, Geometry.TYPES.POINT,Geometry.SUBTYPES.GEOM2D));

            databaseGeometryTypes.put("POINTZ", getGT(manager, Geometry.TYPES.POINT,Geometry.SUBTYPES.GEOM3D));

            databaseGeometryTypes.put("POINTM", getGT(manager, Geometry.TYPES.POINT,Geometry.SUBTYPES.GEOM2DM));

            databaseGeometryTypes.put("POINTZM", getGT(manager, Geometry.TYPES.POINT,Geometry.SUBTYPES.GEOM3DM));

            databaseGeometryTypes.put("LINESTRING", getGT(manager, Geometry.TYPES.LINE,Geometry.SUBTYPES.GEOM2D));

            databaseGeometryTypes.put("LINESTRINGZ", getGT(manager, Geometry.TYPES.LINE,Geometry.SUBTYPES.GEOM3D));

            databaseGeometryTypes.put("LINESTRINGM", getGT(manager, Geometry.TYPES.LINE,Geometry.SUBTYPES.GEOM2DM));

            databaseGeometryTypes.put("LINESTRINGZM", getGT(manager, Geometry.TYPES.LINE,Geometry.SUBTYPES.GEOM3DM));

            databaseGeometryTypes.put("POLYGON", getGT(manager, Geometry.TYPES.POLYGON,Geometry.SUBTYPES.GEOM2D));

            databaseGeometryTypes.put("POLYGONZ", getGT(manager, Geometry.TYPES.POLYGON,Geometry.SUBTYPES.GEOM3D));

            databaseGeometryTypes.put("POLYGONM", getGT(manager, Geometry.TYPES.POLYGON,Geometry.SUBTYPES.GEOM2DM));

            databaseGeometryTypes.put("POLYGONZM", getGT(manager, Geometry.TYPES.POLYGON,Geometry.SUBTYPES.GEOM3DM));

            databaseGeometryTypes.put("MULTIPOINT", getGT(manager, Geometry.TYPES.MULTIPOINT,Geometry.SUBTYPES.GEOM2D));

            databaseGeometryTypes.put("MULTIPOINTZ", getGT(manager, Geometry.TYPES.MULTIPOINT,Geometry.SUBTYPES.GEOM3D));

            databaseGeometryTypes.put("MULTIPOINTM", getGT(manager, Geometry.TYPES.MULTIPOINT,Geometry.SUBTYPES.GEOM2DM));

            databaseGeometryTypes.put("MULTIPOINTZM", getGT(manager, Geometry.TYPES.MULTIPOINT,Geometry.SUBTYPES.GEOM3DM));

            databaseGeometryTypes.put("MULTILINESTRING", getGT(manager, Geometry.TYPES.MULTILINE,Geometry.SUBTYPES.GEOM2D));

            databaseGeometryTypes.put("MULTILINESTRINGZ", getGT(manager, Geometry.TYPES.MULTILINE,Geometry.SUBTYPES.GEOM3D));

            databaseGeometryTypes.put("MULTILINESTRINGM", getGT(manager, Geometry.TYPES.MULTILINE,Geometry.SUBTYPES.GEOM2DM));

            databaseGeometryTypes.put("MULTILINESTRINGZM", getGT(manager, Geometry.TYPES.MULTILINE,Geometry.SUBTYPES.GEOM3DM));

            databaseGeometryTypes.put("MULTIPOLYGON", getGT(manager, Geometry.TYPES.MULTIPOLYGON,Geometry.SUBTYPES.GEOM2D));

            databaseGeometryTypes.put("MULTIPOLYGONZ", getGT(manager, Geometry.TYPES.MULTIPOLYGON,Geometry.SUBTYPES.GEOM3D));

            databaseGeometryTypes.put("MULTIPOLYGONM", getGT(manager, Geometry.TYPES.MULTIPOLYGON,Geometry.SUBTYPES.GEOM2DM));

            databaseGeometryTypes.put("MULTIPOLYGONZM", getGT(manager, Geometry.TYPES.MULTIPOLYGON,Geometry.SUBTYPES.GEOM3DM));

            databaseGeometryTypes.put("GEOMETRY", getGT(manager, Geometry.TYPES.GEOMETRY,Geometry.SUBTYPES.GEOM2D));

            databaseGeometryTypes.put("GEOMETRYZ", getGT(manager, Geometry.TYPES.GEOMETRY,Geometry.SUBTYPES.GEOM3D));

            databaseGeometryTypes.put("GEOMETRYM", getGT(manager, Geometry.TYPES.GEOMETRY,Geometry.SUBTYPES.GEOM2DM));

            databaseGeometryTypes.put("GEOMETRYZM", getGT(manager, Geometry.TYPES.GEOMETRY,Geometry.SUBTYPES.GEOM3DM));

        }

        return databaseGeometryTypes.get(typeName);

    }

	public static int getSubType(int numDimensions) {

		return getSubType(numDimensions, 0);

	}

	public static int getSubType(int numDimensions, int mDimPos) {

    	if (numDimensions==2) {

    		return Geometry.SUBTYPES.GEOM2D;

    	}

		if (numDimensions==3) {

			if (mDimPos>0) {

				return Geometry.SUBTYPES.GEOM2DM;

			}

			else {

				return Geometry.SUBTYPES.GEOM3D;

			}

		}

		else if (numDimensions==4) {

			return Geometry.SUBTYPES.GEOM3DM;

		}

		else {

			return Geometry.SUBTYPES.UNKNOWN;

		}

	}

    public static GeometryType getGeometryTypeFromDatabaseTypeNumber(int typeCode) {

    	int dimensions = typeCode/1000;

    	int typeCodeRemainder = typeCode - 1000*dimensions;

    	int mDimPos = typeCodeRemainder/100;

    	int geomType = typeCodeRemainder - 100*mDimPos;

    	int gvsigType, gvsigSubtype;

    	// type

    	switch(geomType) {

    	case ORACLE_POINT:

    		gvsigType = Geometry.TYPES.POINT;

    		break;

    	case ORACLE_LINE_OR_CURVE: //FIXME: shoud we return CURVE?

    		gvsigType = Geometry.TYPES.LINE;

    		break;

    	case ORACLE_POLYGON:

    		gvsigType = Geometry.TYPES.POLYGON;

    		break;

    	case ORACLE_MULTIPOINT:

    		gvsigType = Geometry.TYPES.MULTIPOINT;

    		break;

    	case ORACLE_MULTILINE_OR_MULTICURVE: //FIMXE: should we return MULTICURVE?

    		gvsigType = Geometry.TYPES.MULTILINE;

    		break;

    	case ORACLE_MULTIPOLYGON:

    		gvsigType = Geometry.TYPES.MULTIPOLYGON;

    		break;

    	default:

    		gvsigType = Geometry.TYPES.GEOMETRY;

    		break;

    	}

		gvsigSubtype = GeometryTypeUtils.getSubType(dimensions, mDimPos);

    	GeometryManager manager = GeometryLocator.getGeometryManager();

    	return GeometryTypeUtils.getGT(manager, gvsigType, gvsigSubtype);

    }

    public static GeometryType getGeometryTypeFromOracleName(String geomType, int dimensions) {

    	String geomTypeWKT;

    	geomType = geomType.toUpperCase();

    	if ("POINT".equals((geomType))) {

    		geomTypeWKT = "POINT";

    	}

    	else if ("LINE".equals(geomType) || "CURVE".equals(geomType)) {

    		geomTypeWKT = "LINESTRING";

    	}

    	else if ("POLYGON".equals(geomType) || "SURFACE".equals(geomType)) {

    		geomTypeWKT = "POLYGON";

    	}

    	else if ("MULTIPOINT".equals(geomType)) {

    		geomTypeWKT = "MULTIPOINT";

    	}

    	else if ("MULTILINE".equals(geomType) || "MULTICURVE".equals(geomType)) {

    		geomTypeWKT = "MULTILINESTRING";

    	}

    	else if ("MULTIPOLYGON".equals(geomType) || "MULTISURFACE".equals(geomType)) {

    		geomTypeWKT = "MULTIPOLYGON";

    	}

    	else {

    		geomTypeWKT = "GEOMETRY";

    	}

    	if (dimensions==3) {

    		geomTypeWKT = geomTypeWKT + "Z";

    	}

    	if (dimensions==4) {

    		geomTypeWKT = geomTypeWKT + "ZM";

    	}

    	return getGeometryTypeFromDatabaseTypeName(geomTypeWKT);

    }

    /**

     * Converts gvSIG geometry type to Oracle type name

     * @param gvsigType One of Geometry.Type

     * @return

     */

    public static String toOracleGeometryTypeName(int gvsigType) {

    	switch (gvsigType) {

    	case Geometry.TYPES.POINT:

    		return "POINT";

    	case Geometry.TYPES.MULTIPOINT:

    		return "MULTIPOINT";

    	case Geometry.TYPES.ARC:

    	case Geometry.TYPES.CURVE:

    		return "CURVE";

    	case Geometry.TYPES.LINE:

    		return "LINE";

    	case Geometry.TYPES.MULTILINE:

    		return "MULTILINE";

    	case Geometry.TYPES.MULTICURVE:

    		return "MULTICURVE";

    	case Geometry.TYPES.POLYGON:

    		return "POLYGON";

    	case Geometry.TYPES.SURFACE:

    		return "SURFACE";

    	case Geometry.TYPES.MULTIPOLYGON:

    		return "MULTISURFACE";

    	case Geometry.TYPES.MULTISURFACE:

    		return "MULTIPOLYGON";

    	default:

    		return "DEFAULT";

    	}

    }

    /**

     * Converts gvSIG geometry type and subtype codes to

     * OGC SFS SQL 1.2.1 numeric codes

     * 

     * @param typeCode

     * @return

     */

    public static int toSFSGeometryTypeCode(int type, int subtype) {

    	int sfsType;

    	switch (type) {

    	case Geometry.TYPES.POINT:

    		sfsType = SFS_POINT;

    		break;

    	case Geometry.TYPES.MULTIPOINT:

    		sfsType = SFS_MULTIPOINT;

    		break;

    	case Geometry.TYPES.ARC:

    	case Geometry.TYPES.CURVE:

    		sfsType = SFS_CURVE;

    		break;

    	case Geometry.TYPES.LINE:

    		sfsType = SFS_LINE;

    		break;

    	case Geometry.TYPES.MULTILINE:

    		sfsType = SFS_MULTILINE;

    		break;

    	case Geometry.TYPES.POLYGON:

    		sfsType = SFS_POLYGON;

    		break;

    	case Geometry.TYPES.SURFACE:

    		sfsType = SFS_SURFACE;

    		break;

    	case Geometry.TYPES.MULTIPOLYGON:

    		sfsType = SFS_MULTIPOLYGON;

    		break;

    	case Geometry.TYPES.MULTISURFACE:

    	case Geometry.TYPES.MULTICURVE:

    	default:

    		sfsType = SFS_GEOMETRY;

    	}

    	switch (type) {

    	case Geometry.SUBTYPES.GEOM3D:

    		sfsType += 1000;

    		break;

    	case Geometry.SUBTYPES.GEOM2DM:

    		sfsType += 2000;

    		break;

    	case Geometry.SUBTYPES.GEOM3DM:

    		sfsType += 3000;

    		break;

    	}

    	return sfsType;

    }

    public static GeometryType getGeometryTypeFromSFSTypeCode(int sfsCode){

    	int dimensionCode = sfsCode/1000;

    	int sfsBaseType = sfsCode - 1000*dimensionCode;

    	int gvsigType, gvsigSubtype;

    	switch (sfsBaseType) {

    	case SFS_POINT:

    		gvsigType = Geometry.TYPES.POINT;

    		break;

    	case SFS_LINE:

    		gvsigType = Geometry.TYPES.LINE;

    		break;

    	case SFS_POLYGON:

    		gvsigType = Geometry.TYPES.POLYGON;

    		break;

    	case SFS_MULTIPOINT:

    		gvsigType = Geometry.TYPES.MULTIPOINT;

    		break;

    	case SFS_MULTILINE:

    		gvsigType = Geometry.TYPES.MULTILINE;

    		break;

    	case SFS_MULTIPOLYGON:

    		gvsigType = Geometry.TYPES.MULTIPOLYGON;

    		break;

    	case SFS_CURVE:

    		gvsigType = Geometry.TYPES.CURVE;

    		break;

    	case SFS_SURFACE:

    		gvsigType = Geometry.TYPES.SURFACE;

    		break;

    	default:

    		gvsigType = Geometry.TYPES.GEOMETRY;

    			break;

    	}

    	switch (dimensionCode) {

    	case SFS_2D_THOUSANDS:

    		gvsigSubtype = Geometry.SUBTYPES.GEOM2D;

    	case SFS_3D_THOUSANDS:

    		gvsigSubtype = Geometry.SUBTYPES.GEOM3D;

    		break;

    	case SFS_2DM_THOUSANDS:

    		gvsigSubtype = Geometry.SUBTYPES.GEOM2DM;

    		break;

    	case SFS_3DM_THOUSANDS:

    		gvsigSubtype = Geometry.SUBTYPES.GEOM3DM;

    	default:

    		gvsigSubtype = Geometry.SUBTYPES.UNKNOWN;

    	}

    	GeometryManager manager = GeometryLocator.getGeometryManager();

    	return GeometryTypeUtils.getGT(manager, gvsigType, gvsigSubtype);

    }

}

package org.gvsig.oracle.dal;

import org.gvsig.fmap.dal.DataServerExplorerParameters;

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

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

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

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

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

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

import org.gvsig.fmap.dal.store.jdbc2.impl.JDBCServerExplorerFactory;

public class OracleExplorerFactory extends JDBCServerExplorerFactory {

    public OracleExplorerFactory() {

        super(

                OracleLibrary.NAME,

                OracleLibrary.NAME + " Server"

        );

    }

    @Override

    public JDBCServerExplorer create(

            DataServerExplorerParameters parameters, 

            DataServerExplorerProviderServices providerServices

        ) throws InitializeException {

        JDBCHelper helper = new OracleHelper((JDBCConnectionParameters) parameters);

        JDBCServerExplorer server = helper.createServerExplorer(

                (JDBCServerExplorerParameters) parameters, 

                providerServices

        );

        return server;

    }

    @Override

    public JDBCServerExplorerParameters createParameters() {

        JDBCServerExplorerParameters params = new OracleExplorerParameters();

        return params;    

    }

}

/* gvSIG. Geographic Information System of the Valencian Government

 *

 * Copyright (C) 2007-2008 Infrastructures and Transports Department

 * of the Valencian Government (CIT)

 *

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

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

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

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

 *

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

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

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

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

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

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

 * MA  02110-1301, USA.

 *

 */

package org.gvsig.oracle.dal;

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

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

public class OracleNewStoreParameters 

    extends 

        JDBCNewStoreParameters 

    implements 

        OracleConnectionParameters 

    {

    private final OracleConnectionParametersHelper helper;

    public OracleNewStoreParameters() {

        super(

            OracleLibrary.NAME + "NewStoreParameters", 

            OracleLibrary.NAME

        );

        this.helper = new OracleConnectionParametersHelper(this);

    }

    @Override

    public String getUrl() {

        return this.helper.getUrl();

    }

    @Override

    public void validate() throws ValidateDataParametersException {

        this.helper.validate();

    }

}

package org.gvsig.oracle.dal.operations;

import java.util.Iterator;

import java.util.List;

import org.cresques.cts.IProjection;

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

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

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

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

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

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

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

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

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

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

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

public class OracleOperationsFactory extends OperationsFactoryBase {

    public OracleOperationsFactory(JDBCHelper helper) {

        super(helper);

    }

    @Override

    public FetchFeatureTypeOperation createFetchFeatureType(EditableFeatureType type, String database, String schema, String table, List<String> primaryKeys, String defaultGeometryField, IProjection crs) {

        return new OracleFetchFeatureTypeOperation(

                helper, type, database, schema, table, primaryKeys, 

                defaultGeometryField, crs

        );

    }

    @Override

    public CanModifyTableOperation createCanModifyTableOperation(

            String dbName,

            String schemaName, 

            String tableName

        ) {

        return new OracleCanModifyTableOperation(helper, dbName, schemaName, tableName);

    }

    @Override

    public ListTablesOperation createListTables(

            int mode,