[Gvsig_english] new problems with an oracle layer

Mon Jun 21 18:03:00 CEST 2010

Hello, Kornel. Thanks for sending me that shapefile.

If you add that shapefile to gvSIG and export it to Oracle Spatial and then add the new table to the view, does it work? (it works for me)

Anyway, please do this test with the original table PLAN.GRUEN_POLY. If you are fed up with these tests, you can do it tomorrow or some other day and I'll take no offence:

http://www.prodevelop.es/files/fm/public/downloads/oracle_test_00.png

Add the table three times, using a different SQL filter each time:

c.SHAPE.SDO_GTYPE = 3003
c.SHAPE.SDO_GTYPE = 3007
ROWNUM < 500

which of those 3 filters work? You can increase the 500 if it works until it does not work.

It's also possible that you are having the same problem we discussed a few months ago:

http://listserv.gva.es/pipermail/gvsig_internacional/2010-April/005196.html

I  made some changes from then, but those changes have not been published in any official binaries yet, but I sent an informal JAR for test purposes. Are you using the official or the informal JAR? Which value are you using in the -Xmx parameter (in the gvsig.sh script)

The SQL with 3007 does not work because the list of coordinates is incomplete (you probably copy-pasted it from an application that was not showing the full coordinate list.). I don't think 3007 is the problem here.

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: lun 21/06/2010 13:54
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] new problems with an oracle layer

hello again,

Insert into GRUEN_POLY
   (OBJECTID,
    GE_CODE, TYP2, TYP3, GRUEN_GRUE, FLAECHE_HA,
    SHAPE, SE_ANNO_CAD_DATA, OGR_FID)
 Values
   (57, 1, 1, 1, 119264.494668,
    11.926449,
    "MDSYS"."SDO_GEOMETRY"(3007,31468,NULL,
    "MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1,193,2003,1),

"MDSYS"."SDO_ORDINATE_ARRAY"(4471575.00495711,5334345.4972686,0,4471600.50495291,5334341.99726918,0,4471805.00491925,5334312.99727395,0,4471782.50492295,5334238.99718613,0,4471774.50492427,5334193.49719362,0,4471779.50492344,5334191.99719387,0,4471786.50492229,5334235.99718663,0,4471809.5049185,5334310.99727428,0,4471813.50491785,5334311.4972742,0,4471826.50491571,5334332.99727066,0,4471988.00498912,5334308.99727461,0,4471985.00498961,5334286.49727831,0,4472054.50497817,5334276.49717996,0,4472058.50497751,5334275.99718004,0,4472067.00497611,5334274.49718029,0,4472227.50494969,5334251.99718399,0,4472215.50495167,5334128.99720424,0,4472225.0049501,5334124.49720498,0,4472372.0049259,5334102.49720861,0,4472373.00492574,5334108.99720753,0,4472389.50492302,5334106.49720795,0,4472394.5049222,5334108.99720753,0,4472395.50492203,5334111.49720712,0,4472394.5049222,5334125.99720474,0,4472236.00494829,5334148.49720103,0,4472251.00494582,5334266.49718161,0,4472249.00494615,5334278.99727955,0,4472252.50494557,5334299.99727609,0,4472259.0049445,5334313.49727387,0,4472277.50494146,5334328.4972714,0,4472301.50493751,5334333.99727049,0,4472354.00492886,5334327.49727156,0,4472422.00491767,5334318.49727304,0,4472428.00491668)),
NULL, 36)

Error at line 351
ORA-29875: Routine ODCIINDEXINSERT nicht erfolgreich ausgeführt
ORA-13034: Ungültige Daten in SDO_ORDINATE_ARRAY in Objekt SDO_GEOMETRY
ORA-06512: in "MDSYS.SDO_IDX", Zeile 161
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_10I", Zeile 332
hello,

I´ve found maybe a data-problem, a few of data like
"MDSYS"."SDO_GEOMETRY"(3007,31468,NULL,....   are in the database.

3007 is a MultiPolygon.........
----------------------------------------------------------------------------

the normal data case will work:

Insert into GRUEN_POLY
   (OBJECTID,
    GE_CODE, TYP2, TYP3, GRUEN_GRUE, FLAECHE_HA,
    SHAPE, SE_ANNO_CAD_DATA, OGR_FID)
 Values
   (22, 12, 3, 3, 4535.999797,
    0.4536,
    "MDSYS"."SDO_GEOMETRY"(3003,31468,NULL,
    "MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1),

"MDSYS"."SDO_ORDINATE_ARRAY"(4459968.99526779,5337888.99718524,0,4459967.99526795,5337895.49718417,0,4459968.49526787,5337900.49718335,0,4459971.49526738,5337906.49718236,0,4459973.99526696,5337911.49718154,0,4459977.49526639,5337919.99718014,0,4459982.49526556,5337928.99717866,0,4459985.99526499,5337936.49717742,0,4459990.49526425,5337945.49717594,0,4459993.99526367,5337952.49717479,0,4459997.99526301,5337960.99717339,0,4459999.99526268,5337966.49717248,0,4460000.4952626,5337975.99717092,0,4460001.49526244,5337989.49716869,0,4460001.49526244,5337998.99716713,0,4460000.99526252,5338007.49716573,0,4459999.99526268,5338017.997164,0,4459998.49526293,5338023.99716302,0,4459994.99526351,5338031.49716178,0,4459991.995264,5338036.99716087,0,4459987.99526466,5338043.99715972,0,4459983.99526532,5338048.9971589,0,4459980.49526589,5338053.99715808,0,4459975.99526663,5338059.49715717,0,4459972.49526721,5338063.49715651,0,4459967.99526795,5338068.99715561,0,4459963.99526861,5338073.99715478,0,4459960.9952691,5338078.99715396,0,4459957.49526968,5338084.99715297,0,4459954.99527009,5338091.4971519,0,4459953.49527034,5338097.99715083,0,4459952.99527042,5338103.49714993,0,4459952.99527042,5338109.99714886,0,4459953.49527034)),
NULL, 1)
/      

-----
Kornel Kiss

Referat für Gesundheit und Umwelt
Anforderungsmanagement Fachanwendungen
Bayerstr. 28a
80335 München
--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5203937.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/20100621/0a5560ba/attachment.htm 