[Geoserver-users] Antw: Inserting Features with WFS-T (INSERT) into Oracle

GeoServer GeoServer User
1

Hi Gregor,

--
Ronald Woita
http://geoportal.rostock.de
Hansestadt Rostock
Kataster-, Vermessungs- und Liegenschaftsamt
Holbeinplatz 14, 18069 Rostock
email: ronald.woita@anonymised.com
phone: +49 (0)381 - 381 6256

Gregor Fikoczek <gregor.fikoczek@anonymised.com> 08.08.2007 13:16 >>>

=> Filled the USER_SDO_GEOM_METADATA with SRID =4326
=> Created an Spatial Index with PARAMETERS ('SDO_INDX_DIMS=2
LAYER_GTYPE=POINT')
=> PrimaryKey on a NUMBER Column
ORA-13365: Layer-SRID does not correspond to the Geometry-SRID
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", line 210
ORA-06512: in line 1

the issue is that you fill the USER_SDO_GEOM_METADATA with SRID=4326.
GeoServer inserts SRID=NULL with the Geometry, so that LayerSRID does'nt correspond with GeometrySRID.
An example for a wfs:insert with GeoServer-1.5.2 (the first NULL is the value for SDO_SRID)
SDO_GEOMETRY(2007, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARR
AY(4505580, 5994620, 4505830, 5993590, 4506730, 5994500, 4506190, 5995160, 45055
80, 5994620))

regards

Ronald

2

Ronald Woita ha scritto:

Hi Gregor,

--
Ronald Woita
http://geoportal.rostock.de
Hansestadt Rostock
Kataster-, Vermessungs- und Liegenschaftsamt
Holbeinplatz 14, 18069 Rostock
email: ronald.woita@anonymised.com phone: +49 (0)381 - 381 6256

Gregor Fikoczek <gregor.fikoczek@anonymised.com> 08.08.2007 13:16 >>>

=> Filled the USER_SDO_GEOM_METADATA with SRID =4326
=> Created an Spatial Index with PARAMETERS ('SDO_INDX_DIMS=2 LAYER_GTYPE=POINT')
=> PrimaryKey on a NUMBER Column
ORA-13365: Layer-SRID does not correspond to the Geometry-SRID
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", line 210
ORA-06512: in line 1

the issue is that you fill the USER_SDO_GEOM_METADATA with SRID=4326.
GeoServer inserts SRID=NULL with the Geometry, so that LayerSRID does'nt correspond with GeometrySRID.
An example for a wfs:insert with GeoServer-1.5.2 (the first NULL is the value for SDO_SRID)
SDO_GEOMETRY(2007, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARR
AY(4505580, 5994620, 4505830, 5993590, 4506730, 5994500, 4506190, 5995160, 45055
80, 5994620))

Sorry? I thought I had this fixed in 1.5.2. If you specify the SRID in
the geom metadata, 1.5.2 should perform the insert without issues.
Gregor, can you try out 1.5.2 and report back?

Cheers
Andrea

3

Hi, Ronald, hi Andrea,

@Ronald: thxs for the information.

Andrea Aime schrieb:

Ronald Woita ha scritto:

Hi Gregor,

–
Ronald Woita
http://geoportal.rostock.de
Hansestadt Rostock
Kataster-, Vermessungs- und Liegenschaftsamt
Holbeinplatz 14, 18069 Rostock
email: ronald.woita@anonymised.com phone: +49 (0)381 - 381 6256

Gregor Fikoczek gregor.fikoczek@anonymised.com 08.08.2007 13:16 >>>

=> Filled the USER_SDO_GEOM_METADATA with SRID =4326
=> Created an Spatial Index with PARAMETERS (‘SDO_INDX_DIMS=2 LAYER_GTYPE=POINT’)
=> PrimaryKey on a NUMBER Column
ORA-13365: Layer-SRID does not correspond to the Geometry-SRID
ORA-06512: in “MDSYS.SDO_INDEX_METHOD_9I”, line 210
ORA-06512: in line 1

the issue is that you fill the USER_SDO_GEOM_METADATA with SRID=4326.
GeoServer inserts SRID=NULL with the Geometry, so that LayerSRID does’nt correspond with GeometrySRID.
An example for a wfs:insert with GeoServer-1.5.2 (the first NULL is the value for SDO_SRID)
SDO_GEOMETRY(2007, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARR
AY(4505580, 5994620, 4505830, 5993590, 4506730, 5994500, 4506190, 5995160, 45055
80, 5994620))

Sorry? I thought I had this fixed in 1.5.2. If you specify the SRID in
the geom metadata, 1.5.2 should perform the insert without issues.
Gregor, can you try out 1.5.2 and report back?

Cheers
Andrea

@Andrea: Thanks for the quick answer.
I tested the INSERT-Request with the new geoserver 1.5.2. and
…
…
…
it works :slight_smile: !!!
Well done :wink:

<wfs:WFS_TransactionResponse version=“1.0.0” xsi:schemaLocation=“http://www.opengis.net/wfs http://localhost:8080/geoserver/schemas/wfs/1.0.0/WFS-transaction.xsd”>
<wfs:InsertResult handle=“null TEST_POINT 1”>
<ogc:FeatureId fid=“TEST_POINT.3”/>
</wfs:InsertResult>
wfs:TransactionResult
wfs:Status
wfs:SUCCESS/
</wfs:Status>
</wfs:TransactionResult>
</wfs:WFS_TransactionResponse>

Regards,
Gregor

··· 
-- 

---------------------------------------
WhereGroup GmbH & Co. KG
Siemensstraße 8
53121 Bonn
-------------------------------
Fon: +49 (0)228 / 90 90 38 - 25
Fax: +49 (0)228 / 90 90 38 - 11
-------------------------------

Dipl. Ing. (FH) Gregor Fikoczek 

[mailto:gregor.fikoczek@anonymised.com](mailto:gregor.fikoczek@anonymised.com)
[mailto:info@anonymised.com](mailto:info@anonymised.com)
[http://www.wheregroup.com](http://www.wheregroup.com)
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRA 6788
---------------------------------------
4

Gregor Fikoczek ha scritto:

@Andrea: Thanks for the quick answer.
I tested the INSERT-Request with the new geoserver 1.5.2. and
...
it works :slight_smile: !!!
Well done :wink:

Good! :slight_smile:
Cheers
Andrea