[Gvsig_english] RE Error loading a big oracle spatial layer

[Juan Lucas Dominguez Rubio]

Hello, Kormel.
 
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.
 
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.
 
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 K.Kiss
Enviado el: vie 23/04/2010 9:37
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] RE Error loading a big oracle spatial layer




Hello Juan Lucas and Wolfgang,

the request is working:

select sdo_geom.validate_geometry_with_context(sdo_geometry(3005, 31468,
NULL, sdo_elem_info_array(1.0 , 2005.0 , 1.0 , 1.0 , 2.0 , 2.0),
sdo_ordinate_array(4478106.584 , 5345524.3355 , 0.0 , 4478103.55781412 ,
5345520.13869913 , 0.0 , 4478094.627 , 5345517.0485 , 0.0 , 4478088.31210806
, 5345521.30429374 , 0.0 , 4478087.661 , 5345528.8915 , 0.0 ,
4478093.20816592 , 5345537.22495391 , 0.0 , 4478103.219 , 5345537.2515 , 0.0
, 4478107.61580098 , 5345529.07024585 , 0.0 , 4478107.585 , 5345528.688 ,
0.0 , 4478107.28586386 , 5345526.46542887 , 0.0 , 4478106.584 , 5345524.3355
, 0.0)), 0.0005) from dual


the resonse from Oracle10:
SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(SDO_GEOMETRY(3005,31468,NULL,SDO_ELEM_IN
--------------------------------------------------------------------------------
13032                                                                          

1 row selected.

I´ve tested 2 servers (info for wolfgang "t_rgu"   and "umsys" in the RGU)
the same response.

Regards
Kornel

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/RE-Error-loading-a-big-oracle-spatial-layer-tp4942341p4949117.html
Sent from the gvSIG international mailing list archive at Nabble.com.
_______________________________________________
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/20100423/d6a59294/attachment.htm