Re: [udig-users] Oracle Spatial, Editing, SRIDs and Submit Log

["Simon Greener" <simon@xxxxxxxxxxxxxxxxxxxx>]

Jody,

Whilst I am willing to help you confirm that this is a bug, I am not set up for compiling a development branch of uDig and so can only work with an installable exe.

Is there any way I can see the SDO_Geometry that is being written back to the database? If there was I would need to see what value was being assigned to the SDO_SRID field in the geometry. Perhaps I migt have a muck about with logging what the Listener is doing.

regards
Simon

On Tue, 28 Apr 2009 18:55:57 +1000, Jody Garnett <jody.garnett@xxxxxxxxx> wrote:

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



-- 
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
  Email: simon@xxxxxxxxxxxxxxxxxxxx
  Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
NAC:W80CK 7SWP3