Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[udig-users] Oracle Spatial, Editing, SRIDs and Submit Log

Folks, 

New to uDig. Downloaded and installed last week. Version 1.1.0 on Windows XP
against Oracle 10.2.0.2. 

I create a connection, add a layer with Oracle SRID 28356. I set the map's
projection to the same and make sure the layer's SRID is the same. 

All looks OK. 

I then use the "Hole Cutter" to add a hole to a polygon (or move a vertex,
it doesn't matter) and press the COmmit button on the toolbar. Visibly the
edits disappear and the geometry returns to the original. 

Checking the Submit Log (is there a way to CLEAR this log?) I get: 

org.geotools.data.DataSourceException: SQL Exception writing geometry column 
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine 
ORA-13365: layer SRID does not match geometry SRID 
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 243 

I have double checked. The map and the layer have the following uDIG SRID at
the time of edit and commit: 

"GDA94 / MGA zone 56 (EPSG:28356)" 

and the Oracle database tabe sdo_geometry sdo_srid is also 28356. 

Any ideas? 

regards 
Simon
-- 
View this message in context: http://n2.nabble.com/Oracle-Spatial%2C-Editing%2C-SRIDs-and-Submit-Log-tp2723187p2723187.html
Sent from the udig-users mailing list archive at Nabble.com.



Back to the top