[Gvsig_english] new problems with an oracle layer
Juan Lucas Dominguez Rubio
jldominguez at prodevelop.es
Thu Jun 24 22:58:16 CEST 2010
Hello, Kornel & Wolfgang:
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.
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?
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?
You can send the files privately if you prefer not to publish all that data.
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/20100624/844417e0/attachment.htm
More information about the Gvsig_internacional
mailing list