<HTML><HEAD><TITLE>Re: [Gvsig_english] RE Error loading a big oracle spatial layer</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17023" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText13120>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Kormel.</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Thanks for the test. The response "13032" means that the geometry is invalid and 13032 is the error code, but the geometry contained in that SQL is NOT the geometry Wolfgang has in his table. My test JAR was not well done, so the SQL I prepared is useless.</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>I have sent a new JAR file (previous message), and now I have to read the log file again (when Wolfgang sends it) to find out what is happening.</FONT></DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV></DIV>
<DIV id=idSignature46935>
<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 K.Kiss<BR><B>Enviado el:</B> vie 23/04/2010 9:37<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] RE Error loading a big oracle spatial layer<BR></FONT><BR></DIV>
<DIV><BR>
<P><FONT size=2>Hello Juan Lucas and Wolfgang,<BR><BR>the request is working:<BR><BR>select sdo_geom.validate_geometry_with_context(sdo_geometry(3005, 31468,<BR>NULL, sdo_elem_info_array(1.0 , 2005.0 , 1.0 , 1.0 , 2.0 , 2.0),<BR>sdo_ordinate_array(4478106.584 , 5345524.3355 , 0.0 , 4478103.55781412 ,<BR>5345520.13869913 , 0.0 , 4478094.627 , 5345517.0485 , 0.0 , 4478088.31210806<BR>, 5345521.30429374 , 0.0 , 4478087.661 , 5345528.8915 , 0.0 ,<BR>4478093.20816592 , 5345537.22495391 , 0.0 , 4478103.219 , 5345537.2515 , 0.0<BR>, 4478107.61580098 , 5345529.07024585 , 0.0 , 4478107.585 , 5345528.688 ,<BR>0.0 , 4478107.28586386 , 5345526.46542887 , 0.0 , 4478106.584 , 5345524.3355<BR>, 0.0)), 0.0005) from dual<BR><BR><BR>the resonse from Oracle10:<BR>SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(SDO_GEOMETRY(3005,31468,NULL,SDO_ELEM_IN<BR>--------------------------------------------------------------------------------<BR>13032 <BR><BR>1 row selected.<BR><BR>I´ve tested 2 servers (info for wolfgang "t_rgu" and "umsys" in the RGU)<BR>the same response.<BR><BR>Regards<BR>Kornel<BR><BR>--<BR>View this message in context: <A href="http://osgeo-org.1803224.n2.nabble.com/RE-Error-loading-a-big-oracle-spatial-layer-tp4942341p4949117.html">http://osgeo-org.1803224.n2.nabble.com/RE-Error-loading-a-big-oracle-spatial-layer-tp4942341p4949117.html</A><BR>Sent from the gvSIG international mailing list archive at Nabble.com.<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></FONT></P></DIV></BODY></HTML>