<HTML><HEAD><TITLE>Re: [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=idOWAReplyText8259>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Kornel. Thanks for sending me that shapefile.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>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)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>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:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="http://www.prodevelop.es/files/fm/public/downloads/oracle_test_00.png">http://www.prodevelop.es/files/fm/public/downloads/oracle_test_00.png</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Add the table three times, using a different SQL filter each time:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>c.SHAPE.SDO_GTYPE = 3003</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>c.SHAPE.SDO_GTYPE = 3007</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>ROWNUM < 500</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>which of those 3 filters work? You can increase the 500 if it works until it does not work.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>It's also possible that you are having the same problem we discussed a few months ago:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="http://listserv.gva.es/pipermail/gvsig_internacional/2010-April/005196.html">http://listserv.gva.es/pipermail/gvsig_internacional/2010-April/005196.html</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>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)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>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.</FONT></DIV>
<DIV> </DIV>
<DIV> </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=idSignature62387>
<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> lun 21/06/2010 13:54<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] new problems with an oracle layer<BR></FONT><BR></DIV>
<DIV><BR>
<P><FONT size=2>hello again,<BR><BR>Insert into GRUEN_POLY<BR> (OBJECTID,<BR> GE_CODE, TYP2, TYP3, GRUEN_GRUE, FLAECHE_HA,<BR> SHAPE, SE_ANNO_CAD_DATA, OGR_FID)<BR> Values<BR> (57, 1, 1, 1, 119264.494668,<BR> 11.926449,<BR> "MDSYS"."SDO_GEOMETRY"(3007,31468,NULL,<BR> "MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1,193,2003,1),<BR> <BR>"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)),<BR>NULL, 36)<BR> <BR>Error at line 351<BR>ORA-29875: Routine ODCIINDEXINSERT nicht erfolgreich ausgeführt<BR>ORA-13034: Ungültige Daten in SDO_ORDINATE_ARRAY in Objekt SDO_GEOMETRY<BR>ORA-06512: in "MDSYS.SDO_IDX", Zeile 161<BR>ORA-06512: in "MDSYS.SDO_INDEX_METHOD_10I", Zeile 332<BR>hello,<BR><BR>I´ve found maybe a data-problem, a few of data like<BR>"MDSYS"."SDO_GEOMETRY"(3007,31468,NULL,.... are in the database.<BR><BR>3007 is a MultiPolygon.........<BR>----------------------------------------------------------------------------<BR><BR>the normal data case will work:<BR><BR>Insert into GRUEN_POLY<BR> (OBJECTID,<BR> GE_CODE, TYP2, TYP3, GRUEN_GRUE, FLAECHE_HA,<BR> SHAPE, SE_ANNO_CAD_DATA, OGR_FID)<BR> Values<BR> (22, 12, 3, 3, 4535.999797,<BR> 0.4536,<BR> "MDSYS"."SDO_GEOMETRY"(3003,31468,NULL,<BR> "MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1),<BR> <BR>"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)),<BR>NULL, 1)<BR>/ <BR><BR><BR>-----<BR>Kornel Kiss<BR><BR>Referat für Gesundheit und Umwelt<BR>Anforderungsmanagement Fachanwendungen<BR>Bayerstr. 28a<BR>80335 München<BR>--<BR>View this message in context: <A href="http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5203937.html">http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5203937.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>