[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [udig-users] Oracle Spatial, Editing, SRIDs and Submit Log
|
Looks like an honest bug report; I am tempted to ask you to check out
the current development branch.
New oracle datastore support is in the development line (based on
prepared statements) so we get a new set of bugs.
Jody
On Mon, Apr 27, 2009 at 6:13 PM, Simon Greener
<simon@xxxxxxxxxxxxxxxxxxxx> wrote:
>
> 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.
>
> _______________________________________________
> udig-users mailing list
> udig-users@xxxxxxxxxxxxxxxxxxxxx
> http://lists.refractions.net/mailman/listinfo/udig-users
>
