<HTML><HEAD><TITLE>Re: [Gvsig_english] joining two geometries or more from oracle</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17098" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText75101>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello,</FONT></DIV>
<DIV>I have not checked but I think this is what is happening:</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>If you use 2D geometries you should not face this problem again. We'll fix this issue in gvSIG 1.12</DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV></DIV>
<DIV id=idSignature39163>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Toni Pignataro<BR><B>Enviado el:</B> jue 30/06/2011 15:19<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] joining two geometries or more from oracle<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Hello all and thanks for your suggestions.<BR><BR>I could not find any CREATE TABLE statement in my log file. I know<BR>attached the log file to this email.<BR><BR>What I could find out of the log is also the error<BR>'ORA-13364: layer dimensionality does not match geometry dimensions'<BR><BR>What does this mean?<BR><BR>Regards,<BR>Toni P.<BR><BR><BR><BR>Am 30.06.2011 12:03, schrieb Juan Lucas Dominguez Rubio:<BR>> Hello,<BR>> Sorry, I didn't know the "Geometry - join" menu item in editing mode<BR>> (should be called "merge" I think).<BR>> I have tested it and works fine in an Oracle Spatial layer, so probably<BR>> Frank is right: check the SQL statement that created that table (CREATE<BR>> TABLE...) and its restrictions to see if something went wrong regarding<BR>> the alphanumeric attributes.<BR>> Regards,<BR>> Juan Lucas Domínguez Rubio<BR>> ---<BR>> Prodevelop SL, Valencia (España)<BR>> Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR>> <A href="http://www.prodevelop.es/">http://www.prodevelop.es</A> <<A href="http://www.prodevelop.es/">http://www.prodevelop.es/</A>><BR>> ---<BR>><BR>> ------------------------------------------------------------------------<BR>> *De:* gvsig_internacional-bounces@listserv.gva.es en nombre de Toni<BR>> Pignataro<BR>> *Enviado el:* mié 29/06/2011 17:40<BR>> *Para:* gvsig_internacional@listserv.gva.es<BR>> *Asunto:* [Gvsig_english] joining two geometries or more from oracle<BR>><BR>> Hello all,<BR>><BR>> when joining two geometries from an oracle database (polygon-layer) and<BR>> stop editing for saving my results i got the error<BR>> 'java.lang.IllegalStateException: Can't overwrite cause'.<BR>> Is this an know issu? Donig the same operation with a shape file works fine.<BR>><BR>> Thanks for any suggestions and regards,<BR>> Toni P.<BR>> _______________________________________________<BR>> Gvsig_internacional mailing list<BR>> Gvsig_internacional@listserv.gva.es<BR>> <A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR>><BR>><BR>><BR>> _______________________________________________<BR>> Gvsig_internacional mailing list<BR>> Gvsig_internacional@listserv.gva.es<BR>> <A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR><BR><BR></FONT></P></DIV></BODY></HTML>