[Gvsig_english] RE Error loading a big oracle spatial layer

[Juan Lucas Dominguez Rubio]

Hello, Wolfgang:
 
The JAR file I sent you yesterday was not describing geometries properly. Please download this new JAR file and repeat the test:
 
http://www.prodevelop.es/files/fm/public/downloads/oracle_test_jar_2.zip
 
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: Juan Lucas Dominguez Rubio
Enviado el: jue 22/04/2010 18:25
Para: Users and Developers mailing list
Asunto: RE: RE Error loading a big oracle spatial layer


Hello, Wolfgang:
 
The structure of those geometries is not valid in my database (assuming I printed it correctly in the log file). It's strange because Oracle generally prevents illegal geometries from being inserted. I hope the SDO_GEOMETRY format has not changed in recent Oracle Spatial versions.
 
How were those geometries inserted? Using SQL directly? Perhaps those geometries were inserted before creating the spatial index in that table? There is a suspicious detail: 31468 is not the right SRID value in your database. The German EPSG:31468 corresponds to Oracle Spatial SRID 82032.
 
Please try this SQL in your database and tell me the result. Does it return TRUE, FALSE or a number?
 
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
 
 
 
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: Wolfgang Qual [mailto:wolfgang.qual at muenchen.de]
Enviado el: jue 22/04/2010 13:59
Para: Juan Lucas Dominguez Rubio; Users and Developers mailing list
Asunto: RE Error loading a big oracle spatial layer



Dear Juan Lucas,
please find enclosed the requested logfile. Hope that helps to find the
bug... ;)

Best,
Wolfgang

--
Wolfgang Qual

Landeshauptstadt München
Referat für Gesundheit und Umwelt
Umweltschutz, Umweltvorsorge
RGU-UW 11
Team Klimaschutz, Energie

Bayerstraße 28a
80335 München

Telefon:  +49 - 89 - 233 - 4 77 17
Telefax:  +49 - 89 - 233 - 4 77 05
E-Mail:   wolfgang.qual at muenchen.de
Internet: http://www.muenchen.de/rgu

Bitte beachten Sie die Hinweise zur elektronischen
Kommunikation mit der Landeshauptstadt München:
http://www.muenchen.de/ekomm



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