[Gvsig_english] new problems with an oracle layer
K.Kiss
kornel.kiss at muenchen.de
Tue Jun 22 14:21:23 CEST 2010
hello Juan Lucas,
thanks for your mail.
> 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) ;
> /yes the shape-file runs in gvSIG/
> 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.
/_None_ of the tests specified above functioned error free. All logs
files are in the appendix.
My last test "ogr_fix_test.txt " returns in SQL the 9 data records.
But GVSig runs in the same errors......./
/Additionally I have to pull still tried from the data source a complete
SQL. ("GRUEN_POLY1.sql"/)
> 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)
/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´m using Windows 2000 2 GB -RAM GVSIG OADE1.9 / or GVSIG 1.9
with the same problems
gvsig.bat:
command = #JAVA# -Djava.library.path="#GVSIG_INSTALL_PATH#\lib" -cp
#CLASSPATH# -Xms1024M -Xmx1024M -Xss1024k com.iver.andami.Launcher gvSIG
gvSIG/extensiones #ARGS#
/// In the meantime I tried it again with 1500 MB RAM for gvSIG the
same errors.
> 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:* [hidden email] </user/SendEmail.jtp?type=node&node=5204926&i=0>
> en nombre de K.Kiss
> *Enviado el:* lun 21/06/2010 13:54
> *Para:* [hidden email] </user/SendEmail.jtp?type=node&node=5204926&i=1>
> *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)
> /
>
--
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
-----
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-tp5190806p5208477.html
Sent from the gvSIG international mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100622/a822d848/attachment.htm
More information about the Gvsig_internacional
mailing list