<HTML><HEAD><TITLE>[Gvsig_english] new problems with an oracle layer</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17063" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText1639>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Wolfgang.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>I am assuming that your version of gvSIG is using this Java code:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="http://subversion.gvsig.org/gvSIG/tags/v1_9_Build_1253/">http://subversion.gvsig.org/gvSIG/tags/v1_9_Build_1253/</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>(maybe somebody from OA can confirm this)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>It's a strange error. According to your log file, there is a geometry in your Oracle Spatial table where the first metadata component (called SDO_GTYPE) is NULL, which is not listed as a valid value in Oracle Spatial documentation:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96630/sdo_objrelschema.htm#i1004087">http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96630/sdo_objrelschema.htm#i1004087</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>So the only explanation I have is that there is a corrupt geometry in that table.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>These are two attempts to identify the row that caused the problem:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>(1) Execute this SQL sentence (the table was PLAN.GRUEN_POLY, no?):</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>select * from PLAN.GRUEN_POLY t where t.SHAPE.SDO_GTYPE = NULL</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>If that SQL returns one or more rows, you must decide what toi do with it because its geometry is not valid.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>If that returns no row, try this:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>(2) Execute these SQL sentences:</FONT></DIV>
<DIV> </DIV>
<DIV>================</DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>CREATE TABLE validate_results(sdo_rowid ROWID, status VARCHAR2(2000));</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>BEGIN</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT('PLAN.GRUEN_POLY', 'SHAPE', 'validate_results');</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>END;</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>SELECT * FROM validate_results ORDER BY status;</FONT></DIV>
<DIV>
<DIV>================</DIV>
<DIV> </DIV></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>And check how many different values (numbers) you have in the 'status' column. Please write the codes and send them to the list.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Regards,</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature30437>
<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 Wolfgang Qual<BR><B>Enviado el:</B> jue 17/06/2010 14:51<BR><B>Para:</B> Users and Developers mailing list<BR><B>Asunto:</B> [Gvsig_english] new problems with an oracle layer<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Dear list,<BR><BR>I got an error message while saving an oracle spatial layer as<BR>shapefile. The process of writing the shapefile stopps at a certain<BR>moment and<BR>the error message appears. Logfile attached. I fear that it has to do<BR>with the layer itself, as other layers caused no problem. Nevertheless,<BR>I would be<BR>very happy to know the reason for this. Therefore: all comments are<BR>welcome! ;)<BR><BR>Best,<BR>Wolfgang<BR><BR>ps: gvsig OADE was used on a linux machine<BR><BR>--<BR>Wolfgang Qual<BR><BR>Landeshauptstadt München<BR>Referat für Gesundheit und Umwelt<BR>Umweltschutz, Umweltvorsorge<BR>RGU-UW 11<BR>Team Klimaschutz, Energie<BR><BR>Bayerstraße 28a<BR>80335 München<BR><BR>Telefon: +49 - 89 - 233 - 4 77 17<BR>Telefax: +49 - 89 - 233 - 4 77 05<BR>E-Mail: wolfgang.qual@muenchen.de<BR>Internet: <A href="http://www.muenchen.de/rgu">http://www.muenchen.de/rgu</A><BR><BR>Bitte beachten Sie die Hinweise zur elektronischen<BR>Kommunikation mit der Landeshauptstadt München:<BR><A href="http://www.muenchen.de/ekomm">http://www.muenchen.de/ekomm</A><BR><BR></FONT></P></DIV></BODY></HTML>