Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
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 :
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>
Can you enable more detailed logging and then attach the Tomcat log files please.