[Gvsig_english] new problems with an oracle layer
Juan Lucas Dominguez Rubio
jldominguez at prodevelop.es
Tue Jun 22 16:06:12 CEST 2010
Hello, Kornel.
Sorry, I cannot download the attachment send2jl.zip
can you send it again please?
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: mar 22/06/2010 14:21
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] new problems with an oracle layer
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] en nombre de K.Kiss
Enviado el: lun 21/06/2010 13:54
Para: [hidden email]
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.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)),
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.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)),
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
<https://correo.prodevelop.es/images/icon_attachment.gif> send2JL.zip (1M) Download Attachment
Kornel Kiss
Referat für Gesundheit und Umwelt
Anforderungsmanagement Fachanwendungen
Bayerstr. 28a
80335 München
________________________________
View this message in context: re:re: new problems with an oracle layer <http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5208477.html>
Sent from the gvSIG international mailing list archive <http://osgeo-org.1803224.n2.nabble.com/gvSIG-international-f2009903.html> at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100622/3c83416e/attachment.htm
More information about the Gvsig_internacional
mailing list