[Gvsig_english] joining two geometries or more from oracle

[Juan Lucas Dominguez Rubio]

Hello,
I have not checked but I think this is what is happening:
 
It seems like your Oracle Spatial table has 3D polygons. The join operation in converting them to a 2D polygon which the Oracle Spatial databse rejects to write in a 3D geometries table.
 
I thought the Oracle Spatial driver was already checking this and added z = 0 for any 2D geometry being written to a 3D table, but obviously this is not happening. This problem should be addressed by preserving the dimensions in the join operation.
 
If you use 2D geometries you should not face this problem again. We'll fix this issue in gvSIG 1.12
 
Regards,
 
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at listserv.gva.es en nombre de Toni Pignataro
Enviado el: jue 30/06/2011 15:19
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] joining two geometries or more from oracle



Hello all and thanks for your suggestions.

I could not find any CREATE TABLE statement in my log file. I know
attached the log file to this email.

What I could find out of the log is also the error
'ORA-13364: layer dimensionality does not match geometry dimensions'

What does this mean?

Regards,
Toni P.



Am 30.06.2011 12:03, schrieb Juan Lucas Dominguez Rubio:
> Hello,
> Sorry, I didn't know the "Geometry - join" menu item in editing mode
> (should be called "merge" I think).
> I have tested it and works fine in an Oracle Spatial layer, so probably
> Frank is right: check the SQL statement that created that table (CREATE
> TABLE...) and its restrictions to see if something went wrong regarding
> the alphanumeric attributes.
> Regards,
> Juan Lucas Domínguez Rubio
> ---
> Prodevelop SL, Valencia (España)
> Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
> http://www.prodevelop.es <http://www.prodevelop.es/>  <http://www.prodevelop.es/>
> ---
>
> ------------------------------------------------------------------------
> *De:* gvsig_internacional-bounces at listserv.gva.es en nombre de Toni
> Pignataro
> *Enviado el:* mié 29/06/2011 17:40
> *Para:* gvsig_internacional at listserv.gva.es
> *Asunto:* [Gvsig_english] joining two geometries or more from oracle
>
> Hello all,
>
> when joining two geometries from an oracle database (polygon-layer) and
> stop editing for saving my results i got the error
> 'java.lang.IllegalStateException: Can't overwrite cause'.
> Is this an know issu? Donig the same operation with a shape file works fine.
>
> Thanks for any suggestions and regards,
> Toni P.
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>
>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20110701/c67dda7d/attachment.htm