[Geoserver-devel] [jira] Created: (GEOS-1889) WFS-T / Oracle: can't insert a feature with attribute data only

WFS-T / Oracle: can't insert a feature with attribute data only
----------------------------------------------------------------

                 Key: GEOS-1889
                 URL: http://jira.codehaus.org/browse/GEOS-1889
             Project: GeoServer
          Issue Type: Bug
          Components: Oracle
    Affects Versions: 1.6.3
         Environment: GeoServer 1.6.3 running on WinXP. gt2-oracle-spatial-2.4.2.jar. Oracle 11g server.
            Reporter: Charles Bates
            Assignee: Andrea Aime

TransactionRequest:
<wfs:Transaction
version="1.0.0"
service="WFS"
xmlns:wfs="http://www.opengis.net/wfs&quot; xmlns:sde="http://geoserver.sf.net" xmlns:tiger="http://www.census.gov"
xmlns:it.geosolutions="http://www.geo-solutions.it" xmlns:nurc="http://www.nurc.nato.int" xmlns:cite="http://www.opengeospatial.net/cite&quot;
xmlns:gml="http://www.opengis.net/gml&quot; xmlns:ogc="http://www.opengis.net/ogc&quot; xmlns="http://www.opengis.net/wfs&quot;
xsi:schemaLocation="http://www.opengis.net/wfs ../wfs/1.0.0/WFS-basic.xsd" xmlns:sf="http://www.openplans.org/spearfish&quot;
xmlns:topp="http://www.openplans.org/topp&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
    <wfs:Insert xmlns:wfs="http://www.opengis.net/wfs&quot;&gt;
        <topp:CB_CONS_TEST xmlns:topp="http://www.openplans.org/topp&quot;&gt;
            <ID>5</ID>
            <NAME>E</NAME>
            <MI_STYLE></MI_STYLE>
        </topp:CB_CONS_TEST>
    </wfs:Insert>
</wfs:Transaction>

TransactionResponse:
<wfs:WFS_TransactionResponse version="1.0.0" xmlns:wfs="http://www.opengis.net/wfs&quot; xmlns:ogc="http://www.opengis.net/ogc&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xsi:schemaLocation="http://www.opengis.net/wfs http://chbates-w3:8080/geoserver/schemas/wfs/1.0.0/WFS-transaction.xsd&quot;&gt;
    <wfs:InsertResult>
        <ogc:FeatureId fid="none"/>
    </wfs:InsertResult>
    <wfs:TransactionResult>
        <wfs:Status>
            <wfs:FAILED/>
        </wfs:Status>
        <wfs:Message>Error performing insert</wfs:Message>
    </wfs:TransactionResult>
</wfs:WFS_TransactionResponse>

If the request has an object and attribute data, or only an object, it succeeds

Oracle table:
CREATE TABLE CB_CONS_TEST
(
  ID NUMBER(10),
  NAME VARCHAR2(64 BYTE),
  MI_STYLE VARCHAR2(254 BYTE),
  MI_PRINX NUMBER(10),
  GEOLOC
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
            INITIAL 64K
            MINEXTENTS 1
            MAXEXTENTS 2147483645
            PCTINCREASE 0
            BUFFER_POOL DEFAULT
           );

CREATE INDEX CB_CONS_TEST_SX ON CB_CONS_TEST
(GEOLOC)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;

ALTER TABLE CB_CONS_TEST ADD (
  PRIMARY KEY
(MI_PRINX)
    USING INDEX
    TABLESPACE USERS
    PCTFREE 10
    INITRANS 2
    MAXTRANS 255
    STORAGE (
                INITIAL 64K
                MINEXTENTS 1
                MAXEXTENTS 2147483645
                PCTINCREASE 0
               ));

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira