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" 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"
xmlns:gml="http://www.opengis.net/gml" xmlns:ogc="http://www.opengis.net/ogc" xmlns="http://www.opengis.net/wfs"
xsi:schemaLocation="http://www.opengis.net/wfs ../wfs/1.0.0/WFS-basic.xsd" xmlns:sf="http://www.openplans.org/spearfish"
xmlns:topp="http://www.openplans.org/topp" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<wfs:Insert xmlns:wfs="http://www.opengis.net/wfs">
<topp:CB_CONS_TEST xmlns:topp="http://www.openplans.org/topp">
<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" xmlns:ogc="http://www.opengis.net/ogc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/wfs http://chbates-w3:8080/geoserver/schemas/wfs/1.0.0/WFS-transaction.xsd">
<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