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
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
