Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[udig-devel] [jira] Created: (UDIG-1509) Oracle DataStore does not supply SRID on update; resulting in exception writing geometry column

Oracle DataStore does not supply SRID on update; resulting in exception writing geometry column
-----------------------------------------------------------------------------------------------

                 Key: UDIG-1509
                 URL: http://jira.codehaus.org/browse/UDIG-1509
             Project: uDIG
          Issue Type: Bug
          Components: database
    Affects Versions: UDIG 1.1.1
            Reporter: This is Not Jody


>From Simon Greener via email:
{panel}
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.
{panel}

-- 
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

        


Back to the top