GeoServer
  1. GeoServer
  2. GEOS-182

Uable to WFS Insert into Oracle DataStore

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.2.3
    • Component/s: Oracle
    • Labels:
      None
    • Environment:
      Java: 1.4.2_03
      GeoServer: 1.2.0-rc1
      Operating System: Windows XP Professional
      Web Server: Jakarta Tomcat 4.1.30
      Database: Oracle 9.2.0.4
    • Number of attachments :
      0

      Description

      In GeoServer release 1.2.0-rc1. Was unable to perform a WFS insert into an Oracle Spatial datastore. GetCapabilties, DescribeFeatureType, GetFeature and Update Transaction all work okay.

      Error Message displayed in the console is:

      110676 [WARNING] org.vfny.geoserver.servlets.AbstractService - service exception while executing request: org.geotools.data.DataSourceException: Row adding failed.

      In order to duplicate, the other environment set-up is as follows:

      Spatial Table Creation Script

      CREATE TABLE TEST_WFS
      (
      ID NUMBER NOT NULL,
      NAME VARCHAR2(100 BYTE) NOT NULL,
      EXTENT MDSYS.SDO_GEOMETRY,
      DESCRIPTION VARCHAR2(1000 BYTE)
      );

      CREATE UNIQUE INDEX TEST_WFS_PK ON TEST_WFS(ID);

      ALTER TABLE TEST_WFS ADD (
      CONSTRAINT TEST_WFS_PK PRIMARY KEY (ID));

      SDO Metadata Entry

      INSERT INTO USER_SDO_GEOM_METADATA
      (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
      VALUES('TEST_WFS' , 'EXTENT',
      MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT
      ('longitude', -180, 180, 0.000005),
      MDSYS.SDO_DIM_ELEMENT
      ('latitude', -90, 90, 0.000005)),
      8307);

      WFS Insert Transaction

      <?xml version="1.0" encoding="ISO-8859-1"?>
      <Transaction version="1.0.0"
      service="WFS"
      xmlns:topp="http://www.openplans.org/topp"
      xmlns:gml="http://www.opengis.net/gml">
      <Insert handle="test1">
      <topp:TEST_WFS>
      <NAME>Pacific</NAME>
      <EXTENT>
      <gml:Point srsName="EPSG:4326">
      <gml:coordinates>-65.678,46.876</gml:coordinates>
      </gml:Point>
      </EXTENT>
      <DESCRIPTION>Addititonal insert</DESCRIPTION>
      </topp:TEST_WFS>
      </Insert>
      </Transaction>

        Activity

        Hide
        Sean Geoghegan added a comment -

        Can you enable more detailed logging and then attach the Tomcat log files please.

        Show
        Sean Geoghegan added a comment - Can you enable more detailed logging and then attach the Tomcat log files please.

          People

          • Assignee:
            Chris Holmes
            Reporter:
            Ian Ives
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: