[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