[Gvsig_english] new problems with an oracle layer

[Juan Lucas Dominguez Rubio]

Hello. Here is the new informal patch (instructions inside) in case you want to test it:
 
http://www.prodevelop.es/files/fm/public/downloads/oracle_spatial_patch_gvsig_1.9_30_june_2010.zip
 
Let me know if you have the same issue.
Anyway, gvSIG 1.10 is very close I think.
 
 
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 Juan Lucas Dominguez Rubio
Enviado el: mié 30/06/2010 10:52
Para: Users and Developers mailing list; gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] new problems with an oracle layer


Hello, thanks. Yes I also had those problems after using Sql Developer. The "too many arguments" problem probably occurs because the SQL interpreter does not accept such a long array in text mode, but I don't think that's a bad geometry.
 
With those 6192 geometries I have been able to reproduce the error. It is again an 'out of memory' error caused by a large resultset buffer (sorry, I did not fix it well a few days ago).
 
I have already fixed this. I'm going to send you a new patch.
This will be included in the upcoming gvSIG 1.10 
 
 
 
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 29/06/2010 16:58
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] new problems with an oracle layer




hello,

i installed the "sqldeveloper"  -32Bit -Version. It works.
But in the "sqldeveloper"-export-file are several errors existing:

http://osgeo-org.1803224.n2.nabble.com/file/n5235335/GRUEN_POLY_export.zip
GRUEN_POLY_export.zip

1.The entry  ''null'',  is not ok;   please  replace it  into -->  NULL, 
and the script will work.

By the inserting of the script it comes to several errors:  "ORA-00939: To
many arguments for the function."

6192 rows (total 6242)   are inserted in my own copy.




-----
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-tp5190806p5235335.html
Sent from the gvSIG international mailing list archive at Nabble.com.
_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100630/7a8d3e40/attachment.htm