<HTML><HEAD>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18372"></HEAD>
<BODY>
<DIV id=idOWAReplyText8178>
<DIV><FONT color=#000000 size=3 face="Times New Roman">Hello, Kornel & Wolfgang:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">Within a few days, the gvSIG source code repository will not accept new commits for the upcoming version (gvSIG 1.10 RC1) and I'd like to solve the issues you have found in one of your tables.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">I think you were going to send me the script that reproduces the Oracle Spatial table PLAN.GRUEN_POLY. Will you please do it as soon as possible?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">I think this thread started with an error (while exporting an Oracle Spatial table to SHP) reported by Wolfgang. Is it possible to send the that table too?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">You can send the files privately if you prefer not to publish all that data.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">Regards,</FONT></DIV>
<DIV><FONT size=2 face="Courier New"><FONT size=3 face="Times New Roman">Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature67921>
<DIV><FONT size=2 face="Courier New"><FONT size=2 face="Courier New"><FONT size=2 face="Courier New">Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT size=2 face="Courier New">Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT size=2 face="Courier New">http://www.prodevelop.es</FONT></A><BR><FONT size=2 face="Courier New">---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT size=2 face=Tahoma><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de K.Kiss<BR><B>Enviado el:</B> mar 22/06/2010 14:21<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>hello <FONT size=2 face="Courier New"><FONT size=3 face="Times New Roman">Juan Lucas,<BR><BR>thanks for your mail.<BR></FONT></FONT><BR>
<BLOCKQUOTE>
<DIV id=idOWAReplyText8259>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">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></BLOCKQUOTE><BR>
<BLOCKQUOTE>
<DIV id=idOWAReplyText8259>
<DIV><FONT color=#000000 size=3 face="Times New Roman"><I>yes the shape-file runs in gvSIG</I><BR></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">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 color=#000000 size=3 face="Times New Roman"><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 color=#000000 size=3 face="Times New Roman">Add the table three times, using a different SQL filter each time:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">c.SHAPE.SDO_GTYPE = 3003</FONT></DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">c.SHAPE.SDO_GTYPE = 3007</FONT></DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">ROWNUM < 500</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">which of those 3 filters work? You can increase the 500 if it works until it does not work.</FONT></DIV>
<DIV> </DIV></DIV></BLOCKQUOTE><I><U>None</U> of the tests specified above functioned error free. All logs files are in the appendix. <BR><BR>My last test "ogr_fix_test.txt " returns in SQL the 9 data records. But GVSig runs in the same errors.......</I><BR><BR><I>Additionally I have to pull still tried from the data source a complete SQL. ("GRUEN_POLY1.sql"</I>)<BR><BR><BR><BR><BR><BR>
<BLOCKQUOTE>
<DIV id=idOWAReplyText8259>
<DIV><FONT color=#000000 size=3 face="Times New Roman">It's also possible that you are having the same problem we discussed a few months ago:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman"><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 color=#000000 size=3 face="Times New Roman">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></BLOCKQUOTE><I>yes i´m using in gvSIG-OADE the patch: "28 April 2010 - This is an informal patch that fixes some bugs in the Oracle Spatial driver in gvSIG 1.9"</I><BR><BR><BR><I>I´m using Windows 2000 2 GB -RAM GVSIG OADE1.9 / or GVSIG 1.9 with the same problems<BR><BR>gvsig.bat:<BR>command = #JAVA# -Djava.library.path="#GVSIG_INSTALL_PATH#\lib" -cp #CLASSPATH# -Xms1024M -Xmx1024M -Xss1024k com.iver.andami.Launcher gvSIG gvSIG/extensiones #ARGS#<BR></I>// In the meantime I tried it again with 1500 MB RAM for gvSIG the same errors. <BR><BR><BR>
<BLOCKQUOTE>
<DIV id=idOWAReplyText8259>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">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></BLOCKQUOTE><BR><BR>
<BLOCKQUOTE>
<DIV id=idOWAReplyText8259>
<DIV> </DIV>
<DIV><FONT color=#000000 size=3 face="Times New Roman">Regards,</FONT></DIV>
<DIV><FONT size=2 face="Courier New"><FONT size=3 face="Times New Roman">Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature62387>
<DIV><FONT size=2 face="Courier New"><FONT size=2 face="Courier New"><FONT size=2 face="Courier New">Prodevelop SL, Valencia (España)</FONT></FONT></FONT></DIV>
<DIV>
<DIV><FONT size=2 face="Courier New"><FONT size=2 face="Courier New"><FONT size=2 face="Courier New">Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT size=2 face="Courier New">http://www.prodevelop.es</FONT></A><BR><FONT size=2 face="Courier New">---</FONT></FONT></FONT></DIV></DIV></DIV>
<DIV><BR>
<HR>
<FONT size=2 face=Tahoma><B>De:</B> <A>[hidden email]</A> en nombre de K.Kiss<BR><B>Enviado el:</B> lun 21/06/2010 13:54<BR><B>Para:</B> <A>[hidden email]</A><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.997279 55,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.99715 478,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>/ </FONT><BR></P></DIV></BLOCKQUOTE><BR><PRE class=moz-signature>--
Regards,
Dipl.-Inform. (FH)
Kornel Kiss
Referat für Gesundheit und Umwelt
Steuerungsunterstützung
Anforderungsmanagement Fachanwendungen
RGU-S-IuK-AF
Bayerstr. 28a
80335 München
Telefon: +49 - 89 - 233 - 4 76 70
</PRE><BR>
<DIV class=small><BR><IMG src="https://correo.prodevelop.es/images/icon_attachment.gif"> <STRONG>send2JL.zip</STRONG> (1M) <A>Download Attachment</A></DIV>
<DIV class=signature>Kornel Kiss <BR><BR>Referat für Gesundheit und Umwelt <BR>Anforderungsmanagement Fachanwendungen <BR>Bayerstr. 28a <BR>80335 München</DIV><BR>
<HR align=left>
View this message in context: <A href="http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5208477.html">re:re: new problems with an oracle layer</A><BR>Sent from the <A href="http://osgeo-org.1803224.n2.nabble.com/gvSIG-international-f2009903.html">gvSIG international mailing list archive</A> at Nabble.com.<BR></DIV></BODY></HTML>