<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
hello <font face="Courier New" size="2"><font face="Times New Roman"
size="3">Juan Lucas,<br>
<br>
thanks for your mail.<br>
</font></font><br>
<blockquote
cite="mid:E43C32BC5843E34FB4C00CDFAAAAF7D8017B5081@australia.prodevelop.local"
type="cite">
<div id="idOWAReplyText8259">
<div> </div>
<div><font color="#000000" face="Times New Roman" 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>
</blockquote>
<br>
<blockquote
cite="mid:E43C32BC5843E34FB4C00CDFAAAAF7D8017B5081@australia.prodevelop.local"
type="cite">
<div id="idOWAReplyText8259">
<div><font color="#000000" face="Times New Roman" size="3"> <i>yes
the shape-file runs in gvSIG</i><br>
</font></div>
<div> </div>
<div><font color="#000000" face="Times New Roman" 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 color="#000000" face="Times New Roman" size="3"><a
moz-do-not-send="true"
href="http://www.prodevelop.es/files/fm/public/downloads/oracle_test_00.png"
target="_top" rel="nofollow" link="external">http://www.prodevelop.es/files/fm/public/downloads/oracle_test_00.png</a></font></div>
<div> </div>
<div><font color="#000000" face="Times New Roman" size="3">Add the
table three times, using a different SQL filter each time:</font></div>
<div> </div>
<div><font color="#000000" face="Times New Roman" size="3">c.SHAPE.SDO_GTYPE
= 3003</font></div>
<div><font color="#000000" face="Times New Roman" size="3">c.SHAPE.SDO_GTYPE
= 3007</font></div>
<div><font color="#000000" face="Times New Roman" size="3">ROWNUM
< 500</font></div>
<div> </div>
<div><font color="#000000" face="Times New Roman" 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>
</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
cite="mid:E43C32BC5843E34FB4C00CDFAAAAF7D8017B5081@australia.prodevelop.local"
type="cite">
<div id="idOWAReplyText8259">
<div><font color="#000000" face="Times New Roman" 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 color="#000000" face="Times New Roman" size="3"><a
moz-do-not-send="true"
href="http://listserv.gva.es/pipermail/gvsig_internacional/2010-April/005196.html"
target="_top" rel="nofollow" link="external">http://listserv.gva.es/pipermail/gvsig_internacional/2010-April/005196.html</a></font></div>
<div> </div>
<div><font color="#000000" face="Times New Roman" 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>
</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
cite="mid:E43C32BC5843E34FB4C00CDFAAAAF7D8017B5081@australia.prodevelop.local"
type="cite">
<div id="idOWAReplyText8259">
<div> </div>
<div><font color="#000000" face="Times New Roman" 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>
</blockquote>
<br>
<br>
<blockquote
cite="mid:E43C32BC5843E34FB4C00CDFAAAAF7D8017B5081@australia.prodevelop.local"
type="cite">
<div id="idOWAReplyText8259">
<div> </div>
<div><font color="#000000" face="Times New Roman" 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></font></font></div>
<div>
<div><font face="Courier New" size="2"><font face="Courier New"
size="2"><font face="Courier New" size="2">Tlf.: 96.351.06.12 -- Fax:
96.351.09.68<br>
</font><a moz-do-not-send="true" href="http://www.prodevelop.es/"
target="_top" rel="nofollow" link="external"><font face="Courier New"
size="2">http://www.prodevelop.es</font></a><br>
<font face="Courier New" size="2">---</font></font></font></div>
</div>
</div>
<div><br>
<hr>
<font face="Tahoma" size="2"><b>De:</b> <a moz-do-not-send="true" href="/user/SendEmail.jtp?type=node&node=5204926&i=0&by-user=t" target="_top" rel="nofollow" link="external">[hidden email]</a> en nombre de K.Kiss<br>
<b>Enviado el:</b> lun 21/06/2010 13:54<br>
<b>Para:</b> <a moz-do-not-send="true" href="/user/SendEmail.jtp?type=node&node=5204926&i=1&by-user=t" target="_top" rel="nofollow" link="external">[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" cols="72">--
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="/images/icon_attachment.gif" > <strong>send2JL.zip</strong> (1M) <a href="/attachment/5208477/0/send2JL.zip" target="_top">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" width="300">
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>